dhis2-devs team mailing list archive

[Yaw Anokwa <yanokwa@xxxxxxxxxxx>]

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