Re: Request ID Numbering recovery

2014-11-04 Thread Nagidi Pavan
List) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan > Sent: Tuesday, November 04, 2014 1:31 PM > To: arslist@ARSLIST.ORG > Subject: Re: Request ID Numbering recovery > > ** > Hi Misi and team, > We have dumped production db to our development server, since th

Re: Request ID Numbering recovery

2014-11-04 Thread Grooms, Frederick W
discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Tuesday, November 04, 2014 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Request ID Numbering recovery ** Hi Misi and team, We have dumped production db to our development server, since then while creating

Re: Request ID Numbering recovery

2014-11-04 Thread Nagidi Pavan
gt; > a unique number. You cannot draw any other conclusions from it, and > missing > > requests are the norm and should be ignored. > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 &g

Re: Request ID Numbering recovery

2014-11-04 Thread Misi Mladoniczky
rom it, and missing > requests are the norm and should be ignored. > > William Rentfrow > wrentf...@stratacominc.com > Office: 715-204-3061 or 701-232-5697x25 > Cell: 715-498-5056 > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIS

Re: Request ID Numbering recovery

2014-11-03 Thread Charlie Lotridge
uying time for the other systems teams > to work out a new solution of handling customer’s and their equipment > before we hit that wall. > > > > Like sticking my finger in the dam whilst waiting for the heavy moving > equipment that’s already on its way to get here before the levee br

Re: Request ID Numbering recovery

2014-11-03 Thread Sinclair, Keith
. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Monday, November 03, 2014 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Request ID Numbering recovery ** Agreed - you can do it, but it doesn't really make sense to do it.

Re: Request ID Numbering recovery

2014-11-03 Thread William Rentfrow
697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, November 03, 2014 10:13 AM To: arslist@ARSLIST.ORG Subject: Re: Request ID Numbering recovery ** Technically, yes, you can. You can go into the DB and r

Re: Request ID Numbering recovery

2014-11-03 Thread Rick Cook
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 increment

Request ID Numbering recovery

2014-11-03 Thread Sinclair, Keith
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