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) <christopher.pru...@hp.com> 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 > christopher.pru...@hp.com<mailto:mary.jo...@hp.com> > 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 > 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"