Hi there again,
I am having some issues with viewing details of categorical data elements in the data visualizer. Nothing appears, but I am not able to reproduce it on the demo system, so it must be something with my metadata. The database was bootstrapped with XML which was produced from a legacy system, and then imported into DHIS2. The problem seems to be something to do with the data element operands.
SELECT ‘INSERT INTO dataelementoperand VALUES(’ ||
nextval(‘hibernate_sequence’::regclass) ||‘,’ ||
b.dataelementid || ‘,’ || c.categoryoptioncomboid || ‘);’ from _dataelementcategoryoptioncombo a
INNER JOIN dataelement b on a.dataelementuid = b.uid
INNER JOIN categoryoptioncombo c on a.categoryoptioncombouid = c.uid;
and which generates a bunch of INSERT statements to populate the dataelementoperand table. After that, things worked.
Any ideas what I may have missed during the metadata bootstrap? Seems like I recall having seen something related this before, but it was a slightly different problem.
Hi there again,
I am having some issues with viewing details of categorical data elements in the data visualizer. Nothing appears, but I am not able to reproduce it on the demo system, so it must be something with my metadata. The database was bootstrapped with XML which was produced from a legacy system, and then imported into DHIS2. The problem seems to be something to do with the data element operands.
Jason, we just fixed an issue in 2.14 today where only stored operands were returned. I am pretty sure this solves the problem you are having as well. So most likely nothing wrong with your db, just sloppy devs
Hi there again,
I am having some issues with viewing details of categorical data elements in the data visualizer. Nothing appears, but I am not able to reproduce it on the demo system, so it must be something with my metadata. The database was bootstrapped with XML which was produced from a legacy system, and then imported into DHIS2. The problem seems to be something to do with the data element operands.
SELECT ‘INSERT INTO dataelementoperand VALUES(’ ||
nextval(‘hibernate_sequence’::regclass) ||‘,’ ||
b.dataelementid || ‘,’ || c.categoryoptioncomboid || ‘);’ from _dataelementcategoryoptioncombo a
INNER JOIN dataelement b on a.dataelementuid = b.uid
INNER JOIN categoryoptioncombo c on a.categoryoptioncombouid = c.uid;
and which generates a bunch of INSERT statements to populate the dataelementoperand table. After that, things worked.
Any ideas what I may have missed during the metadata bootstrap? Seems like I recall having seen something related this before, but it was a slightly different problem.
Hi there again,
I am having some issues with viewing details of categorical data elements in the data visualizer. Nothing appears, but I am not able to reproduce it on the demo system, so it must be something with my metadata. The database was bootstrapped with XML which was produced from a legacy system, and then imported into DHIS2. The problem seems to be something to do with the data element operands.