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

Error in processing Oracle database files while updating JobScheduler

    XMLWordPrintable

    Details

    • Type: Fix
    • Status: Released (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.12.8
    • Fix Version/s: 1.12.9
    • Labels:
      None

      Description

      Current Situation

      • When the user updates JobScheduler release 1.12.5 to release 1.12.8 with Oracle database the SQL files db/oracle are not getting processed successfully. It throws the following errors:
        sos.connection.SOSConnectionFileProcessor.process(82): error:
        11:08:12.301    [info]   sos.connection.SOSConnectionFileProcessor.process(82):     1) {scheduler_home}/db/oracle/reporting/documentation_alter.sql: sos.connection.SOSConnection.executeStatements(2381) : error occurred during batching: ORA-01442: column to be modified to NOT NULL is already NOT NULL
        
      • And also the declare statement is incorrect in db/oracle/scheduler_alter.sql
        • The statement DECLARE scheduler_clusters_exist number; should be DECLARE scheduler_history_exist number;.

      Desired Behavior

      • While updating the database the sql files in db/oracle should be processed successfully.
      • The declare statement should be correct in documentation_alter.sql file.

        Attachments

          Activity

            People

            • Assignee:
              sp Santiago Aucejo Petzoldt
              Reporter:
              Kanika-Agrawal Kanika Agrawal
              Approver:
              Kanika Agrawal
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: