dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <yanokwa@xxxxxxxxxxx> 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.pickering@xxxxxxxxx> 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 <yanokwa@xxxxxxxxxxx> 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 <knutst@xxxxxxxxx>
> 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" <yanokwa@xxxxxxxxxxx> 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 <knutst@xxxxxxxxx>
> >> >> 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" <yanokwa@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> >> >> More help   : https://help.launchpad.net/ListHelp
> >> >> >>
> >> >> >
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >
> >
> >
> >
> > --
> > Jason P. Pickering
> > email: jason.p.pickering@xxxxxxxxx
> > tel:+46764147049
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org