Installing a BAR into bonita: "Invalid column name 'migrationDate'"

Q&A
1

Installing a BAR file into a 7.7.5 bonita tomcat bundle and a SQL Server database migrated from bonita 6.5.4, this exception occurs:

org.bonitasoft.engine.dependency.SDependencyException: Can't get dependencies
    at org.bonitasoft.engine.dependency.impl.AbstractDependencyService.getDependencyIds(AbstractDependencyService.java:121)
    at org.bonitasoft.engine.dependency.impl.AbstractDependencyService.getDependenciesResources(AbstractDependencyService.java:89)
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'migrationDate'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
...

Any thouhgts?

2

Hello,

Hum, did you upgrade correctly your database via the MigrationTool ?

Maybe you can try again?

Best,

3

Thanks for the answer.

Yes, I did. Not once, but about 30 times ( laugh )  to fix config errors and simulate all the necessary steps.

I fix this problem running this DML:

alter table process_definition add migrationDate numeric (19,0) null;