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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
