where does the data come from that you try to import? On 28 January 2017 at 19:55, gerald thomas <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> 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> 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> 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> >> 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 >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > > >
_______________________________________________ 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
