dhis2-users team mailing list archive

[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