[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

ARERR 552 - when saving a record



Hello All,

I'm getting following error when saving a record. Checked all the field values and everything is correct.
ARERR [552] The SQL database operation failed. : Arithmetic overflow error converting expression to data type int.

Following in SQL errors -
UPDATE arschema SET nextId = nextId + 25 OUTPUT inserted.nextId WHERE schemaId = 1256
OK
ROLLBACK TRANSACTION


nextID = 2147483640  in arschema for schemaID 1256
max requestId in the form is 2147453907

Number of records in form = 36836

Could this be an issue with generating a requestId? I'm not having any issue updating a record manually or via import.

Thanks!
Kaur 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"