Siebel Remote: Database Extract (DbXtract) Failing with error 'DBXTRACT-ERR-1112: Unable to export sql'

(Doc ID 1909400.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 8.2.2.2 SIA[23016] and later
Information in this document applies to any platform.

Symptoms

Siebel Remote - on version 8.2.2.2 SIA [23016]:

Database Extract (Dbxtract) task is starting but failing at some point in a Test environment - with generic error SBL-SMI-00077 in detailed log.

---------------------------------------------------------------
Trace TracingInfo 3 00000009539f05c4:0 2014-06-17 12:48:24
  Part 3: Start extracting member table rows for client "TOUSER"...
...
Trace TracingInfo 3 00000009539f05c4:0 2014-06-17 12:49:05 DBXTRACT-ERR-1112: Unable to export sql " select primary_table.ACTIVE_INBND_FLG,
[...]
SQLSummary Stmt 4 00000009539f05c4:0 2014-06-17 12:49:05 select primary_table.ACTIVE_INBND_FLG,
primary_table.ACT_APPT_DURTN_MIN,
[...]
primary_table.VERSION_NUM,
primary_table.X_MEMO_TYPE
  from SIEBEL.S_DOCK_INITM_01 di
  ,SIEBEL.S_DMND_CRTN_PRG primary_table
  where di.NODE_ID = '1-17WWVX'
  and di.DOCK_NAME = 'DM1'
  and di.PR_TBL_ROW_ID = primary_table.ROW_ID
  and di.VIS_STRENGTH >= 25
SQLSummary Header 4 00000009539f05c4:0 2014-06-17 12:49:06 Call Count Total Time Avg. Time Rows
SQLSummary Sep 5 00000009539f05c4:0 2014-06-17 12:49:06 -------------------------------------------------------------------------------
SQLSummary ExecDir 5 00000009539f05c4:0 2014-06-17 12:49:06 Exec Direct 1 0.016s 0.016s 0
SQLSummary Bind 5 00000009539f05c4:0 2014-06-17 12:49:06 Bind 104 0s 0s 0
SQLSummary Fetch 5 00000009539f05c4:0 2014-06-17 12:49:06 Fetch 7 0.016s 0.002s 6
SQLSummary Sep 5 00000009539f05c4:0 2014-06-17 12:49:06 -------------------------------------------------------------------------------
SQLSummary Totals 4 00000009539f05c4:0 2014-06-17 12:49:06 Total 112 0.032s 0.286ms 6

GenericLog GenericError 1 00000009539f05c4:0 2014-06-17 12:49:06 Error while writing to file
...

GenericLog GenericError 1 00000009539f05c4:0 2014-06-17 12:49:16 Error while writing to file
Trace TracingInfo 3 00000009539f05c4:0 2014-06-17 12:49:16 Error while processing client "TOUSER". Results may be incomplete.
GenericLog GenericDebug 5 00000009539f05c4:0 2014-06-17 12:49:16 Process Name: Database Extract, Status: Completed with Errors, Message
Trace TracingInfo 3 00000009539f05c4:0 2014-06-17 12:49:16 Error while writing to file
Trace TracingInfo 3 00000009539f05c4:0 2014-06-17 12:49:18 ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog GenericError 1 00000009539f05c4:0 2014-06-17 12:49:18 (smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information
---------------------------------------------------------------


Impact: due to this issue, the database for a Developer/Mobile client cannot be extracted and initialized.

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