Siebel Remote: Applying txns step during Synchronization can result in memory leak and errors SBL-DCK-00168 and SBL-MRG-00103 (Doc ID 2221394.1)

Last updated on MAY 20, 2019

Applies to:

Symptoms

Siebel Remote - on version: 8.1.1.14 [IP2014]

ACTUAL BEHAVIOR
----------------------- 
While synchronizing Siebel Remote client, during applying step of DX files and transactions (txns) to Local database, a generic error message displayed is: Unable to Apply database changes.

Checking detailed logs, one of these behaviours were noticed:

ERRORS
---------------

1) First sequence of error messages in detailed logs:

GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 Message: GEN-07,
Additional Message: Allocating pBuf
GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 Message: GEN-10,
Additional Message: Calling Function: TxnLogStmtCreate; Called Function: UTLDLogStmtBindInCol DLOG_INS_TXN_IN_LOG_DATA_CLOB
GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 Message: GEN-10,
Additional Message: Calling Function: UTLDLogDbWriteOpen; Called Function: TxnLogStmtCreate pDlog->hDbWriteTxn
GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 (mrgmain.cpp (442) err=1638503 sys=2) SBL-MRG-00103: Error opening transaction table for write
GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 Message: GEN-03,
Additional Message: File: C:\SIEBEL\81\Client_1\Local\inbox\00131497.dx. Last successfully read txn id is ??????????. Last committed txn id is ?????????????.
GenericLog GenericError 1 00000004575511c0:0 2016-06-06 10:07:58 (da_txnmerge.cpp (745) err=1114280 sys=0) SBL-DCK-00168: Unable to apply database transactions. Please refer to the detailed log messages elsewhere in this file.

2) Or alternately the second set of messages seen:

GenericLog GenericError 1 0000000457c40f88:0 2016-08-29 06:01:24 (mrgmain.cpp (985) err=3001 sys=0) SBL-GEN-03001: Error allocating sqlSelStrId
GenericLog GenericError 1 0000000457c40f88:0 2016-08-29 06:01:24 Message: GEN-03,
Additional Message: File: C:\Siebel\8.1.1.14.0\Client\Local\inbox\00185838.dx. Last successfully read txn id: 234781399. Number of txns committed: 0.
GenericLog GenericError 1 0000000457c40f88:0 2016-08-29 06:01:24 (da_txnmerge.cpp (745) err=1114280 sys=0) SBL-DCK-00168: Unable to apply database transactions. Please refer to the detailed log messages elsewhere in this file.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Remote users having a large number of DX files and transactions to be applied cannot complete that apply step without errors.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.