Filr 3.0 upgrade fails with Liquibase Error Executing SQL ALTER TABLE

  • 7018577
  • 02-Feb-2017
  • 02-Feb-2017

Environment

Micro Focus Filr 3.0
Novell Filr 2.0

Situation

When upgrading to Micro Focus Filr 3.0, a liquibase error is thrown during the final step of the upgrade when the Filr database is being updated. The error stack is as follows (/var/opt/novell/va/logs/update.log):

SEVERE 11/30/16 6:04 PM:liquibase: Change Set scripts/changelog/sqlserver-changelog-filrproton.xml::6::dhivya failed.  Error: Error executing SQL ALTER TABLE [dbo].[SS_NetFolderConfig] ALTER COLUMN [name] NVARCHAR(128) NOT NULL: The index 'name_netFolderConfig' is dependent on column 'name'.
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[SS_NetFolderConfig] ALTER COLUMN [name] NVARCHAR(128) NOT NULL: The index 'name_netFolderConfig' is dependent on column 'name'.
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at liquibase.Liquibase.update(Liquibase.java:114)
        at liquibase.integration.commandline.Main.doMigration(Main.java:825)
        at liquibase.integration.commandline.Main.main(Main.java:134)
Caused by: java.sql.SQLException: The index 'name_netFolderConfig' is dependent on column 'name'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2998)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2431)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:646)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:605)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:842)
        at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1315)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        ... 9 more

Resolution

A fix for this issue is available. Please contact Micro Focus Customer Care with reference to this TID for further assistance.