when do analytics table task, failed,and report error: (in dhis2 version: 2.36,2.37)
Caused by: org.postgresql.util.PSQLException: error: in field “psi” 中空值违反了非空约束(non null value violate)
详细:失败, 行包含(pJ0C3w6gmrK, b7O1iGTbcGI, YnoHWS6mQ8x, io5MEfzwxbC, null, null, null, null, 202ThuW18, 021W18, 2021WedW19, 2021
2021SatW18, 2021SunW18, 2021BiW9, 202105, 202103B, 2021Q2, 2021S1, 2021AprilS1, 2021NovS2, 2021, 2021April, 2020July, 2020Oct, 2021Nov, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, fv7BKJU3j73, u57hlorX4HA, HllvX50cXC0, 2020-08-06 18:05:17.838, 2020-08-06 18:05:17.838, 2021-05-05 00:00:00, 2021-05-06 23:50:21.37, 2021-05-05 00:00:00, 2021-05-06 23:50:21.371, 2021-05-06 23:50:21.371, ACTIVE , COMPLETED , null, null, null, io5MEfzwxbC, xxxxx, yongquan).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:422)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)