[Bug 1625181] [NEW] Organisation Unit Data Lost After Restarting Web Server

Support - Assistance technique
1

Public bug reported:

When i am trying to create organisation unit hierarchy in new empty
database, and after some time later when i am getting loged out and
restarting server, it loses all organization unit hierarchy in database
organisation unit table in database in spite of i have assigned value

hibernate.connection.schema = update

in "dhis.conf" file in "DHIS2_HOME" system environment variable.

I think this is a very serious bug in dhis trunk and in dhis2.24 branch.

** Affects: dhis2
     Importance: Undecided
         Status: New

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  New

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

2

Specially i did system integration testing with PostGres Data Base, i found data does't preserve and after restating server, it loses all data, i am not sure but it can be a bug or might be i am losing some system
configuration issue which need to be taken care of apart form setting values like

hibernate.connection.schema = update

in dhis.conf or hibernate.property file. Guide me in this situation where i am not been able to find exact
solution for above system integration testing use case.

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  New

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

3

Your dhis.conf should look like this:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update

···

On Mon, Sep 19, 2016 at 3:15 PM, Brajesh Murari <1625181@bugs.launchpad.net> wrote:

Specially i did system integration testing with PostGres Data Base, i
found data does't preserve and after restating server, it loses all data, i
am not sure but it can be a bug or might be i am losing some system
configuration issue which need to be taken care of apart form setting
values like

hibernate.connection.schema = update

in dhis.conf or hibernate.property file. Guide me in this situation where
i am not been able to find exact
solution for above system integration testing use case.

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  New

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

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

** Changed in: dhis2
       Status: New => Invalid

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

4

Try this in your dhis.conf:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

5

Yes i replaced one line in dhis.conf

hibernate.connection.schema = update
by
hibernate.hbm2ddl.auto = update

and its working

Thanks Knut

···

On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring <knutst@gmail.com> wrote:

Try this in your dhis.conf:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

Launchpad-Notification-Type: bug
Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;
assignee=None;
Launchpad-Bug-Information-Type: Public
Launchpad-Bug-Private: no
Launchpad-Bug-Security-Vulnerability: no
Launchpad-Bug-Commenters: brajesh-murari knutst
Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)
Launchpad-Bug-Modifier: Knut Staring (knutst)
Launchpad-Message-Rationale: Subscriber
Launchpad-Message-For: brajesh-murari

--
Thanks and Regards

Brajesh Murari

Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

6

Dear Murari,

The correct dhis.conf is

connection.dialect = org.hibernate.dialect.PostgreSQLDialect`` connection.driver_class = org.postgresql.Driver ```` connection.url = jdbc:postgresql:dhis2`` connection.username = dhis ```` connection.password = dhis ```` connection.schema = update

See below.

[http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/dhis2_implementation_guide_full.html#d5274e948](http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/dhis2_implementation_guide_full.html#d5274e948)

Alex

···

On Mon, Sep 19, 2016 at 6:02 PM, Brajesh Murari 1625181@bugs.launchpad.net wrote:

–

You received this bug notification because you are a member of DHIS 2

developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1625181

Title:

Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:

Invalid

Bug description:

When i am trying to create organisation unit hierarchy in new empty

database, and after some time later when i am getting loged out and

restarting server, it loses all organization unit hierarchy in

database organisation unit table in database in spite of i have

assigned value

hibernate.connection.schema = update

in “dhis.conf” file in “DHIS2_HOME” system environment variable.

I think this is a very serious bug in dhis trunk and in dhis2.24

branch.

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

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

Yes i replaced one line in dhis.conf

hibernate.connection.schema = update

by

hibernate.hbm2ddl.auto = update

and its working

Thanks Knut

On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring knutst@gmail.com wrote:

Try this in your dhis.conf:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

hibernate.connection.driver_class = org.postgresql.Driver

hibernate.connection.url = jdbc:postgresql:dhis2

hibernate.connection.username = dhis

hibernate.connection.password = dhis

hibernate.hbm2ddl.auto = update

–

You received this bug notification because you are subscribed to the bug

report.

https://bugs.launchpad.net/bugs/1625181

Title:

Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:

Invalid

Bug description:

When i am trying to create organisation unit hierarchy in new empty

database, and after some time later when i am getting loged out and

restarting server, it loses all organization unit hierarchy in

database organisation unit table in database in spite of i have

assigned value

hibernate.connection.schema = update

in “dhis.conf” file in “DHIS2_HOME” system environment variable.

I think this is a very serious bug in dhis trunk and in dhis2.24

branch.

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

Launchpad-Notification-Type: bug

Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;

assignee=None;

Launchpad-Bug-Information-Type: Public

Launchpad-Bug-Private: no

Launchpad-Bug-Security-Vulnerability: no

Launchpad-Bug-Commenters: brajesh-murari knutst

Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)

Launchpad-Bug-Modifier: Knut Staring (knutst)

Launchpad-Message-Rationale: Subscriber

Launchpad-Message-For: brajesh-murari

–

Thanks and Regards

Brajesh Murari

| Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET | HISP Uganda

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

7

Its working.

Thanks Alex.

···

On Tue, Sep 20, 2016 at 2:22 AM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Murari,

The correct dhis.conf is

connection.dialect = org.hibernate.dialect.PostgreSQLDialect`` connection.driver_class = org.postgresql.Driver ```` connection.url = jdbc:postgresql:dhis2`` connection.username = dhis ```` connection.password = dhis ```` connection.schema = update

See below.

[http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/dhis2_implementation_guide_full.html#d5274e948](http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/dhis2_implementation_guide_full.html#d5274e948)

Alex

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

–

On Mon, Sep 19, 2016 at 6:02 PM, Brajesh Murari 1625181@bugs.launchpad.net wrote:

Yes i replaced one line in dhis.conf

hibernate.connection.schema = update

by

hibernate.hbm2ddl.auto = update

and its working

Thanks Knut

On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring knutst@gmail.com wrote:

Try this in your dhis.conf:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

hibernate.connection.driver_class = org.postgresql.Driver

hibernate.connection.url = jdbc:postgresql:dhis2

hibernate.connection.username = dhis

hibernate.connection.password = dhis

hibernate.hbm2ddl.auto = update

–

You received this bug notification because you are subscribed to the bug

report.

https://bugs.launchpad.net/bugs/1625181

Title:

Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:

Invalid

Bug description:

When i am trying to create organisation unit hierarchy in new empty

database, and after some time later when i am getting loged out and

restarting server, it loses all organization unit hierarchy in

database organisation unit table in database in spite of i have

assigned value

hibernate.connection.schema = update

in “dhis.conf” file in “DHIS2_HOME” system environment variable.

I think this is a very serious bug in dhis trunk and in dhis2.24

branch.

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

Launchpad-Notification-Type: bug

Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;

assignee=None;

Launchpad-Bug-Information-Type: Public

Launchpad-Bug-Private: no

Launchpad-Bug-Security-Vulnerability: no

Launchpad-Bug-Commenters: brajesh-murari knutst

Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)

Launchpad-Bug-Modifier: Knut Staring (knutst)

Launchpad-Message-Rationale: Subscriber

Launchpad-Message-For: brajesh-murari

–

Thanks and Regards

Brajesh Murari

| Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |

–

You received this bug notification because you are a member of DHIS 2

developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1625181

Title:

Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:

Invalid

Bug description:

When i am trying to create organisation unit hierarchy in new empty

database, and after some time later when i am getting loged out and

restarting server, it loses all organization unit hierarchy in

database organisation unit table in database in spite of i have

assigned value

hibernate.connection.schema = update

in “dhis.conf” file in “DHIS2_HOME” system environment variable.

I think this is a very serious bug in dhis trunk and in dhis2.24

branch.

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

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

–
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET | HISP Uganda

Kampala

Uganda
+256 774149 775, + 256 759 800161

Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don’t want to be anything other than what I have been - one tree hill "

Thanks and Regards

Brajesh Murari

| Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |

8

I think this is likely my personal user error but somewhere along the
lines I've gotten confused on if my config file should be named
dhis.conf or hibernate.properties. I'm also confused on whether the file
should use "hibernate.connection" or "connection.xxxxx" and if the
correct notation for the schema update is ".hbm2ddl.auto" or ".schema"

Either way, my configurations are lost after rebooting the web server.
Any help would be appreciated!

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

9

Scott,

The config file up to version 2.21 was called "hibernate.properties"

From 2.22 onwards this was changed to dhis.conf

So it's a version issue.

Regards
Calle

···

On 24 September 2016 at 23:56, Scott Allen <1625181@bugs.launchpad.net> wrote:

I think this is likely my personal user error but somewhere along the
lines I've gotten confused on if my config file should be named
dhis.conf or hibernate.properties. I'm also confused on whether the file
should use "hibernate.connection" or "connection.xxxxx" and if the
correct notation for the schema update is ".hbm2ddl.auto" or ".schema"

Either way, my configurations are lost after rebooting the web server.
Any help would be appreciated!

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

*******************************************

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

10

Hi,

this is all clearly explained in the installation guide:

http://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_database_configuration

regards,

Lars

···

On Sun, Sep 25, 2016 at 10:10 AM, Calle Hedberg <calle.hedberg@gmail.com> wrote:

Scott,

The config file up to version 2.21 was called "hibernate.properties"

From 2.22 onwards this was changed to dhis.conf

So it's a version issue.

Regards
Calle

On 24 September 2016 at 23:56, Scott Allen <1625181@bugs.launchpad.net> > wrote:

I think this is likely my personal user error but somewhere along the
lines I've gotten confused on if my config file should be named
dhis.conf or hibernate.properties. I'm also confused on whether the file
should use "hibernate.connection" or "connection.xxxxx" and if the
correct notation for the schema update is ".hbm2ddl.auto" or ".schema"

Either way, my configurations are lost after rebooting the web server.
Any help would be appreciated!

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

*******************************************

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

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

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions