Siebel Installations >  DDL Sync deletes indices not in Siebel Repository

DDL Sync deleting indices not in Siebel Repository

When we create Database indices directly in the Database and not through Siebel Tools,
they get deleted during DDL-Sync.

This can be avoided by changing the default Parameters.

We were calling DDL-Sync using this command.

C:\siebsrvr\BIN\siebupg.exe /m C:\Siebel\siebsrvr\BIN\master_ddlsync.ucf /autogo /q

master_ddlsync.ucf can be create using DB Tools Wizard.

master_ddlsync.ucf calls another file called driver_ddlsync.ucf. We were using Oracle so this file was in

C:\siebsrvr\dbsrvr\ORACLE\driver_ddlsync.ucf

By default there are these lines

Command Line = /u $TableOwner /p $TablePassword /c "$ODBCDataSource" /g $Grantee /f $DbsrvrRoot/$DatabasePlatform/schema.ddl /e n /B $TableSpace /X $IndexSpace /R Y /s $OracleParallelIndex /l $SiebelLogDir/ddlsync1.log /I Y

The last part "/I Y" should be changed to "/I N"

Here is the whole section in driver_ddlsync.ucf file

[File Execute Entry 1]
Type = FileExecute
File Name = $SiebelRoot\bin\ddlimp
Check Return Code = 1
Return Code Compliance = 0
16 Bit App = 0
Command Line = /u $TableOwner /p $TablePassword /c "$ODBCDataSource" /g $Grantee /f $DbsrvrRoot/$DatabasePlatform/schema.ddl /e n /B $TableSpace /X $IndexSpace /R Y /s $OracleParallelIndex /l $SiebelLogDir/ddlsync1.log /I N
Number of 10 Second Wait Loops = 2000
Return Code = 0
Title = Upgrade schema to latest version.
Title Message Num = 0
Estimated Disk Space = 0
Backup Db = 0
Parallelizable Item = 0
Prompt User For Status = 0
Execute Item Condition = $UnicodeFlag,N