dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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
>