My Oracle Support Banner

PostInstallDBSetup May Fail With ORA-01408 When Siebel Update 21.2 Or Later Is Applied. (Doc ID 2778353.1)

Last updated on MARCH 21, 2024

Applies to:

Siebel Financial Services CRM - Version 21.2 and later
Information in this document applies to any platform.

Symptoms

Siebel Update 21.4 is applied on top of 19.8. As part of the installation, PostInstallDBSetup started then it failed as below.

PostInstallDBSetup utility execution started. Please Wait...

Executing Command: D:\Siebel\SIA17\siebsrvr\bin\PostInstallDBSetup -i D:\Siebel\SIA17\siebsrvr\bin\Setup.ini -p ***** -z ***** -t 2021-04-27_13-53-32
WSRanking Utility Execution is Not Applicable.
SeedSchemaSetup Utility Execution failed.
Post Installation Database Setup execution failed.
Please refer the log file for more details:D:\Siebel\SIA17\siebsrvr\log


- PostInstallDBSetup_2021-04-27_13-53-32\console_SeedSchemaManifestUpgrade.txt

ERROR: Command Execution failed. Please check D:\Siebel\SIA17\siebsrvr/log/PostInstallDBSetup_2021-04-27_13-53-32/RepositoryUpgrade_2021-04-27_13-53-32/Common/import_cus_schema.log for details


- PostInstallDBSetup_2021-04-27_13-53-32\RepositoryUpgrade_2021-04-27_13-53-32\Common\import_cus_schema.log

ORA-01408: such column list already indexed

As a result, PostInstallDBSetup did not finish successfully.


The issue can be reproduced at will with the following steps at the customer site:
1. Siebel update 21.2 (or later) for SES is applied on top of 19.8 (or any version prior to 21.2).
2. PostInstallDBSetup utility starts then fail.

**It is not reproducible using out of box Siebel environment.

Changes

Custom index has been created.

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.