dhis2-users team mailing list archive

[Seid Hussein <seid.hisp@xxxxxxxxx>]

Hi Gerald,

I believe you're trying to import through the database rather than the API
which is a better option because of you've duplicate there the most
probable action ta update rather than a duplicate error.

Most probably what happened is you have duplicate metadata. Each data value
shall have a unique combination of data element id, period id, org unit id,
category option combo id, and attribute option combo id.

So I suggest you either to use the web API and import through the
import/export module or find out which of the metadata IDs is duplicate and
correct it.

Regards,


Seid,

On Friday, January 27, 2017, gerald thomas <gerald17006@xxxxxxxxx> wrote:

> Dear All,
>
> What is the meaning of this error:
>
> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
> unique constraint "datavalue_pkey"
>   Detail: Key (dataelementid, periodid, sourceid,
> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
> 13, 13) already exists.
>
> Please find the attached copy of catalina.out log file
>
> --
> Regards,
>
> Gerald
>