Dynamics GP Extended Pricing Error

Few weeks back I have posted about this error which was repeated again yesterday with one of my customers:

Microsoft SQL Native Client SQL Server Cannot insert the value NULL into column ‘SEQNUMBR’, table dbo.IV10400, column does not allow nulls. UPDATE fails.

In my previous article I have explained everything about the issue and how it occur, this time I have decided to write a script that re-index the IV10400 table as below:

DECLARE @COUNTER INTSET @COUNTER = 30DECLARE CURR CURSOR FOR SELECT SEQNUMBR FROM IV10400DECLARE @SEQNUMBR BIGINTOPEN CURRFETCH NEXT FROM CURR INTO @SEQNUMBRWHILE @@FETCH_STATUS = 0BEGINUPDATE IV10400 SET SEQNUMBR = @COUNTER WHERE SEQNUMBR = @SEQNUMBRSET @COUNTER = @COUNTER + 30FETCH NEXT FROM CURR INTO @SEQNUMBRENDCLOSE CURRDEALLOCATE CURR

Enjoy!

Read the original post:
Dynamics GP Extended Pricing Error