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
