dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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 <knutst@xxxxxxxxx> 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 <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 <918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>
> _______________________________________________
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>