Hi Yaw, that error is not something I've seen previously.
Try going to apps > data administration > resource tables and generate them manually. Alternatively try to drop all tables starting wit _ (underscore) manually from the database, then try again. https://play.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action You can also check out the very latest demo databases from Github: https://github.com/dhis2/dhis2-demo-db regards, Lars On Wed, Jan 18, 2017 at 11:50 AM, Knut Staring <[email protected]> wrote: > Hi Yaw, > > Not sure what causes this, just wanted to check with you which version of > Postgres you are using since I remember there were some issues with the > latest version (9.6) > > > > On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa <[email protected]> wrote: > >> Thanks Jason for that tip. Seems like the DB isn't very happy. >> >> The export fails with this: >> 2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar >> [alter table _orgunitstructure_temp rename to _orgunitstructure;]; >> nested exception is org.postgresql.util.PSQLException: ERROR: relation >> "_orgunitstructure" already exists >> 2017-01-18 08:53:54Updating resource tables >> 2017-01-18 08:53:54Analytics table update process started >> >> http://dpaste.com/0MCMKSA is the full trace from Tomcat. >> >> On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering >> <[email protected]> wrote: >> > You will need to run analytics >> > >> > https://docs.dhis2.org/master/en/user/html/ch30.html >> > >> > Regards, >> > Jason >> > >> > >> > On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa <[email protected]> >> wrote: >> >> >> >> Thanks for your patience, and my apologies! You were correct. >> >> >> >> I've now confirmed that I'm now connected to the PostgreSQL DB and the >> >> login page reads Sierra Leone. >> >> >> >> How now do I get the various dashboards that are present in the public >> >> demo? >> >> >> >> Yaw >> >> >> >> On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring <[email protected]> >> wrote: >> >> > I would really double check that db connection. You would see what >> you >> >> > see >> >> > if you were currently connected to the internal in-memory H2 db >> rather >> >> > than >> >> > Postgres. What does your tomcat log say? Did you create DHIS_HOME? >> >> > >> >> > >> >> > On Jan 18, 2017 5:36 AM, "Yaw Anokwa" <[email protected]> wrote: >> >> >> >> >> >> Hi Knut, >> >> >> >> >> >> Thanks for the speedy response. I know what DB I'm connected to, so >> >> >> that's not the problem. I think maybe my email was not clear, so let >> >> >> me try again! >> >> >> >> >> >> I'm on a new server (not a Live install) with DHIS installed. I have >> >> >> imported the demo data from the DHIS 2 Demo zip file into the DB on >> >> >> that new server. >> >> >> >> >> >> But when I go look at the web interface of said server, it doesn't >> >> >> look like what I expect. That is, there is nothing that suggests >> that >> >> >> the demo data has been imported. The UI doesn't look like the Sierra >> >> >> Leone demo server at https://play.dhis2.org/demo. >> >> >> >> >> >> Yaw >> >> >> >> >> >> On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring <[email protected]> >> >> >> wrote: >> >> >> > Hi Yaw, >> >> >> > Please click on the gray circle in the upper right corner and >> select >> >> >> > About >> >> >> > DHIS2, >> >> >> > https://play.dhis2.org/demo/dhis-web-commons-about/about.action. >> >> >> > >> >> >> > There you can see what db you are connected to. This is set in the >> >> >> > conf/dhis.conf file for DHIS Live. >> >> >> > >> >> >> > Knut >> >> >> > >> >> >> > >> >> >> > On Jan 18, 2017 3:42 AM, "Yaw Anokwa" <[email protected]> >> wrote: >> >> >> >> >> >> >> >> Hi all, >> >> >> >> >> >> >> >> I've setup DHIS 2.25 on my server and I've successfully imported >> the >> >> >> >> demo data from >> >> >> >> https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip >> >> >> >> into the DB (see my-db.png). >> >> >> >> >> >> >> >> But, when I log into my server, it doesn't look like the demo >> server >> >> >> >> at https://play.dhis2.org/demo/. I've attached screenshots. Am I >> >> >> >> missing something? >> >> >> >> >> >> >> >> Thanks, >> >> >> >> >> >> >> >> Yaw >> >> >> >> >> >> >> >> _______________________________________________ >> >> >> >> Mailing list: https://launchpad.net/~dhis2-devs >> >> >> >> Post to : [email protected] >> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> >> >> >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> >> >> > >> >> >> >> _______________________________________________ >> >> Mailing list: https://launchpad.net/~dhis2-devs >> >> Post to : [email protected] >> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> >> More help : https://help.launchpad.net/ListHelp >> > >> > >> > >> > >> > -- >> > Jason P. Pickering >> > email: [email protected] >> > tel:+46764147049 >> > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 <918%2080%20522> > Skype: knutstar > http://dhis2.org > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland [email protected] http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
