We are experiencing this issue in our production environment today and was wondering if anyone has come across this.
Object Server 01: The database reported (session 279 (<user id>)): [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting IDENTITY to data type int.. The SQL statement was: "UPDATE PURCHLINE SET DELIVERYDATE=?,RECVERSION=?,MODIFIEDDATETIME=? WHERE ((RECID=?) AND (RECVERSION=?))"
We've come to the conclusion that the RecVersion field is attempting to exceed the max value of INT. Any suggestions on how to fix this? Our only thought so far is to extend all RecVersion fields to a big int. Thoughts?
*This post is locked for comments