dhis2-devs team mailing list archive

Thread
Date

Re: [Dhis2-users] Analytics Error: Process failed: StatementCallback; bad SQL grammar [create table analytics_event_temp_zxbjnsrdsai ("uidlevel1" character(11),"uidlevel2" character..

To: Allan Makunku <amakunku@xxxxxxxxx>
From: Alejandro <acasrod@xxxxxxxxx>
Date: Fri, 27 Jul 2018 18:24:58 +0200
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx, dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CA+UYw8UTiL38pC9XPQsPYrVZ1RTd+62gkf9eQ1ZYRJKUw6wKGQ@mail.gmail.com>

Hi Allan,

We had a similar error and in our case it was related to this indication in
the update instructions:


   - *PostGIS* is now a required extension for PostgreSQL. Make sure to
   install and enable PostGis in your database before upgrading to DHIS 2.30.
   Please consult the installation guide
   <https://docs.dhis2.org/master/en/implementer/html/install_server_setup.html#install_postgresql_installation>
   .

Just in case is the same issue.

Cheers,
Alejandro

On Thu, Jul 26, 2018 at 12:53 PM, Allan Makunku <amakunku@xxxxxxxxx> wrote:

> Dear All
>
> I just upgraded my dhis2 instance from 2.29 to 2.30. However whenever I
> want to run analytics, I am getting the above error. Has anyone come
>  dhis.log
> <https://drive.google.com/file/d/1gi9fgKr0u8LGYqFGcmy7JPLNsWg3U_Jr/view?usp=drive_web>
> across this and what can I do to have it resolved. Attached is the log file
>
> Please help.
>
> Allan
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>