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

JobSchedulerSubmitEventJob with PostGreSQL misses a sequence

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.12.3
    • PostGres

    Description

      Current Situation

      • The job sos.scheduler.job.JobSchedulerSubmitEventJob raises the error
        could not extract ResultSet: 0 ERROR: relation "reporting_rce_id_seq" does not exist
        Position: 17
        

        for a PostGres database.

      • The table is created with a "SERIAL" as primary key so that the sequence reporting_custom_events_ID_seq is created implicitly but the job expects a sequence reporting_rce_id_seq

      Desired Behavior

      The SQL script ./db/pgsql/reporting/reporting_custom_events.sql should create a sequence reporting_rce_id_seq.

      Workaround

      Copy the attached file to your JobScheduler installation path into the folder ./db/pgsql/reporting.
      Then, depending on the operating system, run the cmd or sh script ./install/scheduler_install_tables.

      Attachments

        1. reporting_custom_events.sql
          3 kB
          Santiago Aucejo Petzoldt

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: