Siebel Remote: Database Extract (DbXtract) Fails With Errors SBL-SMI-00077 and ORA-29275 (Doc ID 1439032.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Remote - Version 8.0.0.11 SIA[20440] and later
Information in this document applies to any platform.
Product Release: V8
Database: Oracle Server
Application Server OS: All Supported
Database Server OS: All Supported


Symptoms


Siebel Remote: Database Extract (DbXtract) task fails with generic SBL-SMI-00077 error (that indicates relevant error is somewhere else in the log file) and the relevant error being Oracle RDBMS one:

[DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

Detailed logging level DbXtract_*.log files would look like:
(note that base table involved or variables' values may vary - could be other than S_CONTACT or those listed in this example)

SQLError Statement 0 000000074f561360:0 2012-03-07 10:34:15 SQL Statement:
select mtx.*
from SIEBEL.S_DOCK_INITM_01 di
,SIEBEL.S_CONTACT mtx
where di.NODE_ID = '1-7LIVG'
and di.DOCK_NAME = 'PTY-C'
and di.PR_TBL_ROW_ID = mtx.PAR_ROW_ID
and di.VIS_STRENGTH >= 25
DBCLog DBCLogError 1 000000074f561360:0 2012-03-07 10:34:15 [DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

Trace TracingInfo 3 000000074f561360:0 2012-03-07 10:34:15 DBXTRACT: Database returned error.
Trace TracingInfo 3 000000074f561360:0 2012-03-07 10:34:15 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

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