Re: [Dhis2-devs] Error with Usage analytics

2016-07-04 Thread Jason Pickering
I looked at one record and got this -[ RECORD 1 ]--+ statisticsid | 1309547 uid| MAopqnaf393 code | created| 2016-06-30 02:00:00.034 lastupdated| 2016-06-30 02:00:00.034 chartviews | 127 mapviews

Re: [Dhis2-devs] Error with Usage analytics

2016-07-04 Thread Jason Pickering
Sorry about that. Let me try again. This happens when pressing "Update" after the app has loaded. On the demo site, this looks OK https://play.dhis2.org/demo/api/dataStatistics?startDate=2016-3-4&endDate=2016-7-4&interval=WEEK&_=1467648739291 but does not work on this specific server. Regards,

Re: [Dhis2-devs] Error with Usage analytics

2016-07-04 Thread Jason Pickering
Here is the actual URL On Mon, Jul 4, 2016 at 10:35 AM, Halvdan Hoem Grelland wrote: > Does this happen on loading the app or when running a specific query > within it? Can you reproduce on the SL or trainingland demo db? > > On Mon, Jul 4, 2016 at 2:21 PM, Jason Pickering < > jason.p.picker...

Re: [Dhis2-devs] Error with Usage analytics

2016-07-04 Thread Halvdan Hoem Grelland
Does this happen on loading the app or when running a specific query within it? Can you reproduce on the SL or trainingland demo db? On Mon, Jul 4, 2016 at 2:21 PM, Jason Pickering wrote: > On 2.23, revision 23038 > > Getting this error when attempting to use the usage analytics app. > > org.pos

[Dhis2-devs] Error with Usage analytics

2016-07-04 Thread Jason Pickering
On 2.23, revision 23038 Getting this error when attempting to use the usage analytics app. org.postgresql.util.PSQLException: ERROR: division by zero org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284) org.postgresql.core.v3.QueryExecutorIm