Hi,all,
I meet this problem after I have deleted some program successfully, got
error at catalina.out:
* WARN 2018-11-18 20:06:44,416 SQL Error: 0, SQLState: 23503
(SqlExceptionHelper.java [http-nio-8050-exec-15])
* ERROR 2018-11-18 20:06:44,416 错误: 在 "programstage" 上的更新或删除操作违反了在 "mapview"
上的外键约束 "fk_mapview_programstageid"
详细:键值对(programstageid)=(37661)仍然是从表"mapview"引用的. (SqlExceptionHelper.java
[http-nio-8050-exec-15])
javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:164)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1443)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1423)
at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:200)
......
Caused by: org.postgresql.util.PSQLException: 错误(ERROR): 在 "programstage"
上的更新或删除操作违反了在 "mapview" 上的外键约束 "fk_mapview_programstageid" (violate the fk
constraints in update or delete mapview fk in programstage..)
详细:键值对(programstageid)=(37661)仍然是从表"mapview"引用的.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
---
DHIS29, ubuntu,tomcat 8.54,jdk 1.8
--
Thanks.
此致
easy
莫愁前路无知己,天下谁人不识君。
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp