Ddlsync Fails On 184.108.40.206 - DESC Index Created as ASC order
Last updated on AUGUST 31, 2017
Applies to:Siebel System Software - Version 220.127.116.11  to 18.104.22.168  [Release V8]
Siebel CRM - Version 22.214.171.124 SIA  to 126.96.36.199 SIA  [Release V8]
Information in this document applies to any platform.
This behavior occurs in 188.8.131.52/184.108.40.206 versions.
The ddlsync is not creating indexes in correct order. All the DESC indexes are getting created with ASC order even after using /9 option.
Steps to Reproduce
The issue can be reproduced as follows:
1. In Siebel Tools 220.127.116.11 create an index. Then add to this index a column and set up sort order as DESC.
2. Go to dbsrvr/oracle and open file driver_ddlsync.ucf. For each ddlimp command, add the option /9 Y at the end of the command; save the file.
3 Then run the DB config wizard > DB utilities > apply schema changes to synchronize logical and physical schemas.
4. Notice that the index created does not contain the column in DESC order, but ASC.
Due to this issue, the logical and physical schemas are out of sync and all the indexes are created in ASC order. In addition, there may be related performance issues in the application.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms