Siebel Remote: What should be done when Database Extract task fails with message 'SBL-DBX-00038: No local database template found'? (Doc ID 476320.1)

Last updated on JULY 12, 2017

Applies to:

Siebel Remote - Version 7.0.4 [14068] and later
Information in this document applies to any platform.
Area(s): Remote/Replication/Anywhere
Release(s): V5 (Siebel 99-Enterprise), V6 (Siebel 2000-Enterprise), V7 (Enterprise), V8 (Enterprise)
Database(s): All Supported Platforms
App Server OS(s): All Supported Platforms
Latest release tested against: V8 (Enterprise)

Keywords:DbXtract, SBL-DBX-00038, DBX-00038, template, DBTEMPL

This document was previously published as Siebel FAQ 1488.


***Checked for relevance on 10-Jul-2014***

Goal

Description

The Database Extract (DbXtract) task looks for a database template corresponding to current Schema Version details in S_APP_VER table.
In case this is not found, it fails with message: "DBX-00038: No DB template found" (Siebel versions 5.x, 6.x) or "SBL-DBX-00038: No local database template found." in more recent versions (7.x, 8.x).

 

Cause

Generate New Database server task has not been executed prior to running a Database Extract server task following one of the actions below:

1. During the initial Siebel Remote setup process
2. Each time the Siebel schema version has been increased by one of the following tasks:

a) A Dev2Prod Repository Migration process has been executed;
b) or a DDLSync process has been executed;
c) Pressing the 'Activate' button in Siebel Tools after making changes to Tables, Indexes etc.
d) A new Database Schema Upgrade Kit has been generated from the Siebel Anywhere screen.
e) in more recent versions, if certain upgrade / IRM process was performed on Siebel database (for instance, upgrading from 8.1.1.10 to 8.1.1.11 version would increase Major Schema version from 45 to 48).
 

Solution

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