Re: Help with this error message in Siebel 98 :- [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_CONTACT_IF_U1) violated

shane.hancock_at_nextiraone.co.uk (Shane) wrote in news:5f898c8d.0210131701.1af94116_at_posting.google.com:

> Any help is urgently needed - we have a deadline to meet by the end of
> the week for data extraction.
>
> Does anyone have any ideas on how to resolve this error ?
>
> [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00001: unique constraint
> (SIEBEL.S_CONTACT_IF_U1) violated
>
> I am trying to extract data from Siebel Sales 98 and am using the
> following IFB file to do this through the Enterprise Integration
> Manager component in Server Tasks screen.
>
> [Siebel Interface Manager]
> USER NAME = "SADMIN"
> PASSWORD = "SADMIN"
> PROCESS = Export All Contacts
>
>
>
> [Export All Contacts]
> TYPE = SHELL
> INCLUDE = Export Contacts
>
> [Export Contacts]
> TYPE = EXPORT
> BATCH = 200202
> CLEAR INTERFACE TABLE = FALSE
> EXPORT ALL ROWS = FALSE
> EXPORT MATCHES = (FST_NAME like 'B%')
> TABLE = S_CONTACT_IF
> TABLE = S_CONTACT1_IF
> TABLE = S_CONTACT2_IF
> TABLE = S_CONTACT_DTLIF
>

Clean out the EIM table(s) prior to running your export. A primary key prohibits duplicate values. Received on Tue Oct 15 2002 - 01:48:38 CEST