You might try doing the migration in two steps: just the forms first, and then the data. This would let you verify the forms as Rick says before you shove in the data. If you can, I would recommend using RRRChive to move your regular forms as it handles data very well.
Regards, Chuck Baldi On Tue, Apr 27, 2010 at 2:22 PM, 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/> > > > 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"
