Error in processing Oracle database files while updating JobScheduler

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.