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"

Reply via email to