dhis2-users team mailing list archive

[gerald thomas <gerald17006@xxxxxxxxx>]

Seid,
Thanks for your help but how can i identify those dataelements:

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.

On 1/28/17, Seid Hussein <seid.hisp@xxxxxxxxx> wrote:
> 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
>>
>


-- 
Regards,

Gerald