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
> <[email protected]>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:
>> [email protected]] *On Behalf Of *Karthick S
>> *Sent:* Tuesday, August 20, 2013 9:42 AM
>> *To:* [email protected]
>> *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"
