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