what is broadlog id primary sequenec | Community
Skip to main content
Level 4
December 2, 2023
Solved

what is broadlog id primary sequenec

  • December 2, 2023
  • 1 reply
  • 1338 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sukrity_Wadhwa

Hi @shruti1,

This has been answered in another query thread authored by you: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/broadlog-id-primary-sequence-exhaustion-causing-duplicate-key/m-p/636779

 

Kindly refer here for the solution. 

 

1 reply

Marcel_Szimonisz
Community Advisor
Community Advisor
December 2, 2023

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-reference/database-mapping.html?lang=en#management-of-keys

 

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-maintenance/application-objects.html?lang=en

 

Marcel Szimonsiz

Shruti1Author
Level 4
December 3, 2023

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

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity ManagerAccepted solution
Community Manager
December 5, 2023

Hi @shruti1,

This has been answered in another query thread authored by you: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/broadlog-id-primary-sequence-exhaustion-causing-duplicate-key/m-p/636779

 

Kindly refer here for the solution. 

 

Sukrity Wadhwa