Are you importing over another AST:Asset form?
The error is stating that the data on the table is preventing it from
making a unique index.
Here is the definition of ORA-01452:
ORA-01452 cannot CREATE UNIQUE INDEX; duplicate keys found
Cause: A CREATE UNIQUE INDEX statement specified one or more columns
that currently
contain duplicate values. All values in the indexed columns
must be unique by
row to create a UNIQUE INDEX.
Action: If the entries need not be unique, remove the keyword UNIQUE
from the
CREATE INDEX statement, then re-execute the statement. If the
entries must be
unique, as in a primary key, then remove duplicate values
before creating the
UNIQUE index.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli Himanshu-NXJ743
Sent: Tuesday, March 27, 2007 10:31 AM
To: [email protected]
Subject: Error ORA-01452 CREATE UNIQUE INDEX
Hi Folks
Every time I am trying to make an import of AST:Asset form from another
Remedy server to this server I get this error
"ORA-01452 ORA-01452 CREATE UNIQUE INDEX"
The two field ID's that are shown in the reason of conflict are :-
2000000004 = > Item , DATATYPE = Character , Entry Mode = Required
2000000001 = > Serial Number , DATATYPE = Character , Entry Mode =
Required
AST:Asset Schema details
FIELDID FIELDTYPE OWNER LASTCHANGED
DATATYPE FOPTION CREATEMODE
---------- ---------------------------------------- ----------
---------- ------------------------------ ------------------------------
200000003 1 Demo Demo
4 1 1
200000004 1 Demo Demo
4 1 1
200000005 1 Demo Demo
4 1 1
200000001 1 Demo Demo
4 1 1
I have attached a screen short of the error message with this request
Please advise ...
Thanks & Regards,
Himanshu Kohli
Senior ITSM Consultant,
Wipro- Business Service Management
19023| Gallop Drive|Maryland, MD 20874
Mobile: 469.426.8475| Off: 703-860-6111| Skype: Himanshu.Kohli
[EMAIL PROTECTED] | www.cmango.com | www.wipro.com
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
