Can't see data after upgrade to 2.13

Dear Knut,

I already change the server to windows but every time I start the tomcat the dhis crash. Please find the attached log files.

Please can someone or anyone help me with this situation.

Please!!!

catalina.2014-01-22.log (12.7 KB)

catalina.2014-01-23.log (8.05 KB)

localhost.2014-01-22.log (48.3 KB)

host-manager.2014-01-23.log (0 Bytes)

host-manager.2014-01-22.log (0 Bytes)

localhost.2014-01-23.log (32.4 KB)

localhost_access_log.2014-01-22.txt (290 Bytes)

localhost_access_log.2014-01-23.txt (146 Bytes)

manager.2014-01-22.log (0 Bytes)

manager.2014-01-23.log (0 Bytes)

···

On Thu, Jan 16, 2014 at 6:48 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Knut,

I already unzip the file the actual size was 1.3GB and I successfully done the installation but when I go to data entry I can’t see the organization units. Before this I already tested the database on a windows machine and it is working fine.

What might be the issue(s) now??

Sent from Windows Mail

From: Knut Staring

Sent: ‎Thursday‎, ‎January‎ ‎16‎, ‎2014 ‎7‎:‎06‎ ‎AM
To: Morten Olav Hansen
Cc: Gerald Thomas, dhis2-devs@lists.launchpad.net

Also, if you are on Windows, you can use something like PeaZip to unzip:
http://peazip.sourceforge.net/


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Jan 16, 2014 at 8:01 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

You can unzip the file with gunzip dhis2.sql.gz, and then import with psql -U -f


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

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Morten

On Thu, Jan 16, 2014 at 1:39 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear when I run the backup the server came with a file which dhis2.sql.gz but I can’t import this database into another postgresql to see if this file was ok. Please is there any way I can extract the file to have the dhis2.sql

Please I need help

Sent from Windows Mail

To: Gerald Thomas
Cc: jason.p.pickering@gmail.com, dhis2-devs@lists.launchpad.net

From: Dan Cocos

Sent: ‎Wednesday‎, ‎January‎ ‎15‎, ‎2014 ‎7‎:‎59‎ ‎PM

Hi Gerald,

If you want to completely remove postgres did you try

apt-get --purge remove postgresql

This should remove it and everything related to it.

Dan


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 Wed, Jan 15, 2014 at 2:26 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Jason,

This is currently one of my worst day using the dhis. I tried everything I could be nothing works. I already backup the postregsql database but the size of the file is too small, approximately 161MB. Secondly, I am trying to uninstall the postregsql on the ubnutu and then install another postregsql and finally import the database that I had exported.

But my biggest problem is to uninstall the postregsql???

when I running this command “sudo apt-get remove postregsql*” the process run but it does not completely uninstall the postregsql and I don’t know what to do now.

Please to the forum:

How can I completely uninstall postregsql???

Since this is a regional server is it possible, that the size of the database is ok???

Will my steps finally solve this issue???

Sent from Windows Mail

To: Gerald Thomas

Cc: Morten Olav Hansen, Olav Poppe, dhis2-devs@lists.launchpad.net

From: jason.p.pickering@gmail.com

Sent: ‎Wednesday‎, ‎January‎ ‎15‎, ‎2014 ‎3‎:‎28‎ ‎PM

Hi Gerald,
In general, a downgrade is tricky. You would need to really restore to 2.12 from a backup copy. In this case, I do not think it would really be necessary, since 2.13 should work. Are you certain this is not a browser caching issue? Did you try and confirm that no data is appearing in incognito mode of your browser or by completely clearing the browser cache? Are the analytics tables present in the database?

Regards,

Jason


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 Wed, Jan 15, 2014 at 3:41 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Please any help??? I just want to finish with this issue. Please can anyone help me.

Sent from Windows Mail

From: Gerald Thomas

Sent: Tuesday, January 14, 2014 9:36 PM
To: Morten Olav Hansen, Olav Poppe
Cc: dhis2-devs@lists.launchpad.net

Hi all,

I remotely access the sever and I found that the analytics table update was completed successfully. But there is still no data and I can’t access the “data entry”.

Please can I take it back to version 2.12 and see if work on that version rather than 2.13???

If that process didn’t work; can I backup the database and uninstall and install postregsql again??

Finally, sorry about it but if I extract the database from the command line on Ubuntu where can I find the database???

Sent from Windows Mail

From: Morten Olav Hansen

Sent: Tuesday, January 14, 2014 9:13 PM
To: Olav Poppe
Cc: Gerald Thomas, dhis2-devs@lists.launchpad.net

Hi,

As Olav says, you might need to run the analytics table update. You can do this in:

/dhis-web-reporting/displayDataMartForm.action

This will move all the required datavalues over to the analytics table (which is used for reporting). This usually happens late at night automatically, but if you server is down, it will not be run.


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


Morten

On Tue, Jan 14, 2014 at 5:54 PM, Olav Poppe olav.poppe@me.com wrote:

Hi, have you run the analytics update?

Den 14. jan. 2014 kl. 17:27 skrev Gerald Thomas gerald.81@hotmail.com:

Dear All,

One of my regional server which was running on version 2.10 keeps saying “waiting for localhost” forever on the firefox browser. As a means of maintenance, uninstall and install apache tomcat again without touching the postregsql but I opted for version 2.13 war file. After the installation, I login with the previous admin password but I can’t find any data when running report.

Please can someone help me because I know those information are within the database because my previous users profiles was still there.

Please it is urgent!!!

Sent from Windows Mail


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

Try to create a user and assign that user appropriate privilege/role and facility.

Lungo

Dear Knut,

I already change the server to windows but every time I start the tomcat the dhis crash. Please find the attached log files.

Please can someone or anyone help me with this situation.

Please!!!

···

On Thursday, January 23, 2014 2:26 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Sent from Windows Mail

From: Gerald Thomas
Sent: ‎Tuesday‎, ‎January‎ ‎21‎, ‎2014 ‎1‎:‎58‎ ‎AM
To: Knut Staring
Cc: dhis2-devs@lists.launchpad.net

Dear Knut,

Please I having so many issues which this server and I had tried everything I think I could but to no avail. I had upgrade it to 2.14 but when I did, not all the districts and facilities appears. Only Bo and it facilities are showing. Still I can’t see the data? I am thinking of converting this server into windows.

Sent from Windows Mail

From: Knut Staring
Sent: ‎Thursday‎, ‎January‎ ‎16‎, ‎2014 ‎6‎:‎05‎ ‎PM
To: Gerald Thomas
Cc: Morten Olav Hansen, dhis2-devs@lists.launchpad.net

Hi Gerald,

This does sound like a browser caching issue. If you are using Chrome, you could try clicking on Ctrl+Shift+Delete at the same time and then erase cookies and cache “since the beginning of time”. Or even easier, try Ctrl+Shift+N to open an incognito window, and see if that helps (you will have to log in again).

Knut

On Thu, Jan 16, 2014 at 6:48 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Knut,

I already unzip the file the actual size was 1.3GB and I successfully done the installation but when I go to data entry I can’t see the organization units. Before this I already tested the database on a windows machine and it is working fine.

What might be the issue(s) now??

Sent from Windows Mail

From: Knut Staring

Sent: ‎Thursday‎, ‎January‎ ‎16‎, ‎2014 ‎7‎:‎06‎ ‎AM
To: Morten Olav Hansen
Cc: Gerald Thomas, dhis2-devs@lists.launchpad.net

Also, if you are on Windows, you can use something like PeaZip to unzip:
http://peazip.sourceforge.net/

On Thu, Jan 16, 2014 at 8:01 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

You can unzip the file with gunzip dhis2.sql.gz, and then import with psql -U -f


Morten

On Thu, Jan 16, 2014 at 1:39 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear when I run the backup the server came with a file which dhis2.sql.gz but I can’t import this database into another postgresql to see if this file was ok. Please is there any way I can extract the file to have the dhis2.sql

Please I need help

Sent from Windows Mail

From: Dan Cocos

Sent: ‎Wednesday‎, ‎January‎ ‎15‎, ‎2014 ‎7‎:‎59‎ ‎PM

To: Gerald Thomas
Cc: jason.p.pickering@gmail.com, dhis2-devs@lists.launchpad.net

Hi Gerald,

If you want to completely remove postgres did you try

apt-get --purge remove postgresql

This should remove it and everything related to it.

Dan

On Wed, Jan 15, 2014 at 2:26 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Jason,

This is currently one of my worst day using the dhis. I tried everything I could be nothing works. I already backup the postregsql database but the size of the file is too small, approximately 161MB. Secondly, I am trying to uninstall the postregsql on the ubnutu and then install another postregsql and finally import the database that I had exported.

But my biggest problem is to uninstall the postregsql???

when I running this command “sudo apt-get remove postregsql*” the process run but it does not completely uninstall the postregsql and I don’t know what to do now.

Please to the forum:

How can I completely uninstall postregsql???

Since this is a regional server is it possible, that the size of the database is ok???

Will my steps finally solve this issue???

Sent from Windows Mail

From: jason.p.pickering@gmail.com

Sent: ‎Wednesday‎, ‎January‎ ‎15‎, ‎2014 ‎3‎:‎28‎ ‎PM

To: Gerald Thomas

Cc: Morten Olav Hansen, Olav Poppe, dhis2-devs@lists.launchpad.net

Hi Gerald,
In general, a downgrade is tricky. You would need to really restore to 2.12 from a backup copy. In this case, I do not think it would really be necessary, since 2.13 should work. Are you certain this is not a browser caching issue? Did you try and confirm that no data is appearing in incognito mode of your browser or by completely clearing the browser cache? Are the analytics tables present in the database?

Regards,

Jason

On Wed, Jan 15, 2014 at 3:41 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Please any help??? I just want to finish with this issue. Please can anyone help me.

Sent from Windows Mail

From: Gerald Thomas

Sent: Tuesday, January 14, 2014 9:36 PM
To: Morten Olav Hansen, Olav Poppe
Cc: dhis2-devs@lists.launchpad.net

Hi all,

I remotely access the sever and I found that the analytics table update was completed successfully. But there is still no data and I can’t access the “data entry”.

Please can I take it back to version 2.12 and see if work on that version rather than 2.13???

If that process didn’t work; can I backup the database and uninstall and install postregsql again??

Finally, sorry about it but if I extract the database from the command line on Ubuntu where can I find the database???

Sent from Windows Mail

From: Morten Olav Hansen

Sent: Tuesday, January 14, 2014 9:13 PM
To: Olav Poppe
Cc: Gerald Thomas, dhis2-devs@lists.launchpad.net

Hi,

As Olav says, you might need to run the analytics table update. You can do this in:

/dhis-web-reporting/displayDataMartForm.action

This will move all the required datavalues over to the analytics table (which is used for reporting). This usually happens late at night automatically, but if you server is down, it will not be run.


Morten

On Tue, Jan 14, 2014 at 5:54 PM, Olav Poppe olav.poppe@me.com wrote:

Hi, have you run the analytics update?

Den 14. jan. 2014 kl. 17:27 skrev Gerald Thomas gerald.81@hotmail.com:

Dear All,

One of my regional server which was running on version 2.10 keeps saying “waiting for localhost” forever on the firefox browser. As a means of maintenance, uninstall and install apache tomcat again without touching the postregsql but I opted for version 2.13 war file. After the installation, I login with the previous admin password but I can’t find any data when running report.

Please can someone help me because I know those information are within the database because my previous users profiles was still there.

Please it is urgent!!!

Sent from Windows Mail


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


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


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


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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