There are a few ways to correct depending on what you need ... a. You can reset the NextID in the ARSCHEMA table b. You can adjust the max by changing the size of the Request ID field in the form
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Su Kaur Sent: Monday, December 12, 2016 10:02 AM To: [email protected] Subject: Re: ARERR 552 - when saving a record How to fix this issue? Thanks! Kaur -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Monday, December 12, 2016 9:40 AM To: [email protected] Subject: Re: ARERR 552 - when saving a record Yes. The SQL log shows you have reached the MAX for the Request ID 2147483640 = ID you are trying to set 2147453907 = Max Request ID allowed -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kaur Sent: Monday, December 12, 2016 9:16 AM To: [email protected] Subject: 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
