My Oracle Support Banner

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 FEBRUARY 01, 2022

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.

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

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
Goal
 Description
 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.