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 <yano...@nafundi.com> 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 > <jason.p.picker...@gmail.com> 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 <yano...@nafundi.com> 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 <knu...@gmail.com> > 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" <yano...@nafundi.com> 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 <knu...@gmail.com> > >> >> 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" <yano...@nafundi.com> 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 : dhis2-devs@lists.launchpad.net > >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> >> >> More help : https://help.launchpad.net/ListHelp > >> >> >> > >> >> > > >> > >> _______________________________________________ > >> Mailing list: https://launchpad.net/~dhis2-devs > >> Post to : dhis2-devs@lists.launchpad.net > >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> More help : https://help.launchpad.net/ListHelp > > > > > > > > > > -- > > Jason P. Pickering > > email: jason.p.picker...@gmail.com > > tel:+46764147049 > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp