Re: [Dhis2-devs] Adding demo data to new server

Great to see you got it working, Yaw! Cheers, Knut On Fri, Jan 27, 2017 at 9:18 PM, Yaw Anokwa wrote: > Hi all, > > I finally got a chance to try this out again and it's now working with > Ubuntu 16, OpenJDK 1.8, Tomcat 8, PostgreSQL 9.5, and PostGIS 2.2. > What worked

Re: [Dhis2-devs] Adding demo data to new server

Hi all, I finally got a chance to try this out again and it's now working with Ubuntu 16, OpenJDK 1.8, Tomcat 8, PostgreSQL 9.5, and PostGIS 2.2. What worked best was using a separate DB for the demo data. I've posted my config (Vagrant, Ansible) to https://github.com/nafundi/dhis2-vagrant. Hope

Re: [Dhis2-devs] Adding demo data to new server

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.

Re: [Dhis2-devs] Adding demo data to new server

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 wrote: > Thanks Jason for that tip. Seems like the

Re: [Dhis2-devs] Adding demo data to new server

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:

Re: [Dhis2-devs] Adding demo data to new server

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 wrote: > Thanks for your patience, and my apologies! You were correct. > > I've now confirmed that I'm now connected to the

Re: [Dhis2-devs] Adding demo data to new server

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

Re: [Dhis2-devs] Adding demo data to new server

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" wrote: > Hi Knut,

Re: [Dhis2-devs] Adding demo data to new server

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

Re: [Dhis2-devs] Adding demo data to new server

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