DB2 Error with liferay 6.0.6

[Joel Gilchrist, geändert vor 12 Jahren.]

Hi,

I have installed the 6.0.6 tomcat bundle, created a db2 database manually using the minimal script, removed the 7cogs contexts from the webapps folder, created the appropriate JNDI resource for the LiferayPool, copied the db2 jar file. The system comes up fine but when I try to log in using the test account I get the following error

INFO: Server startup in 50536 ms
21:18:21,521 INFO [PluginPackageUtil:1230] Checking for available updates
21:18:21,521 INFO [PluginPackageUtil:1274] Finished checking for available updates in 0 ms
21:18:21,521 ERROR [JDBCExceptionReporter:101] DB2 SQL Error: SQLCODE=-130, SQLSTATE=22025, SQLERRMC=null, DRIVER=4.9.78
21:18:21,537 ERROR [velocity:151] Exception rendering #parse(_SERVLET_CONTEXT_/html/themes/_unstyled/templates/init.vm) at _SERVLET_CONTEXT_/html/themes/classic
/templates/portal_normal.vm[line 3, column 1]
21:18:21,552 ERROR [IncludeTag:231] Current URL / generates exception: Invocation of method 'hasMyPlaces' in class com.liferay.portal.model.impl.UserImpl threw
exception com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not
execute query at _SERVLET_CONTEXT_/html/themes/_unstyled/templates/init.vm[line 278, column 31]
21:18:21,552 ERROR [IncludeTag:154] com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-130, SQLSTATE=22025, SQLERRMC=null, DRIVER=4.9.78
at com.ibm.db2.jcc.am.fd.a(fd.java:668)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:127)
at com.ibm.db2.jcc.am.en.c(en.java:2553)
at com.ibm.db2.jcc.am.en.a(en.java:2044)
at com.ibm.db2.jcc.t4.cb.n(cb.java:802)
at com.ibm.db2.jcc.t4.cb.i(cb.java:259)
at com.ibm.db2.jcc.t4.cb.c(cb.java:54)
at com.ibm.db2.jcc.t4.q.c(q.java:44)
at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
at com.ibm.db2.jcc.am.en.kb(en.java:2039)
at com.ibm.db2.jcc.am.fn.b(fn.java:3850)
at com.ibm.db2.jcc.am.fn.dc(fn.java:697)
at com.ibm.db2.jcc.am.fn.executeQuery(fn.java:667)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)

Any suggestions?

[Boris Yurkevich, geändert vor 11 Jahren.]

I have same. Any luck?

10:58:30,009 [b]ERROR [IncludeTag:231][/b] Current URL /faq?p_p_auth=Hs2KP5YL&p_p_id=15&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&p_p_col_id=column-1&p_p_col_count=2&_15_struts_action=%2Fjournal%2Fedit_article&_15_redirect=http%3A%2F%2Fnew.interprocom.ru%2Ffaq%3Fp_p_id%3\
D56_INSTANCE_V21a%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn-1%26p_p_col_count%3D2&_15_referringPortletResource=56&_15_groupId=10157&_15_articleId=20268&_15_version=1.2 generates exception: File "/html/portlet/journal/edit_articl\
e.jsp" not found
10:58:30,010 ERROR [IncludeTag:154] javax.servlet.ServletException: File "/html/portlet/journal/edit_article.jsp" not found
        at org.apache.jasper.servlet.JspServlet.handleMissingResource(JspServlet.java:335)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:175)
        at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:223)
        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:58)
        at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:5369)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

[Zsolt Balogh, geändert vor 11 Jahren.]

Hi Boris,

This is the only exception you get in the logs? Please copy & paste the whole exception with all the causes as it usually helps to find the issue.

Zsolt

[László Csontos, geändert vor 11 Jahren.]

Boris Yurkevich:

I have same. Any luck?

10:58:30,009 [b]ERROR [IncludeTag:231][/b] Current URL /faq?p_p_auth=Hs2KP5YL&p_p_id=15&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&p_p_col_id=column-1&p_p_col_count=2&_15_struts_action=%2Fjournal%2Fedit_article&_15_redirect=http%3A%2F%2Fnew.interprocom.ru%2Ffaq%3Fp_p_id%3\
D56_INSTANCE_V21a%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn-1%26p_p_col_count%3D2&_15_referringPortletResource=56&_15_groupId=10157&_15_articleId=20268&_15_version=1.2 generates exception: File "/html/portlet/journal/edit_articl\
e.jsp" not found
10:58:30,010 ERROR [IncludeTag:154] javax.servlet.ServletException: File "/html/portlet/journal/edit_article.jsp" not found
        at org.apache.jasper.servlet.JspServlet.handleMissingResource(JspServlet.java:335)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:175)
        at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:223)
        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:58)
        at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:5369)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

Hi Boris,

It appears to be a known issue in Liferay 6.0.6, however the good news is that it has already been fixed in 6.1.0 (see LPS-19506 for more details).

I'd recommend using 6.1.0 or if you are sticking to 6.0.6 and you're determined to fix it anyway, I can give you the following GIT commit (which fixed the error) as a starting point.

LPS-19506 Usage of search method for all users on UserLocalServiceUtil with DB2 9.7 failed

With best regards,
Laszlo Csontos
Support Engineer