Hi Archana Ok, looking into it now..
-- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Thu, Nov 10, 2016 at 12:39 PM, Archana Chillala < archa...@thoughtworks.com> wrote: > Hi Morten, > > Thanks for the fix. We're now able to import *Program Stage *of a Tracker > program after modifying it. > > But, the issue still exists while importing a modified *Tracker program.* > > Please find the log trace attached herewith. > > > *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> > > On Wed, Nov 9, 2016 at 10:14 AM, Morten Olav Hansen <mor...@dhis2.org> > wrote: > >> 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.ad >>>> dToBatch(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.ad >>>> dToBatch(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
