Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.10
-
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