EIM Error While Docking Transaction Log is enabled: ORA-00942: table or view does not exist (Doc ID 483298.1)

Last updated on APRIL 11, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.2 [16168] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.2 [16168]
Database: Oracle 9.2.0.2
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Microsoft Windows 2000 Server SP 3

This document was previously published as Siebel SR 38-1276963461.


Symptoms

SBL-EIM-00423

We have a requirement for incremental Inserts/Updates/Deletes to Siebel Base Tables through EIM on periodic basis and the transactions should route to the mobile users.
Hence we have kept Docking Transaction Logging System Preference parameter
to 'TRUE' through Server Manager.

While testing for the first time in Test Environment the EIM task is executed but the Status become 'IN_PROGRESS' for the IF_ROW_STAT column in EIM Tables. We have not explicitly set any Docking specific parameters in the IFB Files and default is accepted.

While queried the EIM Log file it reveals that some error has occurred while logging the transaction to S_DOCK_TXN_LOG Table.
----------------
The Error message is as follows:
Generic Log    Generic Error    1        Message: Error: An ODBC error occurred,
Additional Message: Function: UTLDLogDbWriteTxnEnd; ODBC operation: SQLExecute

SQLError    Statement
      Insert into SIEBEL.S_DOCK_TXN_LOG (
           ROW_ID, CREATED, CREATED_BY, LAST_UPD, LAST_UPD_BY, MODIFICATION_NUM, CONFLICT_ID,
           OPERATION, SRC_NODE_ID, ITEM_NAME, TXN_ROW_ID, LOG_DATA_1, LOG_DATA_2, LOG_DATA_3, LOG_DATA_4, LOG_DATA_LONG_LEN,
           TXN_LAST_UPD_BY, TXN_LAST_UPD, TXN_MOD_NUM, TXN_CONFLICT_ID,
           LOG_DATA_LONG, FILE_FLG, PAR_TXN_ID,
           TXN_ID)
        Values (?, {fn now()}, ?, {fn now()}, ?, 0, '0',
           ?, ?, ?, ?, ?, ?, ?, ?, ?,
           ?, ?, ?, ?, ?, ?, ?,
           SIEBEL.S_DCK_TXN_LOG_S.nextval)

GenericLog    GenericError    1    [DataDirect][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist

Error 423: Unable to log set-based dock log transaction

Error 423: Unable to register with docking log.

----------------
We have searched the support web related to this issue and have performed the following steps but still the same problem is occuring repeatedly.

1.First we checked that SSE_ROLE is there, SADMIN has already been granted this role and this Role has also INSERT/DELETE/UPDATE/SELECT privileges on S_DOCK_TXN_LOG Table.

2.We checked the Transaction Processor, Transaction Router and Transaction Merger components are running fine.

3.We have tried with several options by explicitly changing/setting Logging parameters in IFB File
Option 1. We made parameter LOG TRANSACTIONS TO FILE = TRUE in header section and SET BASED LOGGING = FALSE in each of the Process section in IFB.Still the problem is occurring. Same ORA-00942 error occurs and Error 423: Unable to log row-based dock log transaction.


Option 2: We made LOG TRANSACTIONS TO FILE = FALSE in header section and SET BASED LOGGING = TRUE in each of the Process section in IFB.Still the problem is occurring. Same ORA-00942 error occurs and Error 423: Unable to log row-based dock log transaction.

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