Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.12.9, 1.12.10
-
None
Description
Current Situation
When installing JobScheduler Master with the reporting database on MS SQL Server an error occurs while executing the sql scripts.
... error occurred while executing install: java.sql.SQLException: /[SCHEDULER_HOME]/db/mssql/reporting/submission.sql: sos.connection.SOSConnection.executeStatements(2381) : Invalid object name 'DOCUMENTATIONS'.
This error occurs only if no tables are present in the database from a previous installation of JobScheduler.
Desired Behaviour
When installing JobScheduler Master where the reporting database uses a MS SQL Server where no tables from a previous JobScheduler installation are present no error should occur.
Workaround
After the failed installation execute the script [SCHEDULER_HOME]/install/scheduler_install_tables.sh|cmd with the parameter "documentation.sql". Then rerun the setup for JobScheduler Master.