LastValue grows for table PK_tblUniqueSequence and get arithemati

LastValue grows for table PK_tblUniqueSequence and get arithematic exception episerver 6

Abhishek Salgaonkar

Vote:

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.

#150768

Jun 29, 2016 11:01

Shahid nawaz

Vote:

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'

#150794

Jun 29, 2016 13:06

Abhishek Salgaonkar

Vote:

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!!.

#150801

Jun 29, 2016 13:13

Abhishek Salgaonkar

Vote:

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");

#150888

Jul 01, 2016 10:41

Daniel Ovaska

Vote:

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...

#150890

Jul 01, 2016 11:06

Try our conversational search powered by Generative AI!

LastValue grows for table PK_tblUniqueSequence and get arithematic exception episerver 6