Re: Sequence issue in Request ID while creating tickets
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.comwrote: ** 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. ** ** 2930522 2930521 2930518 2930515 ** ** 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_
Re: Sequence issue in Request ID while creating tickets
Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.se wrote: 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.comwrote: ** 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. ** ** 2930522 2930521 2930518 2930515 ** ** 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
Re: Sequence issue in Request ID while creating tickets
Hi, In 7.1 the default behavior is the same as the setting I suggested: Next-ID-Commit: F NextID-Block-Size: 1 In other words it does not matter if you have the above lines in your ar.conf or you remove them completely. Have you checked the form-specific setting in forms where you are experiencing this problem? Is the block size set to 1? Check your configuration documentation pdf to see which parameters require a restart of your server. If you just manually change the config, you might need to run arsignal to make the config catch. Best Regards - Misi, RRR AB, http://rrr.se Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.se wrote: 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.comwrote: ** 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
Re: Sequence issue in Request ID while creating tickets
Just an idea - do you have incoming email workflow to create tickets? If yes, check the messages to be sure they have been processed. The unprocessed messages can cause jumps in request IDs. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, August 21, 2013 6:25 AM To: arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: 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.semailto: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.commailto:snehal.mha...@vyomlabs.comwrote: ** 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.ORGmailto:arslist@ARSLIST.ORG] *On Behalf Of *Karthick S *Sent:* Tuesday, August 20, 2013 9:42 AM *To:* arslist@ARSLIST.ORGmailto: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. ** ** 2930522
Re: Sequence issue in Request ID while creating tickets
Hi Sandra, You are correct we have integration, were tickets will be create through that as well. Actually in dev the integration is switched off. Regards. On Wed, Aug 21, 2013 at 9:41 PM, Hennigan, Sandra sandra.henni...@usdoj.gov wrote: ** Just an idea – do you have incoming email workflow to create tickets? If yes, check the messages to be sure they have been processed. The unprocessed messages can cause jumps in request IDs. ** ** Thank you, ** ** Sandra Hennigan Remedy Developer ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Karthick S *Sent:* Wednesday, August 21, 2013 6:25 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Sequence issue in Request ID while creating tickets ** ** ** Hi Misi, ** ** My remedy version is 7.1 version. ** ** On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.se wrote: 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.comwrote: ** 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
Re: Sequence issue in Request ID while creating tickets
Karthick, Remedy will roll thru the waiting messages, trying to add a new ticket and assign a request ID then fail if a request cannot be submitted then starts back at the messages again. After a message has been processed, I have workflow to set the Status to Closed and workflow set to ignore messages with a Status of Closed. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, August 21, 2013 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Hi Sandra, You are correct we have integration, were tickets will be create through that as well. Actually in dev the integration is switched off. Regards. On Wed, Aug 21, 2013 at 9:41 PM, Hennigan, Sandra sandra.henni...@usdoj.govmailto:sandra.henni...@usdoj.gov wrote: ** Just an idea - do you have incoming email workflow to create tickets? If yes, check the messages to be sure they have been processed. The unprocessed messages can cause jumps in request IDs. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, August 21, 2013 6:25 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: 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.semailto: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.commailto:snehal.mha...@vyomlabs.comwrote: ** 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
Re: Sequence issue in Request ID while creating tickets
Kathy, Are you running a server group or have multiple AR servers interacting with the same database? I saw that Lisa Singh had asked the same question, but didn't see an answer. We too have experienced what Lisa experienced. In our case, we had a backup ARServer that only a couple of people used and that server would vend numbers from its cached block of numbers that could be off as much as 2000-3000 from the server that the majority of the users were utilizing. Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Wednesday, August 21, 2013 8:35 AM To: arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Karthick, Remedy will roll thru the waiting messages, trying to add a new ticket and assign a request ID then fail if a request cannot be submitted then starts back at the messages again. After a message has been processed, I have workflow to set the Status to Closed and workflow set to ignore messages with a Status of Closed. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, August 21, 2013 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Hi Sandra, You are correct we have integration, were tickets will be create through that as well. Actually in dev the integration is switched off. Regards. On Wed, Aug 21, 2013 at 9:41 PM, Hennigan, Sandra sandra.henni...@usdoj.gov wrote: ** Just an idea - do you have incoming email workflow to create tickets? If yes, check the messages to be sure they have been processed. The unprocessed messages can cause jumps in request IDs. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, August 21, 2013 6:25 AM To: arslist@ARSLIST.ORG Subject: Re: Sequence issue in Request ID while creating tickets ** Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.se wrote: 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.comwrote: ** 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
Re: Sequence issue in Request ID while creating tickets
Hi Tim, We are not running server group. There is only one Ar server. On Thursday, 22 August 2013, Timothy Powell wrote: ** Kathy, Are you running a server group or have multiple AR servers interacting with the same database? I saw that Lisa Singh had asked the same question, but didn’t see an answer. We too have experienced what Lisa experienced. In our case, we had a backup ARServer that only a couple of people used and that server would vend numbers from its cached block of numbers that could be off as much as 2000-3000 from the server that the majority of the users were utilizing. ** ** Tim ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG');] *On Behalf Of *Hennigan, Sandra *Sent:* Wednesday, August 21, 2013 8:35 AM *To:* arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG'); *Subject:* Re: Sequence issue in Request ID while creating tickets ** ** ** Karthick, ** ** Remedy will roll thru the waiting messages, trying to add a new ticket and assign a request ID then fail if a request cannot be submitted then starts back at the messages again. ** ** After a message has been processed, I have workflow to set the Status to Closed and workflow set to ignore messages with a Status of Closed. ** ** Thank you, ** ** Sandra Hennigan Remedy Developer ** ** *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] *On Behalf Of *Karthick S *Sent:* Wednesday, August 21, 2013 8:13 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Sequence issue in Request ID while creating tickets ** ** ** Hi Sandra, ** ** You are correct we have integration, were tickets will be create through that as well. ** ** Actually in dev the integration is switched off. ** ** Regards. ** ** On Wed, Aug 21, 2013 at 9:41 PM, Hennigan, Sandra sandra.henni...@usdoj.gov wrote: ** Just an idea – do you have incoming email workflow to create tickets? If yes, check the messages to be sure they have been processed. The unprocessed messages can cause jumps in request IDs. Thank you, Sandra Hennigan Remedy Developer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Karthick S *Sent:* Wednesday, August 21, 2013 6:25 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Sequence issue in Request ID while creating tickets ** Hi Misi, My remedy version is 7.1 version. On Wed, Aug 21, 2013 at 6:36 PM, Misi Mladoniczky m...@rrr.se wrote: H _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
Re: Sequence issue in Request ID while creating tickets
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.comwrote: ** 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. ** ** 2930522 2930521 2930518 2930515 ** ** 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
Re: Sequence issue in Request ID while creating tickets
On 8/20/13, Karthick S karthick...@gmail.com wrote: I have one doubt, it works fine in Dev remedy server with the parameter detail. Do you have multiple servers? We found when adding another server the numbers looked out of sequence because it was using IDs from both servers' blocks. Our block size is 100, so we'd get IDs out of sequence between by 100-200 numbers, depending on which server's ID block it pulled the ID from. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Sequence issue in Request ID while creating tickets
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.comwrote: ** 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. ** ** 2930522 2930521 2930518 2930515 ** ** 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
Re: Sequence issue in Request ID while creating tickets
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.comwrote: ** 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. ** ** 2930522 2930521 2930518 2930515 ** ** 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
Re: Sequence issue in Request ID while creating tickets
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. 2930522 2930521 2930518 2930515 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