SessionId Uniqueness

[Rajeem_Cariazo]

Hi,
Is it possble to have the same SessionId on different ParticipantId? I am asking because we are planning to store conversation segments on our table using the primary key formula ConversationId+SessionId+SegmentCounter

I am aware that SessionId can be the same for multiple conversations that were joined by conference but this is fine because we use ConversationId as part of our primary key.

Thanks.

[Eos_Rios]

@Rajeem_Cariazo

Is it possble to have the same SessionId on different ParticipantId?

Absolutely.
I see 31 instances of it in my platform yesterday alone.

Since segments don't have a unique ID of their own my key for that branch is SessionId + ParticipantId.

@Rajeem_Cariazo

I am aware that SessionId can be the same for multiple conversations that were joined by conference but this is fine because we use ConversationId as part of our primary key.

You were on the right track but missed the fact the same entity in two conversations will have unique participant ids in each conversation, so if the session gets shared by the conversation it's also shared by the participants.

[Rajeem_Cariazo]

Thanks @Eos_Rios.
How will SessionId + ParticipantId work on sessions with multiple segments? Don't you need to add at least a Segment counter?

[Rajeem_Cariazo]

Hi @Eos_Rios,
Sorry, I didn't make it clear that what I am asking is if it is possible in a single Converstion to have multiple sessions having the same SessionId but different ParticipantId. The result you sent has different ConversationId.

The goal of my question is if to ensure that the key that I am using on my table for segments is correct: ConversationId+SessionId+SegmentCounter.

Thanks.

[Eos_Rios]

@Rajeem_Cariazo

How will SessionId + ParticipantId work on sessions with multiple segments? Don't you need to add at least a Segment counter?

Have you seen the diagram here?

I'm using a modified version of that, so session and segment are in their own tables in my recreation of the conversation tree.

@Rajeem_Cariazo

Sorry, I didn't make it clear that what I am asking is if it is possible in a single Converstion to have multiple sessions having the same SessionId but different ParticipantId. The result you sent has different ConversationId.

Not that I have seen and not that my data shows in the last 3m conversations.

[Ben_Wyatt]

@Eos_Rios

Not that I have seen and not that my data shows in the last 3m conversations.

Hopefully this discussion is helpful as corroboration:

Conversation Detail - Duplicate Session IDs

My organization has found 86 instances in the past 4 months where different conversations include sessions with the same session ID guid. The conversations typically start within a second of one another. Is this expected behavior? When modeling out conversation data, I would expect the guid to be a reasonable primary key for a table that would store session-specific data, and I would like to understand the expected behavior around these guids before I commit to that. Thanks!

In short, session IDs are unique across conversations but are not entirely unique across an org.