Negative values in autopk field

[ukender]

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

[Milan_Vucetic · Accepted solution]

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]

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]

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]

Hi @Milan_Vucetic Thanks I really appreciate it. could you please let me know how to check XtkNewId impacted tables?