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.
···
2017-01-16 13:58 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:
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@gmail.com 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!
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
2017-01-16 12:55 GMT+01:00 Lars Helge Øverland lars@dhis2.org:
On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica marcgarnica13@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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@dhis2.org
http://www.dhis2.org
–
2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org:
Hi Marc,
Have you already run an update of the data analytics (data mart) after importing data values in the new instance?
Thanks,
Tantely.
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.
On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp