Help

Hi to all,

I have a problem where file I export cannot be imported to other systems (even back to my own system). Jason and Knut advised me to restore the 2.5 war file (because I was exporting from the 2.6 version). Now I get a message which I have attached along with the log file. Is there any advice for me? I can’t use the database.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

index.action.htm (33.4 KB)

dhis.log (46.1 KB)

Hi Andrew,

I am not sure which version you are using now (2.5 or 2.6?) but you may want to try this directly on the database

ALTER TABLE chart ADD COLUMN targetline boolean NOT NULL DEFAULT false:

ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false;

Which is described here

https://bugs.launchpad.net/dhis2/+bug/914980

Regards,

Jason

···

On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr. meslehrobert3@gmail.com wrote:

Hi to all,

I have a problem where file I export cannot be imported to other systems (even back to my own system). Jason and Knut advised me to restore the 2.5 war file (because I was exporting from the 2.6 version). Now I get a message which I have attached along with the log file. Is there any advice for me? I can’t use the database.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Jason,

I was, at first, using the 2.6. I am getting the error after I downgraded to 2.5.

Thanks,

Robert

···

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Wednesday, January 25, 2012 2:53 PM
To: Robert G. Mesleh Jr.
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help

Hi Andrew,

I am not sure which version you are using now (2.5 or 2.6?) but you may want to try this directly on the database

ALTER TABLE chart ADD COLUMN targetline boolean NOT NULL DEFAULT false:

ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false;

Which is described here

https://bugs.launchpad.net/dhis2/+bug/914980

Regards,

Jason

On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr. meslehrobert3@gmail.com wrote:

Hi to all,

I have a problem where file I export cannot be imported to other systems (even back to my own system). Jason and Knut advised me to restore the 2.5 war file (because I was exporting from the 2.6 version). Now I get a message which I have attached along with the log file. Is there any advice for me? I can’t use the database.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6826 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Hi Jason and Knut

I figured out the problem with the exported file not being imported into other system is with the change of minorVersion to 1.3

After I edited the dxf file using Notepad to change the minorVersion back to 1.2 as shown below, it is now importing.

<?xml version="1.0"?>

Thanks,

Robert

···

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Wednesday, January 25, 2012 2:53 PM
To: Robert G. Mesleh Jr.
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help

Hi Andrew,

I am not sure which version you are using now (2.5 or 2.6?) but you may want to try this directly on the database

ALTER TABLE chart ADD COLUMN targetline boolean NOT NULL DEFAULT false:

ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false;

Which is described here

https://bugs.launchpad.net/dhis2/+bug/914980

Regards,

Jason

On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr. meslehrobert3@gmail.com wrote:

Hi to all,

I have a problem where file I export cannot be imported to other systems (even back to my own system). Jason and Knut advised me to restore the 2.5 war file (because I was exporting from the 2.6 version). Now I get a message which I have attached along with the log file. Is there any advice for me? I can’t use the database.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6833 (20120127) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Hi Robert,

Bob and I discussed this offline in detail (I was experiencing similar problems). A partial fix has been committed to trunk and we will test a better solution soon. In the meantime, your workaround should work fine.

Regards,

Jason

···

Sent from my mobile

On Feb 8, 2012 12:33 PM, “Robert G. Mesleh Jr.” meslehrobert3@gmail.com wrote:

Hi Jason and Knut

I figured out the problem with the exported file not being imported into other system is with the change of minorVersion to 1.3

After I edited the dxf file using Notepad to change the minorVersion back to 1.2 as shown below, it is now importing.

<?xml version="1.0"?>

Thanks,

Robert

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: Wednesday, January 25, 2012 2:53 PM
To: Robert G. Mesleh Jr.
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help

Hi Andrew,

I am not sure which version you are using now (2.5 or 2.6?) but you may want to try this directly on the database

ALTER TABLE chart ADD COLUMN targetline boolean NOT NULL DEFAULT false:

ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false;

Which is described here

https://bugs.launchpad.net/dhis2/+bug/914980

Regards,

Jason

On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr. meslehrobert3@gmail.com wrote:

Hi to all,

I have a problem where file I export cannot be imported to other systems (even back to my own system). Jason and Knut advised me to restore the 2.5 war file (because I was exporting from the 2.6 version). Now I get a message which I have attached along with the log file. Is there any advice for me? I can’t use the database.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6825 (20120125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 6833 (20120127) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com