Hi All, I tried many options whatever suggested so far. like given "*Next-ID-Commit: T , **NextID-Block-Size: 100*" and even tried "*Next-ID-Commit: F , **NextID-Block-Size: 1*, also chagened the form property "*Next Request ID Block - 1*".
Today i can see huge difference in the request ID, it giving difference of 700 and 600. Please find the below details. Case ID Difference 2928816 -791 2929607 -5 2929612 -20 2929632 -14 2929646 -71 2929717 -5 2929722 -8 On Wed, Aug 21, 2013 at 7:07 AM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > You must use the below values, which was default on systems prior to > 7.6.04: > Next-ID-Commit: F > NextID-Block-Size: 1 > > The new default is T and 25. > > You can still do the block-size of 25 to minimize bottlenecks in your > system, > and instead set the block-size to 1 on those forms that is important to > keep > in sequence. Yes, it is a form-property :-) > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > Hi Snehal, > > > > Thanks for the mail. > > > > I have one doubt, it works fine in Dev remedy server with the parameter > > detail. > > Please correct me if i am wrong. > > > > *Next-ID-Commit: F* > > > > *NextID-Block-Size: 1* > > > > > > On Tue, Aug 20, 2013 at 3:20 PM, snehal mhaske > > <snehal.mha...@vyomlabs.com>wrote: > > > >> ** > >> > >> 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_ **** > >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > > > > > > -- > > ** > > ** > > *Thanks and Regards,* > > *Karthick S* > > > > > _______________________________________________________________________________ > > 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" > -- ** ** *Thanks and Regards,* *Karthick S* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"