My Oracle Support Banner

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

Last updated on JANUARY 07, 2020

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

DbXtract_*.log files with detailed logging level should look like:
(note that base table involved or variables' values, conditions etc 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

Changes

 

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


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