SBL-CDM-00173: Error merging the Siebel Dictionary and the Database Dictionary information.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] Life Sci
Database: Oracle 9.2.0.6
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3067775581.

Symptoms

SBL-CDM-00173, SBL-CDM-00190

Dear Support.

The Upgrade Kit Builder fails when trying to create database schema update. We have got error "Error merging the Siebel Dictionary and the Database Dictionary information.(SBL-CDM-00173)". I've attached full log from build kit process.

Regards,

Solution

Message 1

For the benefit of other users:

The Upgrade Kit Builder was failing when the customer was trying to create a Database Schema Kit. The following error message is displayed in the upgkitbldr.log file:

"drop index SIEBEL.S_ESCL_LOG_F2
[DataDirect][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified"
Error merging the Siebel Dictionary and the Database Dictionary information.(SBL-CDM-00173)"

When the Siebel Database Schema Upgrade kit is being created no user should be connected to the server and no Siebel Server Task should be running.

Documentation Enhancement Request: 12-FWJJKV was logged to have this added to the Siebel Anywhere Bookshelf.

If you are trying to create a Database Schema Kit and are seeing the above error, please try the following:

1. Deactivate and Delete previous Database Schema Kits with an error status
2. Stop of Siebel and Oracle services
3. Start of Oracle and Siebel services
4. Stop all Siebel Server components except:
   - File System Manager
   - Server Manager
   - Server Request Broker
   - Server Request Processor
   - Server Tables Cleanup
   - Siebel Connection Broker
   - Upgrade Kit Builder
5. Attempt to create the Database Schema kit

-Oracle Technical Support