Ok. Thanks a lot.
*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 16:19 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: > Hm ok, seems to be a different error (ProgramIndicator this time), I will > have a look tomorrow and fix it > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Thu, Jul 28, 2016 at 4:07 PM, Sergio Valenzuela < > sergio.valenzu...@ehas.org> wrote: > >> Hello again, >> >> I've testing the fix and I encountered some troubles. The previous error >> appears again. >> When I tried to import 1 event chart the importer seemed to work fine. I >> tried 2 and It worked too. Finally I tried 238, and this is what I got: >> >> { >> "httpStatus": "Internal Server Error", >> "httpStatusCode": 500, >> "status": "ERROR", >> "message": "object references an unsaved transient instance - save the >> transient instance before flushing: org.hisp.dhis.program.ProgramIndicator" >> } >> >> I tried 9 and It worked. >> I tried 20 and It crashed again. After this try I was not able to import >> a single one any more. >> >> I attach the stacktrace of every try I made. The payload I used is the >> same as before but with a list of event charts instead of only one. >> >> 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-28 13:51 GMT+02:00 Sergio Valenzuela <sergio.valenzu...@ehas.org> >> : >> >>> Hi, >>> >>> I have just tested it again with Build revision: 23527 and now it works >>> perfectly. >>> >>> Thanks Morten. >>> >>> 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-28 13:28 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: >>> >>>> Hi Sergio >>>> >>>> Please try again with latest 2.24 >>>> >>>> -- >>>> Morten Olav Hansen >>>> Senior Engineer, DHIS 2 >>>> University of Oslo >>>> http://www.dhis2.org >>>> >>>> On Thu, Jul 28, 2016 at 10:56 AM, Sergio Valenzuela < >>>> sergio.valenzu...@ehas.org> wrote: >>>> >>>>> 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
