Error Importing 8.2.2 Database (Windows 64 Bit Machine, Oracle Database)
I've hit an issue importing the Siebel database. The tables seem to be created ok, but I receive an error when the data is being populated.
The error is logged in dataimp_prim_lang.log. Here's a sample from the log file. I have installed the 32 bit version of the oracle client and tested my ODBC source.
insert into SIEBEL.S_ACC_VIEW_APPL (ROW_ID,
CREATED,
CREATED_BY,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
CONFLICT_ID,
ATTRIB_TYPE,
LOCALE_CODE,
OBJECT_NAME,
OBJECT_TYPE,
DB_LAST_UPD,
ATTRIB_VALUE,
DB_LAST_UPD_SRC) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_date, ?, 'dataimp')2011-12-13 00:11:36 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_ACC_VIEW_APPL_U1) violated