J..I wrote my own..I trust and don't need to verify J
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Tuesday, April 27, 2010 12:30 PM To: [email protected] Subject: Re: Remedy Migrator 7.1 patch 009 Issue ** Uggghhh...don't get me started on Migrator. My basic rule when using this tool: Trust but verify. I would use it for small migrations. I would not use it for large scale ones. In answer to your question, Chris, perhaps one of the other third-party migration tools might be more reliable? Rick On Tue, Apr 27, 2010 at 11:22 AM, Pruitt, Christopher (Bank of America Account) <[email protected]> wrote: Have anyone of you noticed this behavior from the Remedy Migrator 7.1 patch 009? Issue: We extract forms from one server and create a def file. There were 131 forms in the def file. 6 Regular 5 Joins and 120 Display Only We open the def with Migrator and convert it to a Migrator file. Ok so far. This works great. Now the issue. When we migrated the file to the new server the Migrator gave no errors. It report all imported 100%, however, when we look some or the forms they are missing fields. We query the aradmin.field table and it reports that all the fields are present. We look at the forms via the admin tool and they are not there. We even checked the Form, Select View, Fields In View and these fields are not listed. But the field table shows them in the database. We try and re-import the forms that has the missing data and we get the error message ARERR 382 violates index and it will not let us import it. We even tried to blowing away the record in the aradmin.field table, blowing away the C column in the t-table and tried changing the field count in arschema. Then import the form from another server that is a copy of the original form without the fields and did a "Delete excess fields" and then tried to re-import the form and we still get the ARERR 382 error. Environment: Remedy version: 7.1.00 Build 200708221849 OS: SunOS 5.9 Database: Oracle 10.2.0.4.0 - 64bi Two questions, Has anyone ever experiences this before? How can we fix this without blowing away the forms and re-importing them, because some has a HUGH amount of data that would take a very long time to export and re-import. Christopher Pruitt Business Consulting III HP Enterprises Services [email protected]<mailto:[email protected]> www.hp.com <http://www.hp.com/> <http://www.hp.com/> Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug10 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
