Rundeck and MS SQL

[Evan Gibbons]

We have installed Rundeck 4.5 on a Red Hat 8 EL server.

We are able to access Rundeck UI with a H2 database.  However, after creating a new database on MS SQL server, the RD startup reports errors when creating objects in the database.

[2022-08-19T16:12:49,764] ERROR boot.SpringApplication [main] - Application run failed
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set core/ExecReportJcExecIdToExecutionId.groovy::1653344096108-52::gschueler (generated):
     Reason: liquibase.exception.DatabaseException: Invalid column name 'JC_EXEC_ID'. [Failed SQL: (207) update base_report set execution_id = cast(JC_EXEC_ID as bigint)]

Is this possibly a SQL collation or compatibility issue?

[rac...@rundeck.com]

Hi Evan,

Could you share your rundeck-config.properties to take a look? Did you follow this?

Regards.

​

[Evan Gibbons]

I followed the Rundeck documentation.  What I found is the column does not exist in the table.

Since the installation and configuration created the database objects in SQL Server, I can not understand how a column could be missing.

liquibase.exception.DatabaseException: Invalid column name 'JC_EXEC_ID'. [Failed SQL: (207) update base_report set execution_id = cast(JC_EXEC_ID as bigint)]

[rac...@rundeck.com]

Hi Evan,

Try omitting this line: dataSource.dbCreate = update on the rundeck-confog.properties file and launch the Rundeck service again. Could you share your rundeck-config.properties to take a look? (edit any sensitive data).

Greetings.

​