Data Visualizer - SQLState: 25006 Error: cannot execute nextval() in a read-only transaction

[Gassim (AL-Gassim Sharaf Addin)]

@Ulanbek

default_transaction_read_only = false.

Could you try to change the value ‘false’ to ‘off’ instead?

Also, the issue might be similar to this topic:

ERROR/ cannot execute nextval() in a read-only transaction

Hello, When trying to enter data in some of our datasets we’re having errors to save the data and the box turn to red. In the logs we are having errors related to the query in to the database. See logs : We’re on DHIS2 Version 2.35.6 * INFO 2021-11-08T08:09:36,657 'admin' create org.hisp.dhis.period.Period, name: 2021Q4, uid: 2021Q4 (AuditLogUtil.java [http-nio-8080-exec-4]) dhis2-web_1 | * WARN 2021-11-08T08:09:36,663 SQL Error: 0, SQLState: 25006 (SqlExceptionHelper.java [http-ni…

Thanks!