Public bug reported: The DHIS2 software 2.7 web interface not working on 32 bit platform - tested on Ubuntu (10.10,11.04) 32 bit.
I installed postgresql 9.1.3 and tomcat 7.0.26 on a 32 bit Ubuntu (10.10, 11.04) and used the dump (pgdump) from a postgresql 9.1.3 (with tomcat 7.0.26) ubuntu (11.10) 64 bit but the DHIS2 web interface fails after logging in. The dump reports no errors but when you login to the web interface, you get this: "An exception occurred Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page. If you wish to report the incident, please save this page by choosing "File -> Save (page as)" in your browser and include the saved page in the report. The problem details are listed below. [+] Exception (org.hibernate.exception.SQLGrammarException): ERROR: operator does not exist: boolean = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 342 [+] Caused by (org.postgresql.util.PSQLException): ERROR: operator does not exist: boolean = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 342 " ** 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/973208 Title: The DHIS2 software 2.7 web interface not working on 32 bit platform - tested on Ubuntu (10.10,11.04) 32 bit Status in DHIS 2 - District Health Information Software: New Bug description: The DHIS2 software 2.7 web interface not working on 32 bit platform - tested on Ubuntu (10.10,11.04) 32 bit. I installed postgresql 9.1.3 and tomcat 7.0.26 on a 32 bit Ubuntu (10.10, 11.04) and used the dump (pgdump) from a postgresql 9.1.3 (with tomcat 7.0.26) ubuntu (11.10) 64 bit but the DHIS2 web interface fails after logging in. The dump reports no errors but when you login to the web interface, you get this: "An exception occurred Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page. If you wish to report the incident, please save this page by choosing "File -> Save (page as)" in your browser and include the saved page in the report. The problem details are listed below. [+] Exception (org.hibernate.exception.SQLGrammarException): ERROR: operator does not exist: boolean = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 342 [+] Caused by (org.postgresql.util.PSQLException): ERROR: operator does not exist: boolean = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 342 " To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/973208/+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