Siebel Remote: Database Extract (DbXtract) failing with errors SBL-SMI-00077 and 'Error while writing to file'
Last updated on DECEMBER 15, 2017
Applies to:Siebel CRM - Version 18.104.22.168 [IP2013] and later
Information in this document applies to any platform.
Siebel Remote / Replication / Anywhere - on version: 22.214.171.124 [IP2013]
On a Development environment, after a DB Refresh and after removing the Siebel administrator responsibility, the task was running for certain time and then it errors out.
(from detailed DbXtract_*.log)
SQLParseAndExecute Statement 4 0000407657550036:0 2016-07-05 18:30:20 select c.NAME, c.INACTIVE_FLG, c.COMPUTE_EXPR from SIEBEL.S_COLUMN c, SIEBEL.S_TABLE t, SIEBEL.S_REPOSITORY r where c.TBL_ID=t.ROW_ID and t.NAME = 'S_EVT_MAIL' and t.REPOSITORY_ID = r.ROW_ID and r.NAME = 'Siebel Repository'
SQLParseAndExecute Prepare + Execute 4 0000407657550036:0 2016-07-05 18:30:20 Time: 0.003s, Rows: 0, Avg. Time: 0.003s [Row count does not apply to SELECT statements]
GenericLog GenericError 1 0000407657550036:0 2016-07-05 18:38:44 Error while writing to file
GenericLog GenericError 1 0000407657550036:0 2016-07-05 18:42:36 (smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information
The issue has the following business impact:
Due to this issue, users cannot have their local / developer database extracted.
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