Remote: Transaction Router Failing with ORA-00904: invalid identifier / invalid column

(Doc ID 513524.1)

Last updated on NOVEMBER 15, 2017

Applies to:

Siebel Remote - Version 6.3 [10169] and later
Information in this document applies to any platform.

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



Checked for currency on 14-Jan-2016.
(even if initially the issue was reported on a previous release, the same error / crashing behavior for TxnRoute can occur in most recent releases - IP2014, IP15)

Symptoms

Problems were faced while trying to start Transaction Router (TxnRoute) - as it fails with the following error:

a) In TxnRoute logs from initial version 6.3 - errors were like:


"ORA-00904: invalid column name"
"(dberror2.cpp 1(0) err=3007 sys=0) GEN-03007: SQL error: native=904, state=S0022, message=[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-00904: invalid column name"
"(utlnode.cpp 1(2207) err=3008 sys=0) GEN-03008: Error calling SQLExecute for VIS NODE INFO (1)"


Or in more recent versions - i.e. 8.1.1.14 SIA [23044], log details would look like:


SQLError Statement 0 000000025696085c:0 2016-01-13 05:17:32 SQL Statement:
SELECT -1, TO_CHAR (TSSIEBEL.VIS_DB_MAX_TXN_ID)
FROM TSSIEBEL.S_DUAL
UNION ALL
(...)
DBCLog DBCLogError 1 000000025696085c:0 2016-01-13 05:17:32 [tp][ODBC Oracle driver][Oracle]ORA-00904: : invalid identifier
DBCLog DBCLogError 1 000000025696085c:0 2016-01-13 05:17:32 (dberror2.cpp(0) err=3007 sys=2) SBL-GEN-03007: SQL error: native=904, state=S0022, message=[tp][ODBC Oracle driver][Oracle]ORA-00904: : invalid identifier
GenericLog GenericError 1 000000025696085c:0 2016-01-13 05:17:32 (nodedatamgr.cpp (306) err=3008 sys=0) SBL-GEN-03008: Error calling SQLExecute for VIS NODE INFO (1)
GenericLog GenericError 1 000000025696085c:0 2016-01-13 05:17:32 (nodedatamgr.cpp (517) err=3008 sys=0) SBL-GEN-03008: Error calling SQLExecute for VIS NODE INFO (1)
GenericLog GenericError 1 000000025696085c:0 2016-01-13 05:17:32 (lrtmain.cpp (1097) err=3008 sys=0) SBL-GEN-03008: Error calling SQLExecute for VIS NODE INFO (1)
GenericLog GenericError 1 000000025696085c:0 2016-01-13 05:17:32 (logroute.cpp (1059) err=196634 sys=0) SBL-TXR-00026: Error in the main function.
(...)
Exception 0xc0000005 at 0x6bde4bd9
Thread: 0x000020cc, Process 0x0000085c
- CONTEXT -
EIP: 0x772797c5, EFL: 0x00010202, FS: 0x00000053, GS: 0x0000002b
CS: 0x00000023, DS: 0x0000002b, SS: 0x0000002b, ES: 0x0000002b
EAX: 0x11020d18, EBX: 0x6ec03150, ECX: 0x0031f5d4, EDX: 0x0045051f
ESI: 0x04f668f8, EDI: 0x04f813e8, EBP: 0x0031fa54, ESP: 0x0031fa44

- CALL STACK -
sssrvd +0x4bd9 = UTLVisDataInstRelease() +0x29
sssrvd +0x9ebf = CSSNodeDataMgr::~CSSNodeDataMgr() +0xff
sssatrou +0x1290
sssatrou +0x4f96 = CompCleanup() +0x86
siebprocmw +0x1b56
siebprocmw +0x50ae = SmiBeginTrace() +0x29de
kernel32 +0x1338a = BaseThreadInitThunk() +0x12
ntdll +0x397f2 = RtlInitializeExceptionChain() +0x63
ntdll +0x397c5 = RtlInitializeExceptionChain() +0x36

 

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