DB upgrade issue from DHIS2.12 to DHIS2.13

Brajesh_Murari3 · 8 May 2014 07:04

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

Knut_Staring · 8 May 2014 07:24

I guess another way would be to do full metadata and data exports and imports.

···

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

jason · 8 May 2014 07:25

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

···

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

Knut_Staring · 8 May 2014 07:30

Should the Java version matter with 2.13? I thought that was an issue with 2.16?

···

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

Brajesh_Murari3 · 8 May 2014 07:34

Yes Jason, yy all DHIS2 versions under development are using jdk1.7.0_45.
Yes Knut, doing full metadata and data exports and imports works from DHIS2.12 to DHIS2.13.

Thanks

Regards

Brajesh Murari

P please consider the environment before printing this email

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

···

On Thursday, 8 May 2014 12:55 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing
DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

jason · 8 May 2014 07:35

It was an issue for us at least with 2.13. The devs have stated that it is required with 2.16, but we needed to use JDK7 with 2.13 if I am not wrong, certainly with 2.14 and 2.15.
Lots of errors with loading this or that JDBC driver for Postgres, and just thinking in Brajesh’s case, that since it is related to the database, then it might be a similar issue with MySQL, but just guessing.

We also had some issues with duplicate orgunit groups, which were allowed in 2.12, but not in older versions, which was very difficult to diagnose. Enabling Postgresl debugging and examining the log outputs was the only way we could figure out. So, in this case, maybe enbabling debugging logs in MySQL will help to figure out what is going on.

Regards,

Jason

···

On Thu, May 8, 2014 at 9:30 AM, Knut Staring knutst@gmail.com wrote:

Should the Java version matter with 2.13? I thought that was an issue with 2.16?

On 8 May 2014 09:25, “Jason Pickering” jason.p.pickering@gmail.com wrote:

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

jason · 8 May 2014 08:37

Hi Brajesh,

Only suggest I might have in this case then would be to see what the MySQL logs say, with logging of statements enabled.

A full export of your log during the startup process would be helpful as well, as opposed to just that one line.

Regards,

Jason

···

On Thu, May 8, 2014 at 9:34 AM, Brajesh Murari brajeshmurari@yahoo.in wrote:

Yes Jason, yy all DHIS2 versions under development are using jdk1.7.0_45.

Yes Knut, doing full metadata and data exports and imports works from DHIS2.12 to DHIS2.13.

Thanks

Regards

Brajesh Murari

P please consider the environment before printing this email

On Thursday, 8 May 2014 12:55 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

dancocos · 8 May 2014 17:42

Can you verify that MySQL is running and that you can connect to the database with other tools?

···

On Thu, May 8, 2014 at 9:34 AM, Brajesh Murari brajeshmurari@yahoo.in wrote:

Yes Jason, yy all DHIS2 versions under development are using jdk1.7.0_45.

Yes Knut, doing full metadata and data exports and imports works from DHIS2.12 to DHIS2.13.

Thanks

Regards

Brajesh Murari

P please consider the environment before printing this email

On Thursday, 8 May 2014 12:55 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing
DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

Brajesh_Murari3 · 8 May 2014 18:35

Hi DC,

I don’t think i need any varia-fication on my installed MySQL DB for this very simple issue, rather i can say and confirm that my installed MySQL can connect to the database with other tools as well.

Regards

Brajesh Murari

P please consider the environment before printing this email

Can you verify that MySQL is running and that you can connect to the database with other tools?

···

On Thursday, 8 May 2014 11:12 PM, Dan Cocos dcocos@baosystems.com wrote:

On May 8, 2014, at 8:37 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Brajesh,

Only suggest I might have in this case then would be to see what the MySQL logs say, with logging of statements enabled.

A full export of your log during the startup process would be helpful as well, as opposed to just that one line.

Regards,

Jason

On Thu, May 8, 2014 at 9:34 AM, Brajesh Murari brajeshmurari@yahoo.in wrote:

Yes Jason, yy all DHIS2 versions under development are using jdk1.7.0_45.

Yes Knut, doing full metadata and data exports and imports works from DHIS2.12 to DHIS2.13.

Thanks

Regards

Brajesh Murari

P please consider the environment before printing this email

On Thursday, 8 May 2014 12:55 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Brajesh,

Are you certain you are using JDK7 instead of JDK6?

Regards,
Jason

On Thu, May 8, 2014 at 9:24 AM, Knut Staring knutst@gmail.com wrote:

I guess another way would be to do full metadata and data exports and imports.

On 8 May 2014 09:07, “Brajesh Murari” brajeshmurari@yahoo.in wrote:

Hello List,

I am facing a little problem when i am trying to configure DHIS2.13 with data base instance which was previously configured

with DHIS2.12. The execution process seems getting possed at steep given below

INFO 2014-05-08 12:26:21,461 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [main])

But if i am executing
DHIS2.13 with fresh empty data base instance, it does not appear any problem and execution process went

normally.

My question is that, is there any other way to upgrade DHIS2.12 data base to DHIS2.13 data base ?

Regards

Brajesh Murari

P please consider the environment before printing this email

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

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