Great! Thanks Morten.
*Sergio Valenzuela* Fundación EHAS Telemedicina para países en desarrollo -* www.ehas.org <http://www.ehas.org/>* E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040 Madrid - España Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62 2016-07-28 10:44 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: > Hi Sergio > > I could reproduce your error, will try and have a fix ready today and > backport to 2.24. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Wed, Jul 27, 2016 at 4:30 PM, Sergio Valenzuela < > sergio.valenzu...@ehas.org> wrote: > >> Thanks Morten. Keep me up please. >> >> Best regards! >> >> >> *Sergio Valenzuela* >> Fundación EHAS >> Telemedicina para países en desarrollo -* www.ehas.org >> <http://www.ehas.org/>* >> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040 >> Madrid - España >> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62 >> >> >> >> 2016-07-27 16:28 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: >> >>> Hi Sergio >>> >>> Not sure exactly what is wrong there, but will try and reproduce and fix >>> tomorrow. >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Wed, Jul 27, 2016 at 4:11 PM, Sergio Valenzuela < >>> sergio.valenzu...@ehas.org> wrote: >>> >>>> Hello devs, >>>> >>>> I'm getting the "Exception occurred while trying to import the >>>> metadata. object references an unsaved transient instance - save the >>>> transient instance before flushing: org.hisp.dhis.dataelement.DataElement >>>> (MetadataSyncTask.java [taskScheduler-9])" error when using the new >>>> exporter/importer (/api/24/metadata). I'm exporting event charts and event >>>> reports from one DHIS2 instance to another (same version same build: 2.24 >>>> and 23522). Metadata is the same in both instances. >>>> >>>> Full stack trace attached. >>>> URL: http://localhost:8080/api/24/metadata >>>> Example eventCharts Payload: >>>> { >>>> "date": "2016-07-27T12:54:31.851+0000", >>>> "eventCharts": [ >>>> { >>>> "lastUpdated": "2016-07-26T15:57:08.779+0000", >>>> "id": "uM4KpocRONz", >>>> "created": "2016-07-26T15:57:08.779+0000", >>>> "name": "Acurenam: Mortalidad total: Nº de muertes", >>>> "showData": true, >>>> "publicAccess": "rw------", >>>> "userOrganisationUnitChildren": false, >>>> "type": "LINE", >>>> "hideEmptyRows": false, >>>> "userOrganisationUnit": false, >>>> "hideNaData": false, >>>> "completedOnly": false, >>>> "sortOrder": 0, >>>> "collapseDataDimensions": false, >>>> "userOrganisationUnitGrandChildren": false, >>>> "hideSubtitle": false, >>>> "outputType": "EVENT", >>>> "title": "Número de muertes", >>>> "hideLegend": false, >>>> "externalAccess": false, >>>> "hideTitle": false, >>>> "regression": false, >>>> "program": { >>>> "id": "yBICFtJAYFR" >>>> }, >>>> "relativePeriods": { >>>> "thisYear": false, >>>> "quartersLastYear": false, >>>> "last52Weeks": false, >>>> "thisWeek": false, >>>> "lastMonth": false, >>>> "monthsThisYear": false, >>>> "last2SixMonths": false, >>>> "thisQuarter": false, >>>> "last12Months": false, >>>> "last5FinancialYears": false, >>>> "thisSixMonth": false, >>>> "lastQuarter": false, >>>> "thisFinancialYear": false, >>>> "last4Weeks": false, >>>> "last3Months": false, >>>> "thisMonth": false, >>>> "last5Years": false, >>>> "last6BiMonths": false, >>>> "lastFinancialYear": false, >>>> "last6Months": false, >>>> "quartersThisYear": false, >>>> "monthsLastYear": false, >>>> "lastWeek": false, >>>> "thisBimonth": false, >>>> "lastBimonth": false, >>>> "lastSixMonth": false, >>>> "lastYear": false, >>>> "last12Weeks": true, >>>> "last4Quarters": false >>>> }, >>>> "programStage": { >>>> "id": "PgGkk7ELhw7" >>>> }, >>>> "user": { >>>> "id": "mGMEUNgjTYA" >>>> }, >>>> "attributeDimensions": [], >>>> "translations": [], >>>> "filterDimensions": [ >>>> "ou" >>>> ], >>>> "organisationUnitGroups": [], >>>> "itemOrganisationUnitGroups": [], >>>> "userGroupAccesses": [], >>>> "programIndicatorDimensions": [], >>>> "columnDimensions": [ >>>> "RFGJRT5bFaC" >>>> ], >>>> "organisationUnitLevels": [], >>>> "dataElementDimensions": [ >>>> { >>>> "filter": "IN:O28", >>>> "dataElement": { >>>> "id": "RFGJRT5bFaC" >>>> } >>>> } >>>> ], >>>> "periods": [], >>>> "organisationUnits": [ >>>> { >>>> "id": "JnEJ2mR2WlB" >>>> } >>>> ], >>>> "rowDimensions": [ >>>> "pe" >>>> ] >>>> } >>>> ] >>>> } >>>> >>>> Hope you can help me out with this. >>>> >>>> Best regards! >>>> >>>> >>>> >>>> *Sergio Valenzuela* >>>> Fundación EHAS >>>> Telemedicina para países en desarrollo -* www.ehas.org >>>> <http://www.ehas.org/>* >>>> E.T.S.I. de Telecomunicación A.101-9L. Ciudad Universitaria 30, 28040 >>>> Madrid - España >>>> Tlfno. (+34) 91 488 87 41: (+34) 687 67 17 62 >>>> >>>> >>>> >>>> 2016-06-29 5:18 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: >>>> >>>>> @vanyas: Yes this was caught during the validation phase itself. The >>>>>> point here would be to catch such issues during configuring metadata >>>>>> itself. The use case was: We created some data set at HQ, synced to >>>>>> local. >>>>>> Then we created a custom attribute for data set and made it mandatory. >>>>>> Then >>>>>> when this version (with custom attribute info) syncs to local, we get >>>>>> this >>>>>> validation issues with the importer. Any general guideline for such >>>>>> cases. >>>>>> >>>>> >>>>> I don't disagree on that, but it's not really related to the importer. >>>>> Not sure we have any guidelines for that, in general you would never >>>>> actually change an attribute like that I think (I wouldn't mind it being >>>>> blocked), of course.. people make mistakes.. and we don't really want to >>>>> block edits either.. >>>>> >>>>> >>>>>> We do not support any data approval types at this point (at least >>>>>>> nothing has been done to try and support them, it's untested) >>>>>>> >>>>>> @vanyas: Whats the plan for this in that case? If its part of >>>>>> metadata this association should get synced. >>>>>> >>>>> >>>>> We have a blueprint for adding support for this: >>>>> https://blueprints.launchpad.net/dhis2/+spec/exchange-data-approval >>>>> >>>>> It's currently set to 2.25, but nobody is assigned.. >>>>> >>>>> -- >>>>> Morten >>>>> >>>>> - when we updated the existing program with adding combination of >>>>>>>> categories and synched. >>>>>>>> >>>>>>> >>>>>>> This should be fixed now >>>>>>> >>>>>>> - while updating attributes in the program with registration. >>>>>>>> * ERROR 2016-06-21 21:23:24,325 ERROR: duplicate key value violates >>>>>>>> unique constraint ""programtrackedentityattribute_unique_key"" >>>>>>>> Detail: Key (programid, trackedentityattributeid)=(255, 240) >>>>>>>> already exists. (SqlExceptionHelper.java [taskScheduler-6]) >>>>>>>> * ERROR 2016-06-21 21:23:24,385 Exception occurred while trying to >>>>>>>> import the metadata. could not execute statement >>>>>>>> (MetadataImportHandler.java [taskScheduler-6]) >>>>>>>> org.hibernate.exception.ConstraintViolationException: could not >>>>>>>> execute statement at >>>>>>>> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)"Error >>>>>>>> on Edit Program Stage page. Press cancel and exception is thrown. >>>>>>>> Analytics >>>>>>>> Export Error. Process failed. null. >>>>>>>> >>>>>>> >>>>>>> Please try again, I have done several fixes related to issues like >>>>>>> this (at least similar issues) >>>>>>> >>>>>> @vanyas : Thanks. Sure will check. >>>>>> >>>>>>> >>>>>>> - Charts, pivot tables, Report Table/ Pivot Table, Event Report, >>>>>>>> Event Chart, Validation Rule >>>>>>>> Metadata Sync failed for the above metadata With the below runtime >>>>>>>> exception. >>>>>>>> --- Exception occurred while trying to import the metadata. object >>>>>>>> references an unsaved transient instance - save the transient instance >>>>>>>> before flushing: org.hisp.dhis.dataelement.DataElement >>>>>>>> (MetadataSyncTask.java [taskScheduler-9]) >>>>>>>> >>>>>>> >>>>>>> This should be fixed >>>>>>> >>>>>>> - Admin user when added to dashboard item is not syncing with >>>>>>>> metadat sync. >>>>>>>> >>>>>>> >>>>>>> Will look into it >>>>>>> >>>>>>> - When deleted a legend at HQ and synced to local. The legend at >>>>>>>> Local also is deleted on UI (exists in DB). Also, legend is getting >>>>>>>> duplicated with a different UID in DB. >>>>>>>> >>>>>>> >>>>>>> Will look into it >>>>>>> >>>>>>> >>>>>>>> - Metadata Filter (Import-Export --> Metadata Detailed Export) >>>>>>>> modification to properties like name, description is successfully >>>>>>>> synced but the selection is not synced, the payload also have the >>>>>>>> details >>>>>>>> of the updated data when synced. >>>>>>>> >>>>>>> >>>>>>> Not sure how much time we should spend on this, the metadata filter >>>>>>> functionality should be replaced in future releases (it's not very >>>>>>> stable, >>>>>>> and has not been updated to support new types etc) >>>>>>> >>>>>>> - custom forms are synced properly when created, but while Updation >>>>>>>> of custom form not reflecting on UI. However, payload has the full >>>>>>>> information of updates. >>>>>>>> >>>>>>> >>>>>>> Will look into it, is the issue present for both data set and >>>>>>> program stages? >>>>>>> >>>>>> @vanya: This was tested with data sets only. >>>>>> >>>>>>> >>>>>>> -- >>>>>>> Morten >>>>>>> >>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Thanks & Regards, >>>>>>>> Nalinikanth M >>>>>>>> Quality Analyst >>>>>>>> Email nali...@thoughtworks.com >>>>>>>> Telephone +91 9052234588 <+91+9052234588> >>>>>>>> [image: ThoughtWorks] >>>>>>>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> With Regards >>>>>> ThoughtWorks Technologies >>>>>> Hyderabad >>>>>> >>>>>> --Stay Hungry Stay Foolish!! >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> 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
