Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

what is broadlog id primary sequenec

Avatar

Level 4

what is differnevcet between primaru and primary key sequence in adibe

pleqse help me to und what is the usage of defjnj h pk sequence in adobe schema

i want to underatand in layman langauage

1 Accepted Solution

Avatar

Correct answer by
Administrator

Hi @Shruti1,

This has been answered in another query thread authored by you: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/broadlog-id-primar...

 

Kindly refer here for the solution. 

 



Sukrity Wadhwa

View solution in original post

3 Replies

Avatar

Community Advisor

Hello @Shruti1,

primary key is unique record identifier and primary key sequence is function how that key is generated. Take a look at following atricle:

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

You can create your own or use ones adobe campaign has already added. 

Definition:
In SQL, a sequence is a database object that generates a sequence of numeric values. It is often used to generate unique identifiers for rows in a table. Sequences are typically used to provide a unique number for primary keys or other columns that require unique values.

 

In adobe campaign when you reach the end of the sequence the sequence reset from the begining. When this happens usually we set update the sequence to start from negative number.
https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/database-...

 

Marcel Szimonsiz

Avatar

Level 4

we are using sql data base ...please help me to know how can we put sequnece in negative values

 

this is much needed ar this moment

we are havjng show stopper issue because of this??

 

please please help me with any doc or steps if you have

how can we put sequnqce in negative numbers

 

i need conplete process asap

Avatar

Correct answer by
Administrator

Hi @Shruti1,

This has been answered in another query thread authored by you: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/broadlog-id-primar...

 

Kindly refer here for the solution. 

 



Sukrity Wadhwa