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
