Hi,
Have seen this issue couple of times before (bad implementation). A workaround that has worked involves running a sql query to update tblUniqueSequence. Please do a DB backup before attempting this query and try it in a test environment, if possible, first:
UPDATE tbluniquesequence
SET tbluniquesequence.LastValue = (select max(tblPage.ExternalFolderID)+1 from tblPage)
FROM tbluniquesequence,tblPage
WHERE
tbluniquesequence.Name = 'PageFolderID'
Yes already doing that , updating LastValue to min value but the value is increasing again and site crashes in like 2 hours or so .
You said bad implementation , I am unable to figure out the possible cause of it .
Can you point possible cause of it?
Thanks a lot for reply!!.
Ok, so you used GetDefaultPageData somewhere when you only wanted to check some values on a pagetype?
That one should only be used when creating new pages...
The LastValue för PageFolderID in table dbo.tblUniqueSequence grows very big and then this exeption comes
Arithmetic overflow error converting expression to data type int. Violation of PRIMARY KEY constraint 'PK_tblUniqueSequence'. Cannot insert duplicate key in object 'dbo.tblUniqueSequence'. The duplicate key value is (PageFolderID). Arithmetic overflow error converting expression to data type int. The statement has been terminated. The statement has been terminated. The statement has been terminated.
Tried setting LastValue to a low value but it raises very fast and then it crash agaon
This issue was there on episerver 5 R2 but we this issue on episerver 6 . Anyone faced this issue before.