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-0.9.5.5.jar:0.9.5.5]
[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.
Regards
Cynthia.