This should be fixed in latest 225/master (2.24 was not affected) -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org
On Wed, Nov 9, 2016 at 10:14 AM, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi Archana > > I'm looking into this now. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Fri, Nov 4, 2016 at 4:07 PM, Archana Chillala < > archa...@thoughtworks.com> wrote: > >> Hi, >> >> We are using the latest version of DHIS 2.25 (build - 5e16867). We have >> two instances of DHIS and are trying to sync metadata from one instance to >> the other. Sync is failing for the following cases. >> >> >> *Modifying a Tracker program (i.e. program “with registration”) * >> >> * INFO 2016-11-02 16:36:27,877 (admin) Creating 1 object(s) of type >> ProgramTrackedEntityAttribute (DefaultObjectBundleService.java >> [http-bio-8080-exec-7]) >> * *WARN 2016-11-02 16:36:27,902 SQL Error: 0, SQLState: 23505 >> (SqlExceptionHelper.java [http-bio-8080-exec-7])* >> ** ERROR 2016-11-02 16:36:27,903 ERROR: duplicate key value violates >> unique constraint "programtrackedentityattribute_unique_key"* >> * Detail: Key (programid, trackedentityattributeid)=(80, 74) already >> exists. (SqlExceptionHelper.java [http-bio-8080-exec-7])* >> ** ERROR 2016-11-02 16:36:27,916 Exception occurred while trying to >> import the metadata. could not execute statement >> (MetadataSyncImportHandler.java [http-bio-8080-exec-7])* >> *org.hibernate.exception.ConstraintViolationException: could not execute >> statement* >> at org.hibernate.exception.internal.SQLStateConversionDelegate. >> convert(SQLStateConversionDelegate.java:112) >> at org.hibernate.exception.internal.StandardSQLExceptionConvert >> er.convert(StandardSQLExceptionConverter.java:42) >> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql >> ExceptionHelper.java:111) >> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql >> ExceptionHelper.java:97) >> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu >> teUpdate(ResultSetReturnImpl.java:207) >> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch. >> addToBatch(NonBatchingBatch.java:45) >> at org.hibernate.persister.entity.AbstractEntityPersister.inser >> t(AbstractEntityPersister.java:2921) >> at org.hibernate.persister.entity.AbstractEntityPersister.inser >> t(AbstractEntityPersister.java:3421) >> at org.hibernate.action.internal.EntityInsertAction.execute(Ent >> ityInsertAction.java:89) >> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >> eue.java:560) >> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >> eue.java:434) >> at org.hibernate.event.internal.AbstractFlushingEventListener.p >> erformExecutions(AbstractFlushingEventListener.java:337) >> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu >> sh(DefaultFlushEventListener.java:39) >> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) >> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle >> Service.commit(DefaultObjectBundleService.java:160) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value >> violates unique constraint "programtrackedentityattribute_unique_key" >> Detail: Key (programid, trackedentityattributeid)=(80, 74) already >> exists. >> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons >> e(QueryExecutorImpl.java:2284) >> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer >> yExecutorImpl.java:2003) >> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut >> orImpl.java:200) >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424) >> at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgP >> reparedStatement.java:161) >> at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPrep >> aredStatement.java:133) >> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUp >> date(NewProxyPreparedStatement.java:105) >> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu >> teUpdate(ResultSetReturnImpl.java:204) >> >> >> >> >> *Modifying the program stage of a Tracker program (i.e. program “with >> registration”)* >> >> * INFO 2016-11-02 16:55:26,050 (admin) Updating 1 object(s) of type >> ProgramStage (DefaultObjectBundleService.java [http-bio-8080-exec-10]) >> * INFO 2016-11-02 16:55:26,065 (admin) Updating 2 object(s) of type >> ProgramStageDataElement (DefaultObjectBundleService.java >> [http-bio-8080-exec-10]) >> * *ERROR 2016-11-02 16:55:26,073 Exception occurred while trying to >> import the metadata. Batch update returned unexpected row count from update >> [0]; actual row count: 0; expected: 1 (MetadataSyncImportHandler.java >> [http-bio-8080-exec-10])* >> *org.hibernate.StaleStateException: Batch update returned unexpected row >> count from update [0]; actual row count: 0; expected: 1* >> at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatche >> d(Expectations.java:67) >> at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutco >> me(Expectations.java:54) >> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch. >> addToBatch(NonBatchingBatch.java:46) >> at org.hibernate.persister.entity.AbstractEntityPersister.updat >> e(AbstractEntityPersister.java:3106) >> at org.hibernate.persister.entity.AbstractEntityPersister.updat >> eOrInsert(AbstractEntityPersister.java:2985) >> at org.hibernate.persister.entity.AbstractEntityPersister.updat >> e(AbstractEntityPersister.java:3365) >> at org.hibernate.action.internal.EntityUpdateAction.execute(Ent >> ityUpdateAction.java:145) >> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >> eue.java:560) >> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >> eue.java:434) >> at org.hibernate.event.internal.AbstractFlushingEventListener.p >> erformExecutions(AbstractFlushingEventListener.java:337) >> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu >> sh(DefaultFlushEventListener.java:39) >> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) >> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle >> Service.commit(DefaultObjectBundleService.java:160) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >> ssorImpl.java:62) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:498) >> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin >> gReflection(AopUtils.java:302) >> at org.springframework.aop.framework.ReflectiveMethodInvocation >> .invokeJoinpoint(ReflectiveMethodInvocation.java:190) >> at org.springframework.aop.framework.ReflectiveMethodInvocation >> .proceed(ReflectiveMethodInvocation.java:157) >> at org.springframework.transaction.interceptor.TransactionInter >> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) >> at org.springframework.transaction.interceptor.TransactionAspec >> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) >> at org.springframework.transaction.interceptor.TransactionInter >> ceptor.invoke(TransactionInterceptor.java:96) >> at org.springframework.aop.framework.ReflectiveMethodInvocation >> .proceed(ReflectiveMethodInvocation.java:179) >> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke( >> JdkDynamicAopProxy.java:208) >> at com.sun.proxy.$Proxy186.commit(Unknown Source) >> >> >> Could you please help fix the issues. >> >> >> *Cheers,* >> >> Archana Chillala >> Application Developer >> Email archa...@thoughtworks.com >> 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> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp