Siebel Remote - Transaction Merger (TxnMerge) Failing With Errors SBL-TXM-00005 and 'SBL-GEN-03006: Error calling function: DICFindColumnPtrInValArr oldArray'
(Doc ID 3038771.1)
Last updated on AUGUST 05, 2024
Applies to:
Siebel Remote Client - Version 8.1.1.8 [23012] and laterInformation in this document applies to any platform.
Symptoms
On a Production Regional Node Server, the Transaction Merger (TxnMerge) component was failing with errors: SBL-TXM-00005, SBL-GEN-03006:
This component is not able to run fine even after a restart.
Error codes:
SBL-TXM-00005, SBL-GEN-03006
Extract from the TxnMerge*.log was showing:
(mrgsupd.cpp (1226) err=3006 sys=0) SBL-GEN-03006: Error calling function: DICFindColumnPtrInValArr oldArray
(mrgsupd.cpp (764) err=3006 sys=0) SBL-GEN-03006: Error calling function: DICFindColumnPtrInValArr oldArray
(mrgsupd.cpp (260) err=3006 sys=0) SBL-GEN-03006: Error calling function: DICFindColumnPtrInValArr oldArray
(mrgmain.cpp (715) err=3006 sys=0) SBL-GEN-03006: Error calling function: DICFindColumnPtrInValArr oldArray
Error with operation: Error with Txn:
Operation: U
RowId: 18X+QM-3
TableName: S_SR_ATT
Trans RowId: 18X-17O6TT
Message: GEN-03, Additional Message: File: M:\local\Code\SBA81\SES\siebsrvr\docking\MMARIUS07\inbox\00000038.dx. Last successfully read txn id: 447. Number of txns committed: 0.
Message: GEN-10, Additional Message: Calling Function: TXMMainFunction; Called Function: MRGMainFunction
(txnmerge.cpp (635) err=262149 sys=0) SBL-TXM-00005: Error in the main function. Please refer to the detailed log message elsewhere in this file.
(smishell.cpp (342) err=262149 sys=0) SBL-TXM-00005: Error in the main function. Please refer to the detailed log message elsewhere in this file.
The issue could be replicated on that specific environment with the following steps:
1. Let Regional Manager components run (RepAgent, SynchMgr and Txn* ones) and monitor their execution;
2. Notice there are some errors reported for the TxnMerger (Transaction Merger component) - either in Server Management admin views or srvrmgr command line utility;
3. Check the details - and see the reported lines in logs.
Changes
It appears that there were some changes in the Siebel schema deployed recently.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |