Hi,
The standard setting since 7.6.04 is to have Next-ID-Block-Size: set to
25. You have to reset this to 1 to disable this, but that might have a slight
impact on performance. This can be set in the ar.conf/cfg file or in the Server
Information form on the Configuration tab. If you have Next-ID-Commit: set to
F, it will definitely affect performance on creates. But this defaults to T,
which is ok if you can live with a few missing Request IDs now and then
(typically after filter errors during submit). You can however set the
Next-ID-Block-Size to 1 on a form basis. This is done on the form properties
Basic section.
Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* 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
(http://rrr.se)
July 3, 2017 9:51 PM, "Brittain, Mark" wrote:
That makes perfect sense. Thanks LJ
From: Action Request System discussion list(ARSList)
[mailto:[email protected] (mailto:mailto:[email protected])] On Behalf Of
LJ LongWing
Sent: Monday, July 03, 2017 3:42 PM
To: [email protected] (mailto:[email protected])
Subject: Re: Next ID
**
Mark,
After setting the next id value, did you restart the remedy server? If
not, if the server already had a cache of next id's that it was working with,
it won't go back and figure out what the next id is till it runs out of cache
:)
On Mon, Jul 3, 2017 at 1:37 PM, Brittain, Mark wrote:
**
Hi All,
Have a weird behavior when attempting to set the next id on a form. I
followed the directions and set the nextID to 120400.
update arschema set nextId =120400 where name = ‘customformname’
commit
Then I did a query and confirmed the nextId is 120400. Finally I
created a new record on customformname and got a request id 120208
Not sure what I am doing wrong. On Oracle 12 and AR Server 9.
Thanks
Mark
Mark Brittain | Senior Systems Engineer | 315.634.9337
(javascript:false)
125 Elwood Davis Road | Syracuse NY 13212
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_ _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"
