drop index assumes schema of table but need to override the schema of the index.
Description
I'm attempting to drop an index and it fails. The ddl for the table says the index is in the DB2ADMIN schema but liquibase is setting the schema to VAP which I assume it is using because the table is in the VAP schema
– DDL Statements for indexes on Table "VAP "."EXPENSEITEM"
CREATE INDEX "DB2ADMIN"."IDX508231508130000" ON "VAP "."EXPENSEITEM" ("EXPENSESTATUSVV" ASC, "BILLABLEFLAG" ASC, "EXPENSETIMESTAMP" ASC, "WORKORDER_ID" ASC, "ROLE_ID" ASC) CLUSTER ALLOW REVERSE SCANS;
INFO: Successfully released change log lock Migration Failed: Error executing SQL DROP INDEX vap.IDX508231508130000. For more information, use the --logLevel flag)
Sep 9, 2010 1:00:09 PM liquibase.commandline.Main main SEVERE: Error executing SQL DROP INDEX vap.IDX508231508130000 liquibase.exception.MigrationFailedException: Migration failed for change set changeLogConvertExpenseItemToClobFromLongVarchar.xml::80-dropIndex-IDX508231508130000-expenseItem::msmith (generated): Reason: liquibase.exception.JDBCException: Error executing SQL DROP INDEX vap.IDX508231508130000: Caused By: Error executing SQL DROP INDEX vap.IDX508231508130000: Caused By: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=VAP.IDX508231508130000, DRIVER=3.58.82 at liquibase.ChangeSet.execute(ChangeSet.java:260) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.commandline.Main.doMigration(Main.java:650) at liquibase.commandline.Main.main(Main.java:97) Caused by: liquibase.exception.JDBCException: Error executing SQL DROP INDEX vap.IDX508231508130000 at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at liquibase.ChangeSet.execute(ChangeSet.java:236) ... 5 more Caused by: com.ibm.db2.jcc.am.ro: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=VAP.IDX508231508130000, DRIVER=3 .58.82 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.tm.c(tm.java:2523) at com.ibm.db2.jcc.am.tm.d(tm.java:2511) at com.ibm.db2.jcc.am.tm.b(tm.java:1931) at com.ibm.db2.jcc.t4.fb.h(fb.java:221) at com.ibm.db2.jcc.t4.fb.b(fb.java:47) at com.ibm.db2.jcc.t4.t.b(t.java:38) at com.ibm.db2.jcc.t4.ub.h(ub.java:114) at com.ibm.db2.jcc.am.tm.eb(tm.java:1926) at com.ibm.db2.jcc.am.tm.a(tm.java:3017) at com.ibm.db2.jcc.am.tm.e(tm.java:1009) at com.ibm.db2.jcc.am.tm.execute(tm.java:993) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 9 more
I'm attempting to drop an index and it fails. The ddl for the table says the index is in the DB2ADMIN schema but liquibase is setting the schema to VAP which I assume it is using because the table is in the VAP schema
– DDL Statements for indexes on Table "VAP "."EXPENSEITEM"
CREATE INDEX "DB2ADMIN"."IDX508231508130000" ON "VAP "."EXPENSEITEM"
("EXPENSESTATUSVV" ASC,
"BILLABLEFLAG" ASC,
"EXPENSETIMESTAMP" ASC,
"WORKORDER_ID" ASC,
"ROLE_ID" ASC)
CLUSTER ALLOW REVERSE SCANS;
INFO: Successfully released change log lock
Migration Failed: Error executing SQL DROP INDEX vap.IDX508231508130000. For more information, use the --logLevel flag)
Sep 9, 2010 1:00:09 PM liquibase.commandline.Main main
SEVERE: Error executing SQL DROP INDEX vap.IDX508231508130000
liquibase.exception.MigrationFailedException: Migration failed for change set changeLogConvertExpenseItemToClobFromLongVarchar.xml::80-dropIndex-IDX508231508130000-expenseItem::msmith (generated):
Reason: liquibase.exception.JDBCException: Error executing SQL DROP INDEX vap.IDX508231508130000:
Caused By: Error executing SQL DROP INDEX vap.IDX508231508130000:
Caused By: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=VAP.IDX508231508130000, DRIVER=3.58.82
at liquibase.ChangeSet.execute(ChangeSet.java:260)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
at liquibase.commandline.Main.doMigration(Main.java:650)
at liquibase.commandline.Main.main(Main.java:97)
Caused by: liquibase.exception.JDBCException: Error executing SQL DROP INDEX vap.IDX508231508130000
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
at liquibase.ChangeSet.execute(ChangeSet.java:236)
... 5 more
Caused by: com.ibm.db2.jcc.am.ro: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=VAP.IDX508231508130000, DRIVER=3
.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.tm.b(tm.java:1931)
at com.ibm.db2.jcc.t4.fb.h(fb.java:221)
at com.ibm.db2.jcc.t4.fb.b(fb.java:47)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.ub.h(ub.java:114)
at com.ibm.db2.jcc.am.tm.eb(tm.java:1926)
at com.ibm.db2.jcc.am.tm.a(tm.java:3017)
at com.ibm.db2.jcc.am.tm.e(tm.java:1009)
at com.ibm.db2.jcc.am.tm.execute(tm.java:993)
at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
... 9 more
C:\Tools\liquibase-1.9.5>