5.2.4 EE on Websphere 6.1.0.21 - Control Panel Error

[Kevin Boger, modifié il y a 14 années.]

I recently installed 5.2.4 EE version on our staging server of WAS 6.1.0.21... using DB2... When I access the control panel, all of the links in the CONTENT tab... throw the following error in Liferay... All of the other tabs are working fine... (I'm pointing 5.2.4 EE to the same DB2 database that was created from a previous install of 5.2.2)

[6/11/09 11:33:14:164 EDT] 0000002f ServletWrappe I SRVE0242I: [liferay-portal-5_2_4_war] [/] [/html/portlet/wiki/css.jsp]: Initialization successful.
[6/11/09 11:33:29:055 EDT] 00000037 SystemOut O 11:33:29,039 ERROR [JDBCExceptionReporter:101] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ( select * from ( select rownumber() over();BEGIN-OF-STATEMENT;<from>
[6/11/09 11:33:29:055 EDT] 00000037 SystemOut O 11:33:29,055 ERROR [JDBCExceptionReporter:101] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-104;42601;( select * from ( select rownumber() over()|BEGIN-OF-STA
[6/11/09 11:33:29:055 EDT] 00000037 SystemOut O 11:33:29,055 ERROR [JDBCExceptionReporter:101] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-104;42601;( select * from ( select rownumber() over()|BEGIN-OF-STA
[6/11/09 11:33:29:055 EDT] 00000037 ServletWrappe E SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: /html/portal/layout/view/control_panel.jsp. Exception thrown : javax.servlet.ServletException: com.liferay.portal.kernel.dao.orm.ORMException: could not execute query
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:660)


When I queried the db2 SQLCODE -104, SQLSTATE 42601 i get: Class Code 42: Syntax Error or Access Rule Violation
- A character, token, or clause is invalid or missing.

But I'm not sure how to fix this problem...

thx in advance...

[Kevin Boger, modifié il y a 14 années.]

Problem Solved here:


http://issues.liferay.com/browse/LPS-1214