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

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!