Hrm. Not quite Resolved like I thought. I was able to import all the records via a DTS package once I cleaned out all the necessary tables. One relatively small problem though. The WUT now says all my user data is corrupt (I assume because it didn't run through the installer). If I make a change to a user record, I get an error that the User data is corrupt and that it's deleting the license (most of the records have read licenses anyway). Once I click OK and save again, it either reapplies the license (if it was fixed or floating) or simply updates the record. After the first update, everything appears to be okay.
Is there any way to automate this procedure? I tried to update all the records via Enterprise Manager (set all lictypes to NULL and then back to 0) but Remedy doesn't recognize that modification. I also tried a Modify All but when the error message pops up and I click okay, it stops the Modify All. It was suggested by a co-worker that I try an Escalation and have it add a space to the Action Log or something like that, but I suspect that's going to fail as well since it will encounter the same error on the first record it tries to update. Thanks much, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, August 27, 2008 9:27 AM To: [email protected] Subject: Re: Problem importing records *RESOLVED* Thanks a bunch Fred. What has two thumbs and forgot to delete records from the H table? Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, August 27, 2008 9:15 AM To: [email protected] Subject: Re: Problem importing records Arsql.log shows all SQL being run through the arserver. (Turn it on from the Admin Console) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, August 27, 2008 9:08 AM To: [email protected] Subject: Re: Problem importing records Arsql.log? I'm looking at the arimport.log but it's really not helping. Just tells me the same thing that the error message that pops up does. I'll check our workflow and see if anything is firing but to my knowledge, we don't have anything that pushes to another form at all. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, August 27, 2008 8:42 AM To: [email protected] Subject: Re: Problem importing records Watch the SQL log when doing the import. It should tell you exactly which table the unique record error is happening on. My thinking is that the H or B table for the User form is complaining (if you deleted the records from the database) or some workflow is firing when you do the import and pushing data to another form. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Tuesday, August 26, 2008 5:37 PM To: [email protected] Subject: Problem importing records Listers, So it appears the problem with our upgrade and it's ridiculous length was the user form (and the user_cache). When the system was conceived, the original developer used the User form as a User form and a Customer form so we're looking at 555000+ records in the User form as of now. The arsql.log file shows the installer walking each individual record in the user_cache for license information. This appears to take a fairly significant amount of time (and a lot of space). Per a discussion with BMC today, it was suggested that I export all the user records to a .arx file and then delete all but one administrator account so that the installer can run. I exported all the user records, deleted all but one admin account and upgraded in about 20 minutes from 5.1.2 to 7.0.01 (a far cry from 36 hours). After the server was upgraded, I attempted to re-import all those records and I'm getting all sorts of errors. Thousands and thousands of records will not import due to a "unique index being violated on this form". It's my understanding that Request ID and username are the only unique indexes on the user form (and for posterity's sake, I verified in both the admin tool, and enterprise manager) and I ran queries to validate that there were no duplicate usernames or request ids on the user_cache table or in the user_x view. I attempted to import using the AR Import tool and it failed miserably. I also attempted via a DTS package to copy the data from a test 5.1.2 database to our freshly upgraded 7.0 test database and that also failed miserably. I've worked myself ragged on this upgrade and made absolutely no progress. Does anyone have any idea why these records won't import? Environment is Windows Server 2003, AR Server 5.1.2 (which we upgraded to 7.0 patch 8 after exporting and deleting all those records) and database is SQL Server 2003 Thanks a bunch, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH _______________________________________________________________________________ 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"
