Re: Index Error

2009-05-20 Thread Grooms, Frederick W
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) [m

Re: Index Error

2009-05-20 Thread Nicky Madjarov
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 pi

Re: Index Error

2009-05-20 Thread Dwayne Martin
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 >

Re: Index Error

2009-05-20 Thread Manish SINGLA
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 Req

Re: Index Error

2009-05-20 Thread Rod Harris
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 be