Hi,
I presume your version is 7.6.04 or later.
You MUST have the following in your ar.cfg if you want unbroken request id
chains created in chronilogical order for all forms:
Next-ID-Commit: F
NextID-Block-Size: 1
And it does work. I have tried it many times.
If you are after something other than an unbroken chain of request ids, please
explain.
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 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
