Siebel Remote: Transaction Processor (TxnProc) Fails with error '[Microsoft][SQL Native Client][SQL Server]The conversion of the nvarchar value (...) overflowed an int column' (Doc ID 1909364.1)

Last updated on JULY 11, 2017

Applies to:

Siebel Remote - Version 8.1.1.5 [21229] to 8.1.1.7 [21238] [Release V8]
Information in this document applies to any platform.

Symptoms

Siebel Remote - on version 8.1.1.5 SIA [21229]:

On one of the Production servers, the Transaction Processor (TxnProc) comp is failing to process txns with errors like:

SBL-GEN-03006: Error calling function: UTLDLogDbReadTxn
SBL-DCK-00147: Error reading transaction from database.
SBL-CSC-00213: Invalid visibility database.  Shut down and restart *all* remote components using it (txnproc and txnroute) to rebuild.

It was attempted to rebuild the visdata.dbf twice, but failure still persists. TxnRoute comps seem also to be impacted by or have something to do with this behaviour.

Detailed TxnProc log was showing that component was failing every couple of iterations when reaching the transactions' clean-up stage:

----------------------------------------
...
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: Generated SQL statement:,
 Additional Message: SQLExecute:
   delete from dbo.S_DOCK_TXN_SET
    where TXN_LOG_ID in
     (select ROW_ID from dbo.S_DOCK_TXN_LOG
        where TXN_ID <= ? - 1
          and OPERATION in ('X', 'Y', 'Z', 'R', 'T', 'Q', 'L'))
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: Error: An ODBC error occurred,
 Additional Message: Function: UTLLDelMASSTxnDel; ODBC operation: SQLExecute

SQLError    Statement    0    000002fa53ba2ff8:0    2014-07-07 10:16:18    SQL Statement:
   delete from dbo.S_DOCK_TXN_SET
    where TXN_LOG_ID in
     (select ROW_ID from dbo.S_DOCK_TXN_LOG
        where TXN_ID <= ? - 1
          and OPERATION in ('X', 'Y', 'Z', 'R', 'T', 'Q', 'L'))
SQLError    Bind Variables    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    01:2232566684
DBCLog    DBCLogError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    [Microsoft][SQL Native Client][SQL Server]The conversion of the nvarchar value '2232566684' overflowed an int column.
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: Error: An ODBC error occurred,
 Additional Message: pfNativeError: 248; szSQLState: 22003; szErrorMsg: [Microsoft][SQL Native Client][SQL Server]The conversion of the nvarchar value '2232566684' overflowed an int column.
...
DBCLog    DBCLogError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: Error: An ODBC error occurred,
 Additional Message: pfNativeError: 3621; szSQLState: 01000; szErrorMsg: [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: GEN-10,
 Additional Message: Calling Function: UTLLDelClean; Called Function: UTLLDelMASSTxnDel
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    Message: GEN-10,
 Additional Message: Calling Function: LPPMainFunctionCleanTxnLog; Called Function: UTLLDelClean
...
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    (dlogdbreader.cpp (104) err=3006 sys=2) SBL-GEN-03006: Error calling function: UTLDLogDbReadTxn
...
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    (lppmain.cpp (741) err=1114259 sys=0) SBL-DCK-00147: Error reading transaction from database.
Trace    TracingInfo    3    000002fa53ba2ff8:0    2014-07-07 10:16:18    Rollback before exit
GenericLog    GenericDebug    5    000002fa53ba2ff8:0    2014-07-07 10:16:18    Process Name: Transaction Processor, Status: Completed with Errors, Message
Trace    Trace    3    000002fa53ba2ff8:0    2014-07-07 10:16:18    Error in LPPMainFunction function...
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:18    (logpp.cpp (626) err=1114259 sys=288) SBL-DCK-00147: Error reading transaction from database.
GenericLog    GenericDebug    5    000002fa53ba2ff8:0    2014-07-07 10:16:23    Process Name: Transaction Processor, Status: Completed with Errors, Message
...
GenericLog    GenericError    1    000002fa53ba2ff8:0    2014-07-07 10:16:27    (utlvdata.cpp (1447) err=1769685 sys=2220) SBL-CSC-00213: Invalid visibility database.  Shut down and restart *all* remote components using it (txnproc and txnroute) to rebuild.
...
----------------------------------------

Impact of this issue: as long as TxnProc (and TxnRoute) comps are not able to run correctly, all the remote users on affected server(s) would receive txns with delays; txns backlogs would accumulate (in Docking table and TXNPROC folder as DX files).

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