Negative values in autopk field

Avatar

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile
ukender
Level 1

19-08-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

19-08-2020

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

Answers (0)