DHIS2 40.0.0 - Error visualizing program indicators (ERROR: column "psistatus" does not exist)

Dear CoP,

Seeking assistance on how to resolve this error I am getting when visualizing the program indicators. The catalina.out shows a certain column does not exist, see output below. Note that i was able to visualize the program indicators just fine two hours ago.

[2023-06-01 12:41:57] [info] Caused by: org.postgresql.util.PSQLException: ERROR: column “psistatus” does not exist

[2023-06-01 12:41:57] [info] Position: 24
[2023-06-01 12:41:57] [info] #011at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:244) ~[postgresql-42.5.4.jar:42.5.4]
[2023-06-01 12:41:57] [info] #011at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327) ~[c3p0-]
[2023-06-01 12:41:57] [info] #011at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452) ~[spring-jdbc-5.3.25.jar:5.3.25]
[2023-06-01 12:41:57] [info] #011at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[spring-jdbc-5.3.25.jar:5.3.25]
[2023-06-01 12:41:57] [info] #011… 186 more

Your assistance will be highly appreciated.


1 Like

Hi @ckambobe

Thank you for your post! Could you click on the Network tab to show more details about the request that shows an error? Additionally, would you share the complete Catalina.out log (without authentication/sensitive info) to check for which table this column is in? It might fix the problem by adding the column back to the database, but I’m not sure how it’d get deleted in the first place.

You might be facing an issue similar to the ones described in the topic post below, and the workaround mentioned by @dusan was:

The issue does require a bit more investigating to understand why there’s an issue with querying for the psistatus column. It could be a bug if there was a modification in the schema but I’m not sure.

Another helpful tip that might help is restarting the server and clearing the server cache too.

Thank you!

Hi @ckambobe

Are you still facing this issue? Would you please like to create a bug issue here Projects - Jira?

I received this issue from @Stian:

There should be no column named “psistatus”. psistatus is rather a reference to programstageinstance.status (table.column).
In the case of columns not being found, I would say in most cases, it’s a bug some place :slightly_smiling_face: So feel free to ask the user to write a bug issue, and send me, or another product manager a link to the issue, as these bugs are usually not easily to work around for users

Thank you and very sorry for the delayed response @ckambobe :pray: