报错信息:
DBCLog DBCLogError 1 0000000261220b30:0 2021-08-23 02:27:29 [tp][ODBC Oracle driver][Oracle]ORA-01408: such column list already indexed
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:27:29 [tp][ODBC Oracle driver][Oracle]ORA-01408: such column list already indexed
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:27:29 Error in function writeExecDDL
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:27:29 Error in function writeExecDDL (pOperCallback UTLDbDdlOperIndCreate)
SQLError Statement 0 0000000261220b30:0 2021-08-23 02:28:12 SQL Statement:
create index XXXXX_U1 on XXXXX
("ROW_ID") parallel nologging
DBCLog DBCLogError 1 0000000261220b30:0 2021-08-23 02:28:12 [tp][ODBC Oracle driver][Oracle]ORA-01408: such column list already indexed
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 [tp][ODBC Oracle driver][Oracle]ORA-01408: such column list already indexed
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 Error in function writeExecDDL
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 Error in function writeExecDDL (pOperCallback UTLDbDdlOperIndCreate)
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 Error in function UTLDbDdlDbProcess
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 Import DDL action failed.
UpgradeLog UpgradeError 1 0000000261220b30:0 2021-08-23 02:28:12 Error executing action (Creating Siebel tables and indexes).
检查Server中数据库和Repository无该索引。
使用LocalDbSetup命令同步的时候没有报错,同步完成之后登录本地Tools,又提示找不到本地库,同步过程中就报以上错误。
检查发现C:\Siebel\16.0.0.0.0\Tools\LOCAL_XE\inbox下有siebel.ddl 文件中有该索引的创建语句,直接在数据库执行报相同错误。尝试删除该索引创建语句,重新打开Tools之后效果一样(siebel.ddl文件重新生成了,断网也不行)
想办法删除表/索引,都无法避免。最后查到C:\Siebel\16.0.0.0.0\Tools\LOCAL_XE\inbox下有一个配置文件可以设置是否创建索引。(同步完成之后文件没了,大概记得是叫Upgrade的,默认值是要创建索引改下重新打开tools就能正常同步完了)