Stream: implementers
Topic: DataIntegrityViolationException exception
NARASIMHA MURTHY (Apr 11 2021 at 03:11):
We are getting the following exception message sometimes , while creating a Patient resource 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.
Lloyd McKenzie (Apr 11 2021 at 14:50):
Suggest raising this on the #hapi stream
NARASIMHA MURTHY (Apr 11 2021 at 14:53):
Sure..will do..thanks.
Last updated: Apr 12 2022 at 19:14 UTC
