Data import failed for TB Tracker

Hi,
We are currently using DHIS2 v2.35.2, trying to import the metadata to our training instance (vannila) on exact same version. The dry run completes successfully BUT as you import the data, it gives this error at the end:
Process failed: org.hibernate.exception.ConstraintViolationException: could not execute statement|PCS1qPUqIkZ|*

The complete summary is pasted below:

|2021-04-03 07:50:50|Initiated metadataImport|init|
|2021-04-03 07:51:14|(admin) Import:Start|PCS1qPUqIkZ|
|2021-04-03 07:51:14|(admin) Creating 4 object(s) of type Attribute|PCS1qPUqIkZ|
|2021-04-03 07:51:14|(admin) Creating 2 object(s) of type UserAuthorityGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Updating 1 object(s) of type UserAuthorityGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Creating 6 object(s) of type User|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Updating 1 object(s) of type User|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Creating 7 object(s) of type UserGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Creating 141 object(s) of type Option|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Creating 30 object(s) of type OptionSet|PCS1qPUqIkZ|
|2021-04-03 07:51:15|(admin) Creating 1887 object(s) of type OrganisationUnit|PCS1qPUqIkZ|
|2021-04-03 07:51:17|(admin) Creating 5 object(s) of type OrganisationUnitLevel|PCS1qPUqIkZ|
|2021-04-03 07:51:17|(admin) Creating 31 object(s) of type OrganisationUnitGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:19|(admin) Creating 5 object(s) of type OrganisationUnitGroupSet|PCS1qPUqIkZ|
|2021-04-03 07:51:19|(admin) Creating 203 object(s) of type DataElement|PCS1qPUqIkZ|
|2021-04-03 07:51:20|(admin) Creating 1 object(s) of type DataElementGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:20|(admin) Creating 1 object(s) of type IndicatorType|PCS1qPUqIkZ|
|2021-04-03 07:51:20|(admin) Creating 7 object(s) of type Indicator|PCS1qPUqIkZ|
|2021-04-03 07:51:20|(admin) Creating 1 object(s) of type IndicatorGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:21|(admin) Creating 13 object(s) of type TrackedEntityAttribute|PCS1qPUqIkZ|
|2021-04-03 07:51:21|(admin) Creating 1 object(s) of type TrackedEntityType|PCS1qPUqIkZ|
|2021-04-03 07:51:21|(admin) Creating 39 object(s) of type ProgramStageSection|PCS1qPUqIkZ|
|2021-04-03 07:51:21|(admin) Creating 8 object(s) of type ProgramStage|PCS1qPUqIkZ|
|2021-04-03 07:51:22|(admin) Creating 2 object(s) of type Program|PCS1qPUqIkZ|
|2021-04-03 07:51:22|(admin) Creating 340 object(s) of type ProgramIndicator|PCS1qPUqIkZ|
|2021-04-03 07:51:24|(admin) Creating 1 object(s) of type RelationshipType|PCS1qPUqIkZ|
|2021-04-03 07:51:25|(admin) Creating 3 object(s) of type ProgramIndicatorGroup|PCS1qPUqIkZ|
|2021-04-03 07:51:25|(admin) Creating 261 object(s) of type ProgramRuleVariable|PCS1qPUqIkZ|
|2021-04-03 07:51:26|(admin) Creating 465 object(s) of type ProgramRuleAction|PCS1qPUqIkZ|
|2021-04-03 07:51:26|(admin) Creating 288 object(s) of type ProgramRule|PCS1qPUqIkZ|
|2021-04-03 07:51:27|(admin) Creating 4 object(s) of type MapView|PCS1qPUqIkZ|
|2021-04-03 07:51:27|(admin) Creating 6 object(s) of type Visualization|PCS1qPUqIkZ|
|2021-04-03 07:51:28|(admin) Creating 2 object(s) of type Map|PCS1qPUqIkZ|
|2021-04-03 07:51:31|Process failed: org.hibernate.exception.ConstraintViolationException: could not execute statement|PCS1qPUqIkZ|

@Don_Vieira,
Welcome back to the community! I am sorry it took so long to get back to your post, and Iā€™d like to know if you are still facing this issue because a jira issue seems to describe it: [DHIS2-9888] - Jira - For example, soft deleting an event cause this issue but it has been fixed for version 2.36

1 Like