Thanks Drew.... Yep I looked at the db and looked at any table that looked like it might contain the incident number but couldn't find it.
Isn't an H table just Status History records though? I'll post it if I find the answer... Thanks again for your responses.... Mary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Thursday, December 06, 2007 3:42 PM To: arslist@ARSLIST.ORG Subject: Re: Resetting Incident Number to 1 Mary, I get it now, but I don't think I can help. A copy of Oracle SQL Developer will give you a view where you can see all the tables and the next record id, so you would be able to find 18429 and that may help solve the puzzle. One of the guys here says to recache the arserver and try again, or maybe it's an H table. Drew On Thu, 6 Dec 2007, Mary Dollus wrote: > Hi Drew, > > Well that's just it... > > Schemaid 1247 is the HPD:Help Desk form,,,, and the nextid field seems to > contain the next 'request id' number.. however as you can see from the log > below, it sets UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 1247 > > But that's the request id field... > > But then it sets > > */INSERT INTO H1247 (entryId,T0,U0,T1,U1) VALUES > ('INC000000018430',1196971076,'mtdollu',1196971076,'mtdollu') > > One of the values is 'INC000000018430' which is really the incident id. > > When I look at the db, the value in nextid is 371... not 18429. > > So seemingly I'd set the nextid field.. but where in the world is the system > coming up with 18430? > > Sorry if it's very simple and I'm making it overly complicated....:( > > Thanks!! > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller > Sent: Thursday, December 06, 2007 2:36 PM > To: arslist@ARSLIST.ORG > Subject: Re: Resetting Incident Number to 1 > > Mary, forgive me if I'm giving an answer you already know...wouldn't you > reset whatever table schemaId=1247 is? > > Drew > > > On Thu, 6 Dec 2007, Mary Dollus > wrote: > >> Below is the log entry that sets the number.. it's using $LASTID$ to get > the >> Incident number... where can that be reset? Thanks again!!! >> >> >> <ACTL> Checking HPD:INC:GIN_010_SetINCNumber-P (10) >> <ACTL> -> Passed qualification -- perform if actions >> <ACTL> 0: Push Fields >> <ACTL> To Schema HPD:CFG Ticket Num Generator on Server @ >> <ACTL> (2) = mtdollu >> >> <API > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1005 */+CE ARCreateEntry -- schema HPD:CFG Ticket >> Num Generator from Remedy User (protocol 12) at IP address 192.168.1.64 >> <FLTR> <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1010 */Start filter processing -- Operation - CREATE >> <FLTR> <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> HPD:CFG Ticket Num Generator - <NULL> >> <FLTR> <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1186 */ End of filter processing (phase 1) >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1187 */UPDATE arschema SET nextId = nextId + 1 WHERE >> schemaId = 1247 >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1212 */OK >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1212 */SELECT nextId FROM arschema WHERE schemaId = >> 1247 >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1227 */OK >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1230 */INSERT INTO T1247 (C2,C179,C7,C8,C3,C5,C6,C1) >> VALUES >> > ('mtdollu','AG216371749900R1hURAETcyMAnXMA',1,'.',1196971076,'mtdollu',11969 >> 71076,'INC000000018430') >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1290 */OK >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1291 */INSERT INTO H1247 (entryId,T0,U0,T1,U1) VALUES >> ('INC000000018430',1196971076,'mtdollu',1196971076,'mtdollu') >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1352 */OK >> <SQL > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.1353 */COMMIT WORK >> <FLTR> <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.3304 */ Restart of filter processing (phase 3) >> <FLTR> <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.3305 */Stop filter processing >> <API > <TID: 0000000031> <RPC ID: 0000009710> <Queue: Fast > >> <Client-RPC: 390620 > <USER: mtdollu >>> /* Thu >> >> Dec 06 2007 13:57:56.3305 */-CE OK -- New ID INC000000018430 >> >> -----Original Message----- >> From: Mary Dollus [mailto:[EMAIL PROTECTED] >> Sent: Thursday, December 06, 2007 1:54 PM >> To: 'arslist@ARSLIST.ORG' >> Subject: Resetting Incident Number to 1 >> >> Hello all, >> >> I looked thru the arslist to see how this was done. What I found is that > it >> says to set the "nextid" field to 1 in the arschema table where name = >> "HPD:Help Desk". >> >> However I don't want to reset the Request ID field, just the Incident ID >> field. I also want to do the same on Problem, Change and Tasks. We've > been >> testing on a new prod box and are ready to go live this weekend and we > want >> all app ID's set back to 1 before I start importing legacy records. >> >> Has this been done by anyone? >> >> Solaris >> Oracle 10.2g >> ARS 7.0.01 patch 4 >> >> Thanks!!!! >> >> Mary Dollus >> >> > ____________________________________________________________________________ > ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
