Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Negative values in autopk field

Avatar

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

Avatar

Correct answer by
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

4 Replies

Avatar

Correct answer by
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

Avatar

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

Avatar

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

Avatar

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