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

When updating to 1.10 the setup throws an error when using Oracle

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.10
    • 1.10.1, 1.11
    • None

    Description

      Current situation
      When a JobScheduler instance is connected to an oracle database and the release 1.10 will be installed or updated from a previous release, an error message is shown

      sos.connection.SOSConnectionFileProcessor.process(137): an error occurred processing file [/opt/sos-berlin.com    /jobscheduler/alsos_cluster_4444/db/oracle/inventory.sql]: sos.connection.SOSConnection.executeStatements(3173    ) : java.sql.BatchUpdateException: error occurred during batching: ORA-06550: line 1, column 141:
      

      JobScheduler will not be startet automatically after the update due to the error message.

      ... the JobScheduler won't be (re)started due to a previous installation error:

      JobScheduler has been updated but the inventory table have not been installed.

      Desired behaviour
      The setup should also work with Oracle.

      Workaround

      • Finish the setup.
      • Then open the file %SCHEDULER_HOME%\db\oracle\inventory.sql
      • Search for {{DECLARE c number; BEGIN SELECT COUNT(*) INTO c FROM USER_INDEXES WHERE "INDEX_NAME"='REPORTING_IJC_NAME''; IF c = 0 THEN EXECUTE IMMEDIATE '
        }}
      • remove the '' after REPORTING_IJC_NAME
      • save the file
        • Note: When running with Windows, save the file in a temp folder and copy it back to %SCHEDULER_HOME%\db\oracle\inventory.sql
      • run %SCHEDULER_HOME%\install\scheduler_install_tables.cmd

      Attachments

        Activity

          People

            oh Oliver Haufe
            ur Uwe Risse
            Oliver Haufe Oliver Haufe
            Uwe Risse Uwe Risse
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: