Hi,
To get a continous series you have to set two parameters in version 7.6.04 and
forward:
# ar.cfg/conf
Next-ID-Commit:F
Next-ID-Block-Size:1
Luckily, you can set Next-ID-Block-Size on each form. So you can have it set
to 50 in general, but 1 for the forms where you need to keep your series
intact.
Best Regards - Misi, RRR AB, 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.
> Agreed - you can do it, but it doesn't really make sense to do it.
>
> Many times people doing data analysis will assume that the order of the
> entries in the system indicates the order they were created in. This is
> mostly true on single server systems. You'll still get some gaps unless your
> NEXT-ID-BLOCK-SIZE is set to 1.
>
> It's completely different if you have a server group and multiple servers.
> The Next ID block size is almost always set to a higher number like 50 and
> it's very possible for server "A" to grab 50 ID's (e.g. 1-50) and then server
> "B" grabs 51-100. And then for whatever reason the users on server "B" work
> fast and create use up their 50 well before the users on server "A". So even
> though their requests are all newer they have a higher ID.
>
> You probably know all of that, but I said all of that so I can say this: I
> always tell users/managers/etc that the Request ID signifies only one thing -
> a unique number. You cannot draw any other conclusions from it, and missing
> requests are the norm and should be ignored.
>
> William Rentfrow
> [email protected]
> Office: 715-204-3061 or 701-232-5697x25
> Cell: 715-498-5056
>
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Rick Cook
> Sent: Monday, November 03, 2014 10:13 AM
> To: [email protected]
> Subject: Re: Request ID Numbering recovery
>
> **
> Technically, yes, you can. You can go into the DB and reset the NextID
> variable for that form. However, if it's a form that's being used for entry
> (vs a config form), there's a good chance that numbers already exist that
> exceed 7002. If so, you'll get a Unique Index error when the next incremented
> Entry ID see that a record already has that number.
>
> I would ask what you would gain from such an exercise vs. the effort it would
> take you to gain it. Decide which is worth more to you.
>
> Rick Cook
>
> On Mon, Nov 3, 2014 at 7:59 AM, Sinclair, Keith
> <[email protected]<mailto:[email protected]>> wrote:
> **
> Okay, have an unusual request.
>
> If there’s a missing block of Request ID numbers, can these be recovered?
> Example, a request started at 6001. Then someone uploaded a CSV and then
> deleted the records – not me, but someone in another department did this. So
> the next legitimate request ID is 7002 or something like that.
>
> Can the numbers that were deleted, 6002 – 7001, be reused? When I first
> started out on Remedy, the answer was not really. Not sure if anything has
> changed in the years/versions since then.
>
> Specs:
> ARS 8.1
> Oracel12b DB
>
> Keith Sinclair
> Remedy Development
> ShopperTrak Chicago USA
> O: 312.676.8289<tel:312.676.8289> | M: 630.946.4744<tel:630.946.4744>
> [email protected]<mailto:[email protected]> | @shoppertrak
> www.shoppertrak.com<http://www.shoppertrak.com/>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> ________________________________
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2014.0.4765 / Virus Database: 4040/8433 - Release Date: 10/22/14
> Internal Virus Database is out of date.
>
> _______________________________________________________________________________
> 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"
