DataIntegrityViolationException exception

[pvnmur...@gmail.com]

Hi James,

We are getting the following exception message while creating a Patient resource in Fhir srever.

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 [APP_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.

Thanks in advance for your help.

thanks,

Narasimha