Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with this error message in Siebel 98 :- [INTERSOLV][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_CONTACT_IF_U1) violated

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

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 14 Oct 2002 15:32:48 GMT
Message-ID: <3DAAE39B.E67C000F@exesolutions.com>


Shane wrote:

> 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
If the point is to extract data ... forget Siebel and just use SQL*Plus.

Oh and I love your password.

Daniel Morgan Received on Mon Oct 14 2002 - 10:32:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US