dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

where does the data come from that you try to import?

On 28 January 2017 at 19:55, gerald thomas <gerald17006@xxxxxxxxx> wrote:

> Funnily I Bob I only copied a section of the log, I have various
> dataelements ids & period ids which are sending those errors.
> So I am worried where are these errors coming from now.
>
> On Jan 28, 2017 7:31 PM, "Bob Jolliffe" <bobjolliffe@xxxxxxxxx> wrote:
>
> Gerald the clue is in your error message:
>
> Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
> attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.
>
> This usually means you have duplicates among the datavalues you are trying
> to import.  ie. more than one row with the key values as shown in your
> error message.
>
> On 28 January 2017 at 19:02, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>
>> 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
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>