Re: Index Error
You say "deleting the records from target in the database". Do you mean you went in at the database and deleted all records from a table? If so did you delete all records from the related tables (T, H, and all related B tables)? Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 2:17 AM To: arslist@ARSLIST.ORG Subject: Index Error The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Index Error
Hi, You have duplicate values of unique key, so - you may have to massage your data prior to import; - you can change the index of the destination form not to be unique, and fix your data after the import. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Dwayne Martin" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, May 20, 2009 8:00 AM Subject: Re: Index Error Try just migrating half the data. If you get the error, try a quarter, etc till you pin down the offending record. Dwayne Martin James Madison University Original message Date: Wed, 20 May 2009 13:02:24 +0530 From: Manish SINGLA Subject: Re: Index Error To: arslist@ARSLIST.ORG ** Hello Bhupesh, Do increase the index values there in ARSchema table at DB level, say by some static value 500 etc. This is because when you were archiving the DB, it was in use and some indexes(At ARschema) remains lesser and at form level it exceeds. Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 12:47 PM To: arslist@ARSLIST.ORG Subject: Index Error ** The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Index Error
Try just migrating half the data. If you get the error, try a quarter, etc till you pin down the offending record. Dwayne Martin James Madison University Original message >Date: Wed, 20 May 2009 13:02:24 +0530 >From: Manish SINGLA >Subject: Re: Index Error >To: arslist@ARSLIST.ORG > > ** > Hello Bhupesh, > > Do increase the index values there in ARSchema table > at DB level, say by some static value 500 etc. This > is because when you were archiving the DB, it was in > use and some indexes(At ARschema) remains lesser and > at form level it exceeds. > > Regards > Manish > > > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Bhupesh > Gupta > Sent: Wednesday, May 20, 2009 12:47 PM > To: arslist@ARSLIST.ORG > Subject: Index Error > ** > > > The value(s) for this entry violate a unique index > that has been defined for this form > > I am facing this error while migrating data from > source to target thru rrchive tool. > > I have already rebuild all indiexes after deleting > the records from target in the database. > > Target DB is oracle and Source is SQL. > > PLease Suggest > -- > Regards, > Bhupesh Gupta > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: > "Where the Answers Are"_ _Platinum Sponsor: > rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Index Error
Hello Bhupesh, Do increase the index values there in ARSchema table at DB level, say by some static value 500 etc. This is because when you were archiving the DB, it was in use and some indexes(At ARschema) remains lesser and at form level it exceeds. Regards Manish _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 12:47 PM To: arslist@ARSLIST.ORG Subject: Index Error ** The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Index Error
Hi Bhupesh, The data you are importing must have duplicates in it. Your only options are to make sure that the data you import doesn't have duplicates or to remove the unique index. Rod On 20/05/2009, Bhupesh Gupta wrote: > ** > > > The value(s) for this entry violate a unique index that has been defined for > this form > > I am facing this error while migrating data from source to target thru > rrchive tool. > > I have already rebuild all indiexes after deleting the records from target > in the database. > > Target DB is oracle and Source is SQL. > > PLease Suggest > > -- > Regards, > Bhupesh Gupta > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"