dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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

On 24 July 2018 at 11:56, Kamugunga Adolphe <kaadol@xxxxxxxxx> 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
>
> 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@xxxxxxxxx
> Skype: ka.adolphe
>  RWANDA
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

*******************************************

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@xxxxxxxxx

Skype: calle_hedberg

*******************************************