Siebel EIM >  EIM Error While Docking Transaction Log is enabled: ORA-00942: table or view does not exist

EIM Error While Docking Transaction Log is enabled: ORA-00942: table or view does not exist

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

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

Configuration/ Setup

SOLUTION

The customer was asked if the S_DCK_TXN_LOG_S sequence was defined in the Oracle database. They were then asked to check that the SSE_ROLE has privilege to access it. It was found that the S_DCK_TXN_LOG_S sequence was defined but the SSE_ROLE did not have privilege to access it.

The following SQL statement was executed to grant privilege to SSE_ROLE:

GRANT SELECT ON S_DCK_TXN_LOG_S TO SSE_ROLE;

This resolved the behavior. It was not discovered what course of actions caused the privilege not to be granted.