Siebel Remote: Database Extract (DbXtract) Failing with errors SBL-SMI-00077, SBL-DCK-52067 and SBL-SVC-00163 for encrypted data (Doc ID 2068935.1)

Last updated on JULY 11, 2017

Applies to:

Siebel Financial Services CRM - Version 8.2.2.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

Siebel Remote / Replication / Anywhere - on version : 8.2.2.14 [IP2014]

On a Development environment, when trying to extract a new database, the Database Extract (DbXtract) component exits with errors.
The Job was submitted from UI with parameter - Client Database encryption method=None as the local DBF encryption or password encryption are not needed in this environment.

ERROR
-----------------------
SBL-SVC-00163:
Error :The key database can not be accessed.
Please make sure that the key database file exists.

 

Relevant extracts from detailed DbXtract log file:

...
SQLParseAndExecute;Statement;4;000092bc560213d3:0;2015-10-16 09:20:52;   select mtx.*
   from SIEBEL.S_DOCK_INITM_01 di
        ,SIEBEL.S_USER mtx
  where di.NODE_ID      = '1-7FAK'
    and di.DOCK_NAME    = 'PTY-C'
    and di.PR_TBL_ROW_ID = mtx.PAR_ROW_ID
    and di.VIS_STRENGTH >= 25
...
Trace;TracingInfo;3;000092bc560213d3:0;2015-10-16 09:20:52;CSSKeyStore::init - cache version(0)
ObjMgrLog;Error;1;000092bc560213d3:0;2015-10-16 09:20:52;(keymanager.cpp (359)) SBL-SVC-00163:
Error :The key database can not be accessed.
Please make sure that the key database file exists.
...
GenericLog;GenericError;1;000092bc560213d3:0;2015-10-16 09:20:52;An error occurred loading encryption subsystem. Please check for more detailed errors from encryption subsystem in this log file
GenericLog;GenericError;1;000092bc560213d3:0;2015-10-16 09:20:52;(utlmisc.cpp (2180) err=1166179 sys=0) SBL-DCK-52067: An error occurred loading encryption subsystem. Please check for more detailed errors from encryption subsystem in this log file
GenericLog;GenericError;1;000092bc560213d3:0;2015-10-16 09:20:52;ProcessRow - failed
...
Trace;TracingInfo;3;000092bc560213d3:0;2015-10-16 09:20:57;Error while processing client "DEVUSER". Results may be incomplete.
Trace;TracingInfo;3;000092bc560213d3:0;2015-10-16 09:20:57;2015-10-16 09:20:57
GenericLog;GenericDebug;5;000092bc560213d3:0;2015-10-16 09:20:57;Process Name: Database Extract, Status: Completed with Errors, Message  
Trace;TracingInfo;3;000092bc560213d3:0;2015-10-16 09:20:57;
Trace;TracingInfo;3;000092bc560213d3:0;2015-10-16 09:20:59;ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog;GenericError;1;000092bc560213d3:0;2015-10-16 09:20:59;(smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, developer users cannot have their local database extracted.

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