My Oracle Support Banner

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

Last updated on DECEMBER 01, 2022

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 Local DataBase total extracted size is ~20GB and it 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
-----------------------
Due to this issue, Remote users cannot have their local databases extracted and initialized.

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.