dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #46163
Re: Bugs in DHIS new importer.
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.valenzuela@xxxxxxxx> 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 <morten@xxxxxxxxx>:
>
>> 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.valenzuela@xxxxxxxx> 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.valenzuela@xxxxxxxx
>>> >:
>>>
>>>> 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 <morten@xxxxxxxxx>:
>>>>
>>>>> 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.valenzuela@xxxxxxxx> 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 <morten@xxxxxxxxx>:
>>>>>>
>>>>>>> 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.valenzuela@xxxxxxxx> 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 <morten@xxxxxxxxx>:
>>>>>>>>
>>>>>>>>> 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.valenzuela@xxxxxxxx> 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 <morten@xxxxxxxxx>:
>>>>>>>>>>
>>>>>>>>>>> @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 nalinim@xxxxxxxxxxxxxxxx
>>>>>>>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Follow ups
References
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-06-28
-
Re: Bugs in DHIS new importer.
From: Vanya Seth, 2016-06-28
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-06-29
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-27
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-07-27
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-27
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Morten Olav Hansen, 2016-07-28
-
Re: Bugs in DHIS new importer.
From: Sergio Valenzuela, 2016-07-28