SET - Setups
  1. SET - Setups
  2. SET-166

Error in processing Oracle database files while updating JobScheduler

    Details

    • Type: Fix Fix
    • Status: Released (View Workflow)
    • Priority: Minor 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.

        Activity

        Hide
        Santiago Aucejo Petzoldt added a comment -

        Hi Kanika Agrawal,

        thanks for the hint. I have missed that one.
        I´ve changed it and commited the change.
        Please test again with the nightly build for tomorrow (3/26/2019).

        Thanks and best regards,
        Santiago

        Show
        Santiago Aucejo Petzoldt added a comment - Hi Kanika Agrawal , thanks for the hint. I have missed that one. I´ve changed it and commited the change. Please test again with the nightly build for tomorrow (3/26/2019). Thanks and best regards, Santiago

          People

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

            Dates

            • Created:
              Updated:
              Resolved: