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

C:\Tools\liquibase-1.9.5>

Environment

db2

Activity

Show:

Nathan Voxland September 29, 2010 at 5:52 AM

fixed for db2

Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created September 9, 2010 at 6:13 PM
Updated June 20, 2013 at 3:30 AM
Resolved September 29, 2010 at 5:52 AM