I am setting up Tracker Capture for case-based surveillance (version 2.30, OpenJDK, Ubuntu 18.04). After initial success I now have an issue where lists of cases do not appear in the Tracker landing page and after registration later stages of the program show only a blank screen.
In the browser JavaScript console I can see 500 errors for the relevant API calls. The error message in the browser is {"httpStatus":"Internal Server Error","httpStatusCode":500,"status":"ERROR","message":"ERROR: cannot execute nextval() in a read-only transaction"}.
A similar “SEVERE” error shows in the logs (attached below as error message is lengthy).
A proposed solution is provided here: PostgreSQl-cannot execute nextval() in a read-only transaction – DHIS2 Web Portal but this does not work for me (I have checked that the value of default_transaction_read_only is “off” in the database).
I have just passed several hours of instructive Googling, albeit without finding anything I can do about this.
Would really appreciate any guidance on this. I thought it might have been started by me creating an ID field using a TextPattern with SEQUENTIAL but the problem persists after expunging this.
Thanks, Paul
2019-catalina-errors.docx (16.6 KB)
