Re: Created 15,000 tickets

[Susan Palmer]

**

And by doing the import with new ID's those Consolidated records will get created properly since these will be new creations.  Trying to synch everything up is a headache to say the least.  BUT, delete the old records before importing.  You'll have them in the export (arx) file which I generally make two exports for a situation like this. 

 

Map out what you want to do, think it over slowly, determine what could go wrong, change the plan if necessary, make copies of everything, then go for it.  And make sure that offending workflow is corrected or disabled.

 

Good luck ... let us know how it turns out

 

Susan

 

On 9/6/06, Nall, Roger <[EMAIL PROTECTED]> wrote:

**

Kathy,

 

I am sure this will be just one of many recommendations to not try to renumber your existing tickets using sql. There are way too many pitfalls. James' suggestion to export out your current tickets, change your next ID value, and import while creating new IDs is the best course of action.

 

Good luck.

 

Roger A. Nall

OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA

Desk: 973-644-3963

Cell: 973-652-6723

FAX: 973-267-6628

sf49fanv     AIM IM

RogerNall   Yahoo IM

 

---

From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wednesday, September 06, 2006 5:12 PM

To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000 tickets

 

Kathy:
 
It is possible to do this but I don't have the knowledge on how to do this in the database, but I have done this through an export/import.  Just set the import tool to gen new id's.

 
James McKenzie
 

________________________________

From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Wednesday, September 06, 2006 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000 tickets

 

**
Yikes!!  This is alarming.  Your advice regarding the "tickets created after the auto-generated tickets"  -- can the new tickets created today be renumbered directly in the database?

__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___