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"

Reply via email to