dhis2-users team mailing list archive

[Marc Garnica <marcgarnica13@xxxxxxxxx>]

I think we are still missing something, the data values added throught the
import app from the source instance are linked to the 'Xr12mI7VPn3'
category option combo which now is the default in the database. But
somehow, the datavalues created mannually are still pointing to a 'HoDiXsWulNy'
attributeOptionCombo.

What's more, the system already has a 'HoDiXsWulNy' categoryOptionCombo
which is not the default.

This attributeOptionCombo seems to be computed inside the query (what I can
see from the console is that the getDataValues.action does not have any
parameter called attributeOptionCombo).

Weird.. thanks.

Marc

2017-01-16 13:58 GMT+01:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:

> You can try and reset the UID on the source system to the destination
> system, and see if that works.
>
> I would only try this on a development server, and test everything very
> carefully.
>
> UPDATE categoryoptioncombo set uid = 'Xr12mI7VPn3' where uid =
> 'HoDiXsWulNy';
>
> After that, restart Tomcat.
>
> Messing with the categorycombos is a really go way to mess up the system,
> so proceed carefully.
>
> Regards,
> Jason
>
>
> On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica <marcgarnica13@xxxxxxxxx>
> wrote:
>
>> Close, but we cannot find the solution yet,
>>
>> This is how it looks like a data value in the source instance:
>>
>> *"dataElement":"IxbBQzytPgv","period":"2014","orgUnit":"oWNF4d3PK8C","categoryOptionCombo":"psVSPLclyFj","attributeOptionCombo":"Xr12mI7VPn3","value":"1031*
>>
>> And this is how it looks like a data value mannually added in the target
>> instance:
>>
>> *"dataElement":"IxbBQzytPgv","period":"2014","orgUnit":"oWNF4d3PK8C","categoryOptionCombo":"psVSPLclyFj","attributeOptionCombo":"HoDiXsWulNy","value":"3"*
>>
>> The only different value is the ATTRIBUTEOPTIONCOMBO, whichi entity does
>> it referenciate? How can we force both instances to have the same id for
>> attributeoptioncombo.
>>
>> Thanks!
>>
>>
>> 2017-01-16 12:55 GMT+01:00 Lars Helge Øverland <lars@xxxxxxxxx>:
>>
>>>
>>>
>>> On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica <marcgarnica13@xxxxxxxxx>
>>> wrote:
>>>
>>>> I was assuming the daily run we have in the source instance but it's
>>>> true that we have not configured it yet in the target one. I will try it!
>>>> Thanks
>>>>
>>>> But also I thought that to visualise the data values at the data entry
>>>> module it was not needed to update the data mart..
>>>>
>>>
>>> This is correct.
>>>
>>>
>>> Then like Jason says, if you are using a non-default attribute option
>>> combo in your source system, and the default/no attribute option combo in
>>> the target system, this is a probably cause for data not appearing.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>>
>>>> Thanks!
>>>> Marc
>>>>
>>>> 2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely <
>>>> traminosoa@xxxxxxxxxx>:
>>>>
>>>>> Hi Marc,
>>>>>
>>>>> Have you already run an update of the data analytics (data mart) after
>>>>> importing data values in the new instance?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Tantely.
>>>>>
>>>>> On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica <marcgarnica13@xxxxxxxxx
>>>>> > wrote:
>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> We are transferring data values from one DHIS2 instance to another
>>>>>> and we are experiencing some troubles. Both instances have the same
>>>>>> metadata, we exported the data from the source instance and run the import
>>>>>> in the target instance.
>>>>>>
>>>>>> The results from the import are correct and if we check the database
>>>>>> the datavalues are there. Even more, if we query through the API for the
>>>>>> data values for a specific data set, and orgunit and a period it gives us
>>>>>> the same data values that the source instance give with the same query.
>>>>>>
>>>>>> But then if we enter the data entry app or create a pivot table
>>>>>> asking for this data, the data is not available.
>>>>>>
>>>>>> DHIS2 2.25 build 8feec9a.
>>>>>>
>>>>>> Has anyone experienced this? Hopefully we are missing something in
>>>>>> the process.
>>>>>>
>>>>>> Thank you very much in advance,
>>>>>>
>>>>>> Marc
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>> *This message and its attachments are confidential and solely for the
>>>>> intended recipients. If received in error, please delete them and notify
>>>>> the sender via reply e-mail immediately.*
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> lars@xxxxxxxxx
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049 <+46%2076%20414%2070%2049>
>