My Oracle Support Banner

Siebel Remote: Database Extract (DbXtract) task fails with errors - 'Statement not found in common api sql file' and SBL-SMI-00077 (Doc ID 2441495.1)

Last updated on AUGUST 03, 2020

Applies to:

Siebel CRM - Version 16.15 [IP2016] and later
Information in this document applies to any platform.


Siebel Remote / Replication / Anywhere - on version: 16.15 [IP2016]

Database Extract fails with 'Statement not found in common api sql file' error

On a Development environment, while trying to extract a Local Database, the job is finishing with the error "Statement not found in common api sql file" and code error SBL-SMI-00077.

Statement not found in common api sql file
SBL-SMI-00077: Component error, see the trace file for more information

The issue can be reproduced at will in customer's environment with the following steps:
1. Setup Siebel Remote/Mobile environment; define Remote Client node (if needed);
2. Start a DbXtract task for extracting that user's Local Database;
3. See the completion details for that task.

The issue has the following business impact:
Due to this issue, users cannot have their Local databases extracted and initialized.
This could impact their project timelines and other work depending on that step.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.