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.h...@gmail.com> 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 <bobjolli...@gmail.com> wrote: > >> where does the data come from that you try to import? >> >> On 28 January 2017 at 19:55, gerald thomas <gerald17...@gmail.com >> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> 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" <bobjolli...@gmail.com >>> <javascript:_e(%7B%7D,'cvml','bobjolli...@gmail.com');>> 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 <gerald17...@gmail.com >>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> 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.h...@gmail.com >>>> <javascript:_e(%7B%7D,'cvml','seid.h...@gmail.com');>> 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 <gerald17...@gmail.com >>>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> 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@lists.launchpad.net >>>> <javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');> >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> >>> >> > -- Regards, Gerald _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
