Yea, we are not moving data, the data is already there. We are just updating existing forms that have new fields added, there are a few new forms but they migrated just find. This is happening to existing forms.
Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi Sent: Tuesday, April 27, 2010 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Migrator 7.1 patch 009 Issue 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) <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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"