Siebel Remote : Database Extract Is Failing With Error ORA-01747 (Doc ID 2051852.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

Database Extract  is failing with the following errors ..

SQLError Statement 0 000001d455dd2148:0 2015-08-26 21:29:26 SQL Statement:

select MT1.COMMENTS,
MT1.CONFLICT_ID,
MT1.CREATED,
MT1.CREATED_BY,
MT1.DB_LAST_UPD,
MT1.DB_LAST_UPD_SRC,
MT1.LAST_UPD,
MT1.LAST_UPD_BY,
MT1.MODIFICATION_NUM,
MT1.NAME,
MT1.ORDER,
MT1.PAR_ROW_ID,
MT1.ROW_ID,
MT1.STATUS,
MT1.TEST_DESCRIPTION,
MT1.TEST_NUM,
MT1.TYPE

   from SIEBEL.S_DOCK_INITM_01 di

        ,SIEBEL.CX_TEST_PLAN MT1

  where di.NODE_ID      = '1-895BG4'

    and di.DOCK_NAME    = '1'

    and di.PR_TBL_ROW_ID = MT1.PAR_ROW_ID

    and di.VIS_STRENGTH >= 25

DBCLog DBCLogError 1 000001d455dd2148:0 2015-08-26 21:29:26 [tp][ODBC Oracle driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification


Trace TracingInfo 3 000001d455dd2148:0 2015-08-26 21:29:26 DBXTRACT: Database returned error.

Trace TracingInfo 3 000001d455dd2148:0 2015-08-26 21:29:26 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms