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"
