Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-182

SQL Error when installing JobScheduler with MS SQL Server

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.12.9, 1.12.10
    • 1.12.11, 1.13
    • 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.

       

      Attachments

        Activity

          People

            sp Santiago Aucejo Petzoldt
            sp Santiago Aucejo Petzoldt
            Oliver Haufe Oliver Haufe
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: