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"
