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

Submitted by pedrociarlini on Fri, 02/05/2021 - 21:27

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?

#7.7.5

#bonita7.7

Log in or register to post comments
689 reads

1 answer

Submitted by Pierre-yves Monnet on Thu, 02/18/2021 - 19:25

Hello,

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

Maybe you can try again?

Best,

Log in or register to post comments
93 reads

Comments

Submitted by pedrociarlini on Tue, 02/23/2021 - 16:20

Thanks for the answer.

Yes, I did. Not once, but about 30 times ( ) 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;

Permalink