Could not save data set (Invalid reference [e1sXdbpUsU7]

Hi,

Can someone assist on how to deal with this error message "Could not save data set (Invalid reference [e1sXdbpUsU7] (DataElementCategoryCombo) on object Chronic Diseases [NXTpxbBK5lf] (DataSet) for association categoryCombo.) " while trying to save the edited data set?

I am running instance on 2.28 with Build revision: a5da35f and Build date: 2018-07-23 06:24

image

···

We have datasets with expiry days, and we have changed it to 0 to allow data managers to updated reports. afterwards we want reset it and save, and system complains of finding reference id. It happens also while someone edit dataset and save even though no changes made on dataset. Here is the

Regards,

Adolphe Kamugunga
MIS Technical Advisor
Mobile: +250 788 740 578
Email:kaadol@gmail.com
Skype: ka.adolphe

RWANDA

Adolphe

Could the data set have one or more data elements with an outdated categorycombo? Individual data elements in a data set can now have “over-riding” categorycombos set (I cannot off hand recall it that was introduced in 2.27 or 2.28)

Maybe try to run something like this in SQL view or in postgresql directly:

SELECT dse.dataelementid, de.name, dse.categorycomboid

FROM datasetelement dse

inner join categorycombo cc on cc.categorycomboid=dse.categorycomboid

inner join dataelement de on de.dataelementid=dse.dataelementid

inner join dataset ds on ds.datasetid=dse.datasetid

where cc.uid='e1sXdbpUsU7' and ds.uid='NXTpxbBK5lf';

Regards

Calle

image

···

On 24 July 2018 at 11:56, Kamugunga Adolphe kaadol@gmail.com wrote:

Hi,

Can someone assist on how to deal with this error message "Could not save data set (Invalid reference [e1sXdbpUsU7] (DataElementCategoryCombo) on object Chronic Diseases [NXTpxbBK5lf] (DataSet) for association categoryCombo.) " while trying to save the edited data set?

I am running instance on 2.28 with Build revision: a5da35f and Build date: 2018-07-23 06:24


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

We have datasets with expiry days, and we have changed it to 0 to allow data managers to updated reports. afterwards we want reset it and save, and system complains of finding reference id. It happens also while someone edit dataset and save even though no changes made on dataset. Here is the

Regards,

Adolphe Kamugunga
MIS Technical Advisor
Mobile: +250 788 740 578
Email:kaadol@gmail.com
Skype: ka.adolphe

RWANDA


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg