Hi Morten, I've just tried with eventCharts and eventReports (25x and 23x of each type at once) and it works fine. Thanks for your support.
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-29 11:06 GMT+02:00 Morten Olav Hansen <mor...@dhis2.org>: > Hi Sergio > > Can you again try with latest 2.24? > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Thu, Jul 28, 2016 at 4:20 PM, Sergio Valenzuela < > sergio.valenzu...@ehas.org> wrote: > >> 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
