dhis2-users team mailing list archive

[gerald thomas <gerald17006@xxxxxxxxx>]

Good morning all,

Bob, at some point Calle was importing metadata but i don't know if
that should be an issue. I am currently monitoring the logs to see if
i will receive those errors again.

On 1/28/17, Seid Hussein <seid.hisp@xxxxxxxxx> wrote:
> Hi Gerald,
>
> You can use the (insert if not exists) query to insert your data. But
> unlike the COPY function which allows bulk insert, you have to write an
> insert statement for each data value you intend to insert.
>
> Regards,
>
>
> Seid,
>
> On Saturday, January 28, 2017, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>
>> where does the data come from that you try to import?
>>
>> On 28 January 2017 at 19:55, gerald thomas <gerald17006@xxxxxxxxx
>> <javascript:_e(%7B%7D,'cvml','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
>>> <javascript:_e(%7B%7D,'cvml','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
>>> <javascript:_e(%7B%7D,'cvml','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
>>>> <javascript:_e(%7B%7D,'cvml','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
>>>> <javascript:_e(%7B%7D,'cvml','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
>>>> <javascript:_e(%7B%7D,'cvml','dhis2-users@xxxxxxxxxxxxxxxxxxx');>
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>>
>>>
>>
>


-- 
Regards,

Gerald