Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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.