I have seen this happen because a unique indexed field had multiple NULL values in it. Might check for that, too. Rick _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, January 08, 2007 12:01 PM To: [email protected] Subject: Re: Why would import give me this error? ** Chris, Its probably not the change form that you are getting this error on then.. There must be some other form that this import is causing a modify or submit to that is causing a violation of an index. Can you take a filger log and take a look at the all the Push-Field actions that are triggered as a result of this import. That might give you some clue. An SQL log coupled with the filter log would be even more useful. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: "danaceau, Christopher M" <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, January 8, 2007 2:30:15 PM Subject: Why would import give me this error? Listers, ARS 6.03 Solaris OS Sybase 12.5.1 DB ITSM 5.5 heavily customized. I'm trying to import data into an existing change record, mapping the change id and the data field. I'm basically attempting a data transfer from one field to another. Export Change ID and current data, import change ID and data to new field. I have my duplicate preferences set to "Update Old Record with New Records Data." I STILL get a unique index error (ARERR 382). There are no user defined unique indexes on our Change form. My filter logs don't show a push to another form. Could this be coming from the Change ID (1) despite my duplicate preferences? TIA, -- Chris Danaceau 703-833-2459 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

