PostInstallDBUpdate Drops Custom Indexes On S_ASSET When Choosing Defer – Generate DDL Files Only (Doc ID 2931599.1)

Last updated on OCTOBER 12, 2023

Applies to:

Symptoms

When upgrading from 20. to 23.1 and choosing the "Defer – Generate DDL files only" option while running the installer, generate_schema.ddl drops custom indexes on S_ASSET table

Custom indexes should be kept

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

1.In 20.4 Siebel Tools, create a couple indexes under S_ASSET
e.g:
S_ASSET_TEST001_X -- associate any column with it
S_ASSET_TEST002_X -- associate any column with it

2. apply the table

3. run the installer with the defer option: "Defer – Generate DDL files only

4. Run :
C:\Users\Administrator>C:\apps\siebel\ses\siebsrvr\bin\PostInstallDBSetup -i
C:\apps\siebel\ses\siebsrvr\bin\Setup.ini -p l -z -t 2023-02-17_15-30-34

result:PostInstallDBSetup_2023-02-17_15-30-34\generate_schema.ddl

Changes

Cause

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