November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
LastValue grows for table PK_tblUniqueSequence and get arithematic exception episerver 6
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'
Jun 29, 2016 13:06
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!!.
Jun 29, 2016 13:13
After debugging my colleague found out that EPiServer.DataFactory.Instance.GetDefaultPageData(..) was the issue as it create a new empty page(which in turn increments the LastValue)
We modified the code and changed to: -
var pageType = PageType.Load(PageTypeID);
var definatinPageType= pageType.Definitions.FirstOrDefault(d => d.Name == "Property");
Jul 01, 2016 10:41
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...
Jul 01, 2016 11:06
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.