Siebel Remote: Database Extract (DbXtract) Failing with errors SBL-SMI-00077 and 'UTLZipFileMultiAdd Failed' (Doc ID 2061847.1)

Last updated on JULY 12, 2017

Applies to:

Siebel CRM - Version 8.1.1.14.7 [IP2014] to 15.18 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.

Symptoms

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

On a Development environment, it was observed that Database Extract (DbXtract) tasks can start fine, but fail after running for some time:

Srvrmgr command run was:
start task for comp DbXtract with Client=[Mobile-User-Name], EncryptLocalDbPwd=FALSE, EncryptLocalDbMethod=NONE, ExtractRepos=TRUE

Relevant error details in task log:

...
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:43 Finished extracting 301 enterprise tables. Extracted 88184756 rows.
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:44 UTLZipFileMultiAdd failed
GenericLog GenericError 1 00008ebb55b00298:0 2015-07-23 08:49:44 pDbxMn->hBcp->Close (TRUE) failed

Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:44 DBXTRACT: Failed to extract enterprise table data.

...
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:44 Error while processing client "[Mobile-User-Name]". Results may be incomplete.
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:44 2015-07-23 08:49:44
GenericLog GenericDebug 5 00008ebb55b00298:0 2015-07-23 08:49:44 Process Name: Database Extract, Status: Completed with Errors, Message  
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:44 Unspecified error
Trace TracingInfo 3 00008ebb55b00298:0 2015-07-23 08:49:46 ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog GenericError 1 00008ebb55b00298:0 2015-07-23 08:49:46 (smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information


It was further observed that total DB extracted size is ~20GB and failed out on a file - S_Vehicle.bcp that has size of 19GB.

ERROR
-----------------------

UTLZipFileMultiAdd failed
pDbxMn->hBcp->Close (TRUE) failed
DBXTRACT: Failed to extract enterprise table data.
...
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, Remote users cannot have their local databases 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