My Oracle Support Banner

Siebel SQL Server Upgrade Process Fails At "Prepare for Seed Import" Step With "There is already an object named 'xxx' in the database" And "Read 0 tables and 0 indexes from existing schema" Error (Doc ID 2690401.1)

Last updated on SEPTEMBER 25, 2020

Applies to:

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

Symptoms

When attempting to upgrade to IP2017 or later from lower version, the upgrade fails and the following error occurs in ddlctl_tab.log

2020-05-06 16:36:10 Reading tables and indexes from DDL file...
2020-05-06 16:36:24 Read 5018 tables and 25801 indexes from DDL file...
2020-05-06 16:36:24 Reading existing schema...
2020-05-06 16:37:39 Read 0 tablespaces, 0 tables and 0 indexes from existing schema...
...
2020-05-06 16:37:39 SQL Statement:create unique nonclustered index xxx on xxx ("ROW_ID") on 'default'
2020-05-06 16:37:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'xxx' in the database.

STEPS
-------
The issue can be reproduced at will with the following steps:

1. Upgrade from lower versions of Siebel to IP2017 or later
2. Make sure all of the required steps for upgrade is being followed
3. Check to see if upgrade is successful

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


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