dhis2-devs team mailing list archive

[Archana Chillala <archanac@xxxxxxxxxxxxxxxx>]

Hi Morten,

We have two instances of DHIS. On one instance, we have some sample
metadata which is exported and imported into the other instance. On the
first instance, we tried to update the program description of a program and
import into the other instance. This is throwing an exception during
import. Also, the program description at the first instance is cleared
after export. Is this a known issue?

Following are the logs generated for the issue:

WARN  2016-03-10 12:02:02,283 SQL Error: 0, SQLState: 23505
(SqlExceptionHelper.java [taskScheduler-6])

* ERROR 2016-03-10 12:02:02,283 *ERROR: duplicate key value violates unique
constraint "programtrackedentityattribute_unique_key"*

  Detail: Key (programid, trackedentityattributeid)=(801, 708) already
exists. (SqlExceptionHelper.java [taskScheduler-6])

org.*hibernate.exception.ConstraintViolationException: could not execute
statement*

    at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)

    at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

    at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)

    at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

    at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)

    at
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59)

    at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)

    at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)

    at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)

    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)

    at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)

    at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)


Could you please look into the issue and help fix this?




*Thanks*

Archana Chillala
Application Developer
Email archanac@xxxxxxxxxxxxxxxx
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]
<http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>