FHIR Chat · DataIntegrityViolationException · hapi

Stream: hapi

Topic: DataIntegrityViolationException


view this post on Zulip NARASIMHA MURTHY (Apr 11 2021 at 14:57):

We are getting the following exception message , while creating few Patient resources in HAPI Fhir server 5.3.0.

*Failed to call access method: org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into HFJ_RES_TAG (PARTITION_DATE, PARTITION_ID, TAG_ID, RES_ID, RES_TYPE, PID) values (?, ?, ?, ?, ?, ?)]; constraint [FHIR.IDX_RESTAG_TAGID]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch *

we are using the following Id strategies for client and server.

retVal.setResourceClientIdStrategy(DaoConfig.ClientIdStrategyEnum.ANY);

retVal.setResourceServerIdStrategy(DaoConfig.IdStrategyEnum.UUID);
We have recently upgraded from Hapi fhir 5.1.0 to 5.3.0 version.

Please help us with any solution to resolve this issue.


Last updated: Apr 12 2022 at 19:14 UTC