date:20170128

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread Seid Hussein

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  wrote:

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

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread Bob Jolliffe

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

On 28 January 2017 at 19:55, gerald thomas  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"  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  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  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 
>> 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-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread gerald thomas

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"  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  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  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 
> 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-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread Bob Jolliffe

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  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  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 
> 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-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread gerald thomas

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  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  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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

2017-01-28 Thread Seid Hussein

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  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
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading

2017-01-28 Thread Elmarie Claasen

Hi Calle,

The issue was the umlaut that remained in RIPDA in the word naive and it
seemed that 1st and 2nd was somehow superscripted on other elements.

Once we corrected those the dataset report downloaded fine in excel and pdf.

Elmarie

On 28 Jan 2017 03:36, "Calle Hedberg"  wrote:

> Elmarie,
>
> We have cleaned up many of the special characters in the data element and
> indicator table fields, but a number remains (in particular full stops and
> commas). There might be a few others - it's a lot to go through and a lot
> of problems to clean up.
>
> Exactly which special character caused the problem in the case you refer
> to?
>
> Regards
> calle
>
> On 27 January 2017 at 15:39, gerald thomas  wrote:
>
>> Dear Elmarie,
>>
>> I had done Data Integrity Checks but i don't know which option is
>> responsible for dataelements names with special characters. Besides we
>> had been doing data cleanup and we fixed most of those issues.
>>
>> On 1/27/17, Elmarie Claasen  wrote:
>> > Gerald,
>> >
>> > We had the same problem so e toime back. Check that you dont have any
>> > special characters in dataelement names.
>> >
>> > Elmarie
>> >
>> > On 27 Jan 2017 14:29, "gerald thomas"  wrote:
>> >
>> >> Dear All,
>> >> We had successfully upgraded to version 2.25 but i noticed that we
>> >> can't download to excel or PDF our data set reports.
>> >>
>> >> Please i don't know if it is a bug but it is working on the DHIS2 demo
>> >> but not on our production server.
>> >>
>> >> Thanks in advance for your help.
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> > --
>> >
>> >
>> > *This message and any attachments are subject to a disclaimer published
>> at
>> > http://www.hisp.org/policies.html#comms_disclaimer
>> > .  Please read the
>> > disclaimer before opening any attachment or taking any other action in
>> > terms of this electronic transmission.  If you cannot access the
>> > disclaimer, kindly send an email to disclai...@hisp.org
>> >  and a copy will be provided to you. By replying
>> to
>> > this e-mail or opening any attachment you agree to be bound by the
>> > provisions of the disclaimer.*
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Re: [Dhis2-devs] Data Set Report is not Downloading

7 matches

Site Navigation

Mail list logo

Footer information