Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Negative values in autopk field

ukender
Level 3
Level 3

Dear All

 

Hope you’re doing well!

 

Issue : Negative values are generated in auto generated primary key (autopk) field, could you please help on this.

 

This was working  till  last week. now It is started generating the negative values. I don't feel there is an issue in schema,

 

Schema :

<element autopk="true" label="Service letter feedbacks" name="Service_LetterFeedBack">

 

-2099728967
-2099728966
-2099728965
-2099728964
-2099728972
2076753926
2076753927
2076753928
2076753929

 

Thanks in Advance

Ukender

1 Accepted Solution
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

Hi @ukender

you have probably reached maximum for xtkNewId. Instead of reseting (counting from 0 again) you have enabled negative sequence generation.

Check this: Link 

Regards,

Milan

View solution in original post

0 Replies
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

Hi @ukender

you have probably reached maximum for xtkNewId. Instead of reseting (counting from 0 again) you have enabled negative sequence generation.

Check this: Link 

Regards,

Milan

ukender
Level 3
Level 3

Hi @Milan_Vucetic 
Thanks for the information, It is really helpful.
Since there were lot of scripts used in the video, It would be great if you could share the document link.
Thanks

Ukender

Milan_Vucetic
Community Advisor
Community Advisor
Hi @ukender, my sugestion is to open an Adobe Support ticket for this. Of course, update on latest stable build should resolve your problem. There is not too much documentation, but you can swith to some dedicated sequence Id. Check this link: https://helpx.adobe.com/campaign/kb/sequence_auto_generation.html#Switchtoadedicatedsequence Regards, Milan
ukender
Level 3
Level 3
Hi @Milan_Vucetic Thanks I really appreciate it. could you please let me know how to check XtkNewId impacted tables?