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

Setup should create the sequence "SCHEDULER_MON_CHECKS_ID_SEQ" only if it doesn't exist

    XMLWordPrintable

Details

    • Fix
    • Status: Approved (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.8.3, 1.9.1, 1.10
    • None

    Description

      Current Situation:

      • During the installer a database sequence "SCHEDULER_MON_CHECKS_ID_SEQ" will be created if it doesn't exist.
      • The check wether the sequence already exists or not doesn't work properly and you get the error:
        java.sql.SQLException: sos.connection.SOSConnectionFileProcessor.process(137): an error occurred processing file [C:\Program Files\sos-berlin.com\jobscheduler\scheduler.id\db\pgsql\scheduler_mon_checks.sql]: sos.connection.SOSConnection.executeStatements(3173) : org.postgresql.util.PSQLException: ERROR: relation "scheduler_mon_not_id_seq" already exists
        

      Desired Situation

      • The sequence "SCHEDULER_MON_CHECKS_ID_SEQ" should created only if it doesn't exist.

      Attachments

        Issue Links

          Activity

            People

              oh Oliver Haufe
              oh Oliver Haufe
              Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  1h
                  Logged:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  3h