Re: [Dhis2-devs] sql error in analytics table name

2016-07-28 Thread Anthony Danso
Thanks Bob. I am currently running dhis 2.22 version 22086 and upgraded the Postgres from version 9.3 to version 9.5. The analytics was successful in the previous Postgres versions 9.3 and the dhis version 2.21. Strange enough, the tracker instance is having no issue with running analytics.It

[Dhis2-devs] sql error in analytics table name

2016-07-28 Thread Bob Jolliffe
Hi The folk in ghana are hitting a problem running analytics where an invalid table name is being generated. Specifically the sql which fails is: create table analytics_event_temp_-1_r8cbfnorkzf ( ... instead of something like ... create table analytics_event_temp_2015_r8cbfnorkzf (