Hi Tirus, Thank you for the response.
Mohamed On Tue, Jan 2, 2018 at 3:19 PM, Tirus Gichuhi <gichuhiti...@gmail.com> wrote: > Hi Mohammed > > I have had this issue as well. Currently H2 database and analytics don't > work properly, you will have to create a new Postgre SQL database or at > least a different database and import your data from the H2 database. > > This issue is not new and was actually raised last year on JIRA as well, > but I believe there is low priority to fix it. Try the method above it is > the only way around this issue. > > Hope this helps > Tirus > > Sent from my iPhone > > On 25 Dec 2017, at 13:07, Mohamed Elkhou <oelk...@gmail.com> wrote: > > Hi All, > > I am experiencing the DHIS2 Live version with an H2 database. I was able > to generate resource tables and analytics without any problem I run > analytics for the first time , but after that, all I was getting was the > following errors. > > > > 2017-12-25 07:26:23 Process failed: StatementCallback; bad SQL > grammar [alter table _orgunitstructure_temp rename to _orgunitstructure;]; > nested exception is org.h2.jdbc.JdbcSQLException: Table "_ORGUNITSTRUCTURE" > already exists; SQL statement: alter table _orgunitstructure_temp rename to > _orgunitstructure; [42101-194] > > 2017-12-25 07:26:23 Updating resource tables > > 2017-12-25 07:26:23 Analytics table update process started > > Please help. The H2 database is very practical for training purposes. > > Best regards, > > Mohamed > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
