Hi Karthick,
Next-ID-Commit : When the system generates the next ID number for a record in the database, it performs a new commit transaction if this parameter is set to T (true). If the parameter is set to F (false), the transaction to generate the next ID is included as part of the create entry transaction. Set the value to T to increase efficiency and for debugging. The default is F. NextID-Block-Size : Allocates next IDs in blocks rather than one at a time. Allocating in blocks increases performance during a create operation. Edit the NextID-Block-Size value to a positive number (up to 1000), for example: NextID-Block-Size: 50 The default value is 1. If 0 or a negative number (for example, -1) is used, the server will use the default value of 1. You do not need to restart the server for the change to take effect. The option is started immediately. To disable this option, set the value of NextID-Block-Size to 1, or remove the parameter from the configuration file. Note that this option does not work with Informix databases. I would suggest, to add both the parameters in ar.cfg on Prod box. Set the values as follows: Next-ID-Commit: T NextID-Block-Size: 100 Regards, Snehal From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Tuesday, August 20, 2013 9:42 AM To: arslist@ARSLIST.ORG Subject: Sequence issue in Request ID while creating tickets ** Hi All, We have Sequence issue in Request ID while creating tickets in prod Remedy . Here are the few example numbers seem to be jumping and skipping the next in sequence. 000000002930522 000000002930521 000000002930518 000000002930515 I have replicated the issue in Dev box and it seems to be working fine with sequence order. I have noticed the ar.cfg file and it has Next-ID-Commit: F and Next Request ID Block Size 1. i couldn't find the same in Production ar.cfg file. I tried adding those details, but still nothing happens. do i really need to restart the services. Please provide your idea on this. Remedy Version is 7.1 Patch 006 Windows 2003 SQL 2005 DB Thanks and Regards, Karthick S _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"
