I need some help, I’m trying to import an organisation unit from a dhis 2.2 into dhis 2.7.
I have manually populate date from my previous 2.2 organisationunit table into the dhis 2.7 organisationunit table and I did the same for orgunitlevel table. But after restarting dhis 2.7 I find that the organisationunit and orgunitlevel are empty and I’m not able to see anything from the web interface.
Can someone explain me what is happening and how I can solve it?
I also notice these two lines in the logs:
2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool(): Object 0x100131840 of class NSCFNumber autoreleased with no pool in place - just leaking
2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool(): Object 0x1021ad060 of class NSCFArray autoreleased with no pool in place - just leaking
If you populated the table manually, i.e. through SQL, and it gets
overwritten each time you restart, sounds like an issue with the
hibernate.properties file to me.
Not sure about this other error though.
···
On Tue, Apr 17, 2012 at 3:11 PM, Romain-Rolland TOHOURI <romain@tohouri.com> wrote:
Hello all,
I need some help, I'm trying to import an organisation unit from a dhis 2.2
into dhis 2.7.
I have manually populate date from my previous 2.2 organisationunit table
into the dhis 2.7 organisationunit table and I did the same for orgunitlevel
table. But after restarting dhis 2.7 I find that the organisationunit
and orgunitlevel are empty and I'm not able to see anything from the web
interface.
Can someone explain me what is happening and how I can solve it?
I also notice these two lines in the logs:
2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool(): Object
0x100131840 of class NSCFNumber autoreleased with no pool in place - just
leaking
2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool(): Object
0x1021ad060 of class NSCFArray autoreleased with no pool in place - just
leaking
Le 17 avril 2012 14:26, Jason Pickering <jason.p.pickering@gmail.com> a
écrit :
What is your hibernate.properties file?
If you populated the table manually, i.e. through SQL, and it gets
overwritten each time you restart, sounds like an issue with the
hibernate.properties file to me.
Not sure about this other error though.
On Tue, Apr 17, 2012 at 3:11 PM, Romain-Rolland TOHOURI >> <romain@tohouri.com> wrote:
> Hello all,
> I need some help, I'm trying to import an organisation unit from a dhis
> 2.2
> into dhis 2.7.
> I have manually populate date from my previous 2.2 organisationunit
> table
> into the dhis 2.7 organisationunit table and I did the same
> for orgunitlevel
> table. But after restarting dhis 2.7 I find that the organisationunit
> and orgunitlevel are empty and I'm not able to see anything from the web
> interface.
> Can someone explain me what is happening and how I can solve it?
>
> I also notice these two lines in the logs:
> 2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool():
> Object
> 0x100131840 of class NSCFNumber autoreleased with no pool in place -
> just
> leaking
> 2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool():
> Object
> 0x1021ad060 of class NSCFArray autoreleased with no pool in place - just
> leaking
>
>
> Thanks,
>
> Romain
>
> _______________________________________________
> 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
>
You must be a bit careful, as the database schema does not always tell
you what is required. If you are populating manually from SQL, you
must set "active" and "haspatients" to something and all other NOT
NULL fields. There is no default in the schema, so you must set it
through the insert statement.From the schema, NULLS are allowed in
"openingdate", but this is not really the case as you have observed.
Regards,
Jason
···
On Tue, Apr 17, 2012 at 4:15 PM, Romain-Rolland TOHOURI <romain@tohouri.com> wrote:
Thanks Jason
now its works! and the second mistake was the fact that was not adding an
opening date for the orgunits that why I was unable to see them in dhis.
Regards,
Romain
Le 17 avril 2012 14:36, Jason Pickering <jason.p.pickering@gmail.com> a
écrit :
Yes. Classic mistake, made by yours truly at least once (consult the
archives)
Uncomment out. #hibernate.hbm2ddl.auto = update
to
hibernate.hbm2ddl.auto = update
Regards,
Jason
On Tue, Apr 17, 2012 at 3:34 PM, Romain-Rolland TOHOURI >> <romain@tohouri.com> wrote:
> here is my hibernate.properties file
>
> #hibernate.dialect = org.hibernate.dialect.H2Dialect
> #hibernate.connection.driver_class = org.h2.Driver
> #hibernate.connection.url =
> jdbc:h2:./database/dhis2;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
> #hibernate.connection.username = sa
> #hibernate.connection.password =
>
> hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
> hibernate.connection.driver_class = org.postgresql.Driver
> hibernate.connection.url = jdbc:postgresql:dhis
> hibernate.connection.username = dhis
> hibernate.connection.password = dhis
>
> #hibernate.hbm2ddl.auto = update
>
> Do you see something wrong in it?
>
> Regards,
>
> Romain
>
> Le 17 avril 2012 14:26, Jason Pickering <jason.p.pickering@gmail.com> a
> écrit :
>
>> What is your hibernate.properties file?
>>
>> If you populated the table manually, i.e. through SQL, and it gets
>> overwritten each time you restart, sounds like an issue with the
>> hibernate.properties file to me.
>>
>> Not sure about this other error though.
>>
>> On Tue, Apr 17, 2012 at 3:11 PM, Romain-Rolland TOHOURI >> >> <romain@tohouri.com> wrote:
>> > Hello all,
>> > I need some help, I'm trying to import an organisation unit from a
>> > dhis
>> > 2.2
>> > into dhis 2.7.
>> > I have manually populate date from my previous 2.2 organisationunit
>> > table
>> > into the dhis 2.7 organisationunit table and I did the same
>> > for orgunitlevel
>> > table. But after restarting dhis 2.7 I find that the organisationunit
>> > and orgunitlevel are empty and I'm not able to see anything from the
>> > web
>> > interface.
>> > Can someone explain me what is happening and how I can solve it?
>> >
>> > I also notice these two lines in the logs:
>> > 2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool():
>> > Object
>> > 0x100131840 of class NSCFNumber autoreleased with no pool in place -
>> > just
>> > leaking
>> > 2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool():
>> > Object
>> > 0x1021ad060 of class NSCFArray autoreleased with no pool in place -
>> > just
>> > leaking
>> >
>> >
>> > Thanks,
>> >
>> > Romain
>> >
>> > _______________________________________________
>> > 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
>> >
>
>
>
>
> --
> Dr Tohouri Romain-Rolland
> www.tohouri.com
You are right! I’m able to see the organisationunit tree from the map and over windows but when I’m trying to show the organisation unit view I’m facing a java heap memory error. I guess there is a null value somewhere that I have fill with something…
Will look at it.
CC: “dhis2-devs” dhis2-devs@lists.launchpad.net Sent: April 17, 2012 6:13 PM Subject: Re: [Dhis2-devs] Import dhis2 orgunit into 2.7
You must be a bit careful, as the database schema does not always tell
you what is required. If you are populating manually from SQL, you
must set “active” and “haspatients” to something and all other NOT
NULL fields. There is no default in the schema, so you must set it
through the insert statement.From the schema, NULLS are allowed in
“openingdate”, but this is not really the case as you have observed.
Regards,
Jason
On Tue, Apr 17, 2012 at 4:15 PM, Romain-Rolland TOHOURI romain@tohouri.com wrote:
Thanks Jason
now its works! and the second mistake was the fact that was not adding an
opening date for the orgunits that why I was unable to see them in dhis.
If you populated the table manually, i.e. through SQL, and it gets
overwritten each time you restart, sounds like an issue with the
hibernate.properties file to me.
Not sure about this other error though.
On Tue, Apr 17, 2012 at 3:11 PM, Romain-Rolland TOHOURI >> >> romain@tohouri.com wrote:
Hello all,
I need some help, I’m trying to import an organisation unit from a
dhis
2.2
into dhis 2.7.
I have manually populate date from my previous 2.2 organisationunit
table
into the dhis 2.7 organisationunit table and I did the same
for orgunitlevel
table. But after restarting dhis 2.7 I find that the organisationunit
and orgunitlevel are empty and I’m not able to see anything from the
web
interface.
Can someone explain me what is happening and how I can solve it?
I also notice these two lines in the logs:
2012-04-17 13:54:37.371 java[45912:f203] *** __NSAutoreleaseNoPool():
Object
0x100131840 of class NSCFNumber autoreleased with no pool in place -
just
leaking
2012-04-17 13:54:37.374 java[45912:f203] *** __NSAutoreleaseNoPool():
Object
0x1021ad060 of class NSCFArray autoreleased with no pool in place -