Re: [Dhis2-devs] 404 response from the API when using Event Capture

[Kevin Bolger]

Hi Markus,

Thanks for the response!

I've cleared the cache with the cache cleaner app a number of times, and
also tried a number of versions of (2.27, 2.28, 2.29 & 2.30) and I'm seeing
the same issue on each. I've dropped the database completely and recreated
before deploying each version. Still the same issue each time (starting to
think there may be a problem with either my Tomcat or postgresql builds).

There are a couple of failures I believe in catalina.out during the build,
but most (or all) other features that I use seem to be working ok.
I think most are related to GIS modules but I'll give them a more detailed
second pass.

If you were willing/able to take a closer look then I could provide you
with the server link and a temp login account.

Best,
Kevin

On Fri, Nov 2, 2018 at 9:29 AM Markus Bekken  wrote:

> Hey Carlos and Kevin,
> The eventCaptureGridColumns call is likely not the problem - this error is
> just a bit of log noise that comes in the console for everyone that has
> never rearranged the columns in the event capture.
>
> Have you tried clearing the cache with the cache cleaner app? Is there any
> other calls failing during the startup that seems to fail? I tried
> reproducing in 2.29 play but the app seems to be working there.
>
> Markus
>
> P.S. we are welcoming you all to join community.dhis2.org for support and
> discussions on DHIS2.
>
> 2. nov. 2018 kl. 13:21 skrev Kevin Bolger :
>
> Hi Carlos,
>
> Thanks for your response. Any idea what the correct format might be?
>
> Thanks,
> Kevin
>
> On Fri, Nov 2, 2018 at 1:59 AM Carlos Nyembwe  wrote:
>
>> Hi Kevin,
>>
>> be sure on your API Url, I think It's not well
>>
>> Regards
>>
>> On Fri, Nov 2, 2018 at 4:54 AM Kevin Bolger 
>> wrote:
>>
>>> [image: Boxbe]  This message is
>>> eligible for Automatic Cleanup! (kevin.bol...@gmail.com) Add cleanup
>>> rule
>>> 
>>> | More info
>>> 
>>> Hi Folks,
>>>
>>> I've deployed 2.29 build e1c949f (full About details below) on an aws
>>> ec2 instance running Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-1070-aws x86_64).
>>>
>>> When trying to use the Event Capture app to record a single event the
>>> page load stalls.
>>> In response to the api call;
>>>
 *8080/api/28/userDataStore/gridColumns/eventCaptureGridColumns*
>>>
>>> the debugging console in chrome shows the following error;
>>>
 *{"httpStatus":"Not
 Found","httpStatusCode":404,"status":"ERROR","message":"The key
 'eventCaptureGridColumns' was not found in the namespace 'gridColumns'."}*
>>>
>>>
>>> The catalina.out logs don't show any warning or error when the issue
>>> occurs or anything referencing an obviously related issue during the
>>> ROOT.war deployment. Any suggestions on how to further troubleshoot would
>>> be greatly appreciated.
>>>
>>> Best,
>>> Kevin
>>>
>>>  Current user:adminVersion:2.29Build revision:e1c949fBuild date:2018-11-02 
>>> 02:21Jasper reports version:6.3.1User agent:Mozilla/5.0 (Macintosh; Intel 
>>> Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) 
>>> Chrome/70.0.3538.77 Safari/537.36Server date:2018-11-02 03:20Last analytics 
>>> table generation:Time since last analytics table generation:Last analytics 
>>> table runtime:Environment variable:DHIS2_HOMEExternal configuration 
>>> directory:/home/dhis/configFile store provider:filesystemNode ID:Cache 
>>> provider:ehcacheDatabase type:DhisPostgresDatabase name:dhis2Database 
>>> user:dhisRead replica count:0Java opts:-Xmx768m -Xms512m 
>>> -Djdk.tls.ephemeralDHKeySize=2048 
>>> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
>>> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027Java 
>>> version:1.8.0_181Java vendor:Oracle CorporationOS name:LinuxOS 
>>> architecture:amd64OS version:4.4.0-1070-awsServer memory:Mem Total in JVM: 
>>> 744 Free in JVM: 451 Max Limit: 744CPU cores:2
>>>
>>> ___
>>> 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
>>>
>>
>>
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381*
>> *Find me in: | Google Plus  | 
>> **Linkedin
>> 

Re: [Dhis2-devs] [Dhis2-users] Request

[Pradeep Kumar Thakur]

Thank you. I will provide detail in community.dhis2.org.

Regards,
Pradeep

From: Markus Bekken 
Sent: Friday, November 2, 2018 7:17 PM
To: Pradeep Kumar Thakur 
Cc: DHIS 2 Users list ; dhis2-devs 
; Bhagawan Shrestha 
Subject: Re: [Dhis2-users] Request

Hi there Pradeep,
can you give some more details on the indicator you want to make, and how you 
want to evaluate the date? Its great if you provide the details in a new post 
in community.dhis2.org

Markus


2. nov. 2018 kl. 14:12 skrev Pradeep Kumar Thakur 
mailto:ptha...@fhi360.org>>:

Hi,

I want to develop program indicators based on date (calendar) elements of 
Tracker Capture version 2.9. Please suggest me the steps.

Regards,
Pradeep
___
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] 404 response from the API when using Event Capture

[Markus Bekken]

Hey Carlos and Kevin,
The eventCaptureGridColumns call is likely not the problem - this error is just 
a bit of log noise that comes in the console for everyone that has never 
rearranged the columns in the event capture. 

Have you tried clearing the cache with the cache cleaner app? Is there any 
other calls failing during the startup that seems to fail? I tried reproducing 
in 2.29 play but the app seems to be working there.

Markus

P.S. we are welcoming you all to join community.dhis2.org 
 for support and discussions on DHIS2.

> 2. nov. 2018 kl. 13:21 skrev Kevin Bolger  >:
> 
> Hi Carlos,
> 
> Thanks for your response. Any idea what the correct format might be?
> 
> Thanks,
> Kevin
> 
> On Fri, Nov 2, 2018 at 1:59 AM Carlos Nyembwe  > wrote:
> Hi Kevin,
> 
> be sure on your API Url, I think It's not well
> 
> Regards
> 
> On Fri, Nov 2, 2018 at 4:54 AM Kevin Bolger  > wrote:
>     This message is eligible for Automatic 
> Cleanup! (kevin.bol...@gmail.com ) Add cleanup 
> rule 
> 
>  | More info 
> 
>  
> Hi Folks,
> 
> I've deployed 2.29 build e1c949f (full About details below) on an aws ec2 
> instance running Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-1070-aws x86_64).
> 
> When trying to use the Event Capture app to record a single event the page 
> load stalls. 
> In response to the api call;
> 8080/api/28/userDataStore/gridColumns/eventCaptureGridColumns
> the debugging console in chrome shows the following error; 
> {"httpStatus":"Not 
> Found","httpStatusCode":404,"status":"ERROR","message":"The key 
> 'eventCaptureGridColumns' was not found in the namespace 'gridColumns'."}
>  
> The catalina.out logs don't show any warning or error when the issue occurs 
> or anything referencing an obviously related issue during the ROOT.war 
> deployment. Any suggestions on how to further troubleshoot would be greatly 
> appreciated.
> 
> Best,
> Kevin
>  
> Current user:
> admin
> Version:
> 2.29
> Build revision:
> e1c949f
> Build date:
> 2018-11-02 02:21
> Jasper reports version:
> 6.3.1
> User agent:
> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, 
> like Gecko) Chrome/70.0.3538.77 Safari/537.36
> Server date:
> 2018-11-02 03:20
> Last analytics table generation:
> Time since last analytics table generation:
> Last analytics table runtime:
> Environment variable:
> DHIS2_HOME
> External configuration directory:
> /home/dhis/config
> File store provider:
> filesystem
> Node ID:
> Cache provider:
> ehcache
> Database type:
> DhisPostgres
> Database name:
> dhis2
> Database user:
> dhis
> Read replica count:
> 0
> Java opts:
> -Xmx768m -Xms512m -Djdk.tls.ephemeralDHKeySize=2048 
> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
> Java version:
> 1.8.0_181
> Java vendor:
> Oracle Corporation
> OS name:
> Linux
> OS architecture:
> amd64
> OS version:
> 4.4.0-1070-aws
> Server memory:
> Mem Total in JVM: 744 Free in JVM: 451 Max Limit: 744
> CPU cores:
> 2
> ___
> 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 
> 
> 
> 
> -- 
> Carlos Nyembwe
> I'm just a Computer Scientist
> 
> Skype: carloscnk1
> Cell: (+243)813166381
> Find me in: | Google Plus  | Linkedin 
>  | Facebook 
>  | Twitter 
>  |
> ___
> 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] Request

[Markus Bekken]

Hi there Pradeep,
can you give some more details on the indicator you want to make, and how you 
want to evaluate the date? Its great if you provide the details in a new post 
in community.dhis2.org 

Markus

> 2. nov. 2018 kl. 14:12 skrev Pradeep Kumar Thakur :
> 
> Hi,
>  
> I want to develop program indicators based on date (calendar) elements of 
> Tracker Capture version 2.9. Please suggest me the steps.
>  
> Regards,
> Pradeep
> ___
> 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

[Dhis2-devs] Request

[Pradeep Kumar Thakur]

Hi,

I want to develop program indicators based on date (calendar) elements of 
Tracker Capture version 2.9. Please suggest me the steps.

Regards,
Pradeep
___
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] 404 response from the API when using Event Capture

[Kevin Bolger]

Hi Carlos,

Thanks for your response. Any idea what the correct format might be?

Thanks,
Kevin

On Fri, Nov 2, 2018 at 1:59 AM Carlos Nyembwe  wrote:

> Hi Kevin,
>
> be sure on your API Url, I think It's not well
>
> Regards
>
> On Fri, Nov 2, 2018 at 4:54 AM Kevin Bolger 
> wrote:
>
>> [image: Boxbe]  This message is eligible
>> for Automatic Cleanup! (kevin.bol...@gmail.com) Add cleanup rule
>> 
>> | More info
>> 
>> Hi Folks,
>>
>> I've deployed 2.29 build e1c949f (full About details below) on an aws ec2
>> instance running Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-1070-aws x86_64).
>>
>> When trying to use the Event Capture app to record a single event the
>> page load stalls.
>> In response to the api call;
>>
>>> *8080/api/28/userDataStore/gridColumns/eventCaptureGridColumns*
>>
>> the debugging console in chrome shows the following error;
>>
>>> *{"httpStatus":"Not
>>> Found","httpStatusCode":404,"status":"ERROR","message":"The key
>>> 'eventCaptureGridColumns' was not found in the namespace 'gridColumns'."}*
>>
>>
>> The catalina.out logs don't show any warning or error when the issue
>> occurs or anything referencing an obviously related issue during the
>> ROOT.war deployment. Any suggestions on how to further troubleshoot would
>> be greatly appreciated.
>>
>> Best,
>> Kevin
>>
>>  Current user:adminVersion:2.29Build revision:e1c949fBuild date:2018-11-02 
>> 02:21Jasper reports version:6.3.1User agent:Mozilla/5.0 (Macintosh; Intel 
>> Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 
>> Safari/537.36Server date:2018-11-02 03:20Last analytics table 
>> generation:Time since last analytics table generation:Last analytics table 
>> runtime:Environment variable:DHIS2_HOMEExternal configuration 
>> directory:/home/dhis/configFile store provider:filesystemNode ID:Cache 
>> provider:ehcacheDatabase type:DhisPostgresDatabase name:dhis2Database 
>> user:dhisRead replica count:0Java opts:-Xmx768m -Xms512m 
>> -Djdk.tls.ephemeralDHKeySize=2048 
>> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
>> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027Java 
>> version:1.8.0_181Java vendor:Oracle CorporationOS name:LinuxOS 
>> architecture:amd64OS version:4.4.0-1070-awsServer memory:Mem Total in JVM: 
>> 744 Free in JVM: 451 Max Limit: 744CPU cores:2
>>
>> ___
>> 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
>>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
>
___
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] Duplicate Key Error

[Gerald Thomas]

* ERROR 2018-11-01 08:19:14,139 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-460])
* ERROR 2018-11-01 08:19:14,185 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-460])
* ERROR 2018-11-01 08:19:15,774 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-463])
* ERROR 2018-11-01 08:19:15,785 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-463])
* ERROR 2018-11-01 08:20:19,807 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-456])
* ERROR 2018-11-01 08:20:20,066 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-456])
* ERROR 2018-11-01 08:20:24,360 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-468])
* ERROR 2018-11-01 08:20:24,472 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-468])
* ERROR 2018-11-01 08:40:09,194 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-471])
* ERROR 2018-11-01 08:40:09,332 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-471])
* ERROR 2018-11-01 08:50:05,967 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:50:06,161 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:54:14,112 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-447])
* ERROR 2018-11-01 08:54:14,216 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-447])
* ERROR 2018-11-01 08:55:36,021 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:55:36,130 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-466])
* ERROR 2018-11-01 08:56:29,229 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-467])
* ERROR 2018-11-01 08:56:29,359 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-467])
* ERROR 2018-11-01 09:05:56,392 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:05:56,392 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-456])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:10:01,926 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:10:01,927 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-471])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:21,808 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:21,808 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-466])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:36,607 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:11:36,607 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-466])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:25:00,650 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-465])
* ERROR 2018-11-01 09:25:00,755 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-465])
* ERROR 2018-11-01 09:25:19,213 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-458])
* ERROR 2018-11-01 09:25:19,319 Initialised statement manager 
(StatementInterceptor.java [tomcat-http-458])
* ERROR 2018-11-01 09:39:59,115 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:39:59,116 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-456])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:40:00,515 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:40:00,515 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-465])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 09:42:41,203 ERROR: duplicate key value violates unique 
constraint "datavalue_pkey"
* ERROR 2018-11-01 09:42:41,204 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [tomcat-http-463])
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "datavalue_pkey"
* ERROR 2018-11-01 10:46:22,656 Initialised statement manager 
(StatementInterce