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" <marti...@jmu.edu>
Newsgroups: public.remedy.arsystem.general
To: <arslist@ARSLIST.ORG>
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 <manish.sin...@st.com>
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"