Please restart the server, as normally there is block for next field id and once server consumes all id from the block it goes to db for next block. So till block is not consumed, server will compute nextid internally only and will not go to db.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: 04 July 2017 01:07 To: [email protected] Subject: Next ID ** Hi All, Have a weird behavior when attempting to set the next id on a form. I followed the directions and set the nextID to 120400. update arschema set nextId =120400 where name = 'customformname' commit Then I did a query and confirmed the nextId is 120400. Finally I created a new record on customformname and got a request id 120208 Not sure what I am doing wrong. On Oracle 12 and AR Server 9. Thanks Mark Mark Brittain | Senior Systems Engineer | 315.634.9337 125 Elwood Davis Road | Syracuse NY 13212 [new_spectrum] _ARSlist: "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"
