That makes perfect sense. Thanks LJ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Monday, July 03, 2017 3:42 PM To: [email protected] Subject: Re: Next ID
** Mark, After setting the next id value, did you restart the remedy server? If not, if the server already had a cache of next id's that it was working with, it won't go back and figure out what the next id is till it runs out of cache :) On Mon, Jul 3, 2017 at 1:37 PM, Brittain, Mark <[email protected]<mailto:[email protected]>> wrote: ** 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<tel:(315)%20634-9337> 125 Elwood Davis Road | Syracuse NY 13212 [new_spectrum] _ARSlist: "Where the Answers Are" and have been for 20 years_ _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"
