Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-9731

Upgrade to version 6.0.2 does not work

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.2 RC
    • Fix Version/s: 6.0.3 GA
    • Labels:
      None
    • Environment:
      liferay nightly liferay-portal-tomcat-2010-05-18.zip on centos5, openjdk6

      Description

      After upgrading the liferay codebase from 6.0.1-RC (liferay-portal-tomcat-6.0.1.zip) to nightly liferay-portal-tomcat-2010-05-18.zip it failes to upgrade with the following output in catalina.out:

      May 19, 2010 8:43:15 AM org.apache.catalina.core.AprLifecycleListener init
      INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386/client:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
      May 19, 2010 8:43:16 AM org.apache.coyote.http11.Http11Protocol init
      INFO: Initializing Coyote HTTP/1.1 on http-8080
      May 19, 2010 8:43:16 AM org.apache.catalina.startup.Catalina load
      INFO: Initialization processed in 839 ms
      May 19, 2010 8:43:16 AM org.apache.catalina.core.StandardService start
      INFO: Starting service Catalina
      May 19, 2010 8:43:16 AM org.apache.catalina.core.StandardEngine start
      INFO: Starting Servlet Engine: Apache Tomcat/6.0.26
      May 19, 2010 8:43:16 AM org.apache.catalina.startup.HostConfig deployDescriptor
      INFO: Deploying configuration descriptor ROOT.xml
      Loading jar:file:/opt/liferay-portal-6.0.2/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/opt/liferay-portal-6.0.2/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
      Loading file:/opt/liferay-portal-6.0.2/tomcat-6.0.26/webapps/ROOT/WEB-INF/classes/portal-ext.properties
      08:43:22,471 INFO [DialectDetector:70] Determining dialect for Oracle 10
      08:43:22,536 INFO [DialectDetector:50] Using dialect org.hibernate.dialect.Oracle10gDialect
      08:43:26,314 INFO [PortalImpl:265] Global lib directory /opt/liferay-portal-6.0.2/tomcat-6.0.26/lib/ext/
      08:43:26,317 INFO [PortalImpl:285] Portal lib directory /opt/liferay-portal-6.0.2/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/
      Starting Liferay Portal Community Edition 6.0.2 CE (Bunyan / Build 6002 / May 1, 2010)
      08:43:42,949 INFO [BaseDB:392] Database supports case sensitive queries
      08:43:42,958 INFO [UpgradeProcess:110] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_2
      08:43:42,959 INFO [UpgradeProcess:110] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeSchema
      08:43:43,371 WARN [BaseDB:368] ORA-00933: SQL command not properly ended: update ExpandoTable set name = 'CUSTOM_FIELDS' where name = 'DEFAULT_TABLE'COMMIT_TRANSACTION;
      08:43:43,576 WARN [BaseDB:368] ORA-00904: "MINSYMBOLS": invalid identifier: update PasswordPolicy set minSymbols = 0;
      08:43:43,913 INFO [UpgradeProcess:110] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeNestedPortlets
      08:43:44,622 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyProcessSuite
      08:43:44,624 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyProperties
      08:43:44,624 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyLucene
      08:43:44,625 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyMySQL
      08:43:44,625 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyCounter
      08:43:44,700 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyUUID
      08:43:44,785 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyRole
      08:43:44,935 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyBlogs
      08:43:44,978 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyBookmarks
      08:43:44,999 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyCalendar
      08:43:45,014 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
      08:43:45,048 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyGroup
      08:43:45,106 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyImageGallery
      08:43:45,113 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyJournal
      08:43:45,339 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyLayout
      08:43:45,348 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyMessageBoards
      08:43:45,651 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyOrganization
      08:43:45,682 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifySocial
      08:43:45,683 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyUser
      08:43:45,741 INFO [VerifyProcess:79] Verifying com.liferay.portal.verify.VerifyWiki
      08:43:46,073 INFO [BaseDB:436] Adding indexes
      08:43:46,074 INFO [BaseDB:461] create index IX_7A040C32 on MBMessage (userId);
      08:43:46,118 INFO [BaseDB:461] create unique index IX_22F6B5CB on SocialEquityAssetEntry (assetEntryId);
      08:43:46,123 INFO [BaseDB:461] create index IX_E8DA181D on SocialEquityLog (assetEntryId, type_, active_);
      08:43:46,128 INFO [BaseDB:461] create index IX_60CD2F21 on SocialEquityLog (userId, assetEntryId, actionId, active_);
      08:43:46,133 INFO [BaseDB:461] create index IX_5E81DA6F on SocialEquitySetting (classNameId, actionId);
      08:43:46,138 INFO [BaseDB:461] create unique index IX_6ECBD5D on SocialEquityUser (userId);
      08:43:46,143 INFO [BaseDB:461] create index IX_B2468446 on Ticket (key_);
      08:43:46,147 INFO [BaseDB:461] create index IX_9F7655DA on WikiPage (nodeId, head, parentTitle, status);
      08:43:46,163 INFO [BaseDB:461] create index IX_432F0AB0 on WikiPage (nodeId, head, status);
      08:43:46,176 INFO [BaseDB:461] create index IX_546F2D5C on WikiPage (nodeId, status);
      08:43:46,181 INFO [BaseDB:461] create index IX_FBBE7C96 on WikiPage (userId, nodeId, status);
      08:43:50,782 INFO [HotDeployUtil:60] Initializing hot deploy manager 2091881
      08:43:50,784 INFO [ServerDetector:87] Detected server tomcat
      08:43:50,860 INFO [AutoDeployDir:106] Auto deploy scanner started for /opt/liferay-portal-6.0.2/deploy
      08:43:51,076 INFO [PluginPackageUtil:1112] Reloading repositories
      08:43:51,896 ERROR [JDBCExceptionReporter:101] ORA-00904: "PASSWORDPO0_"."MINSYMBOLS": invalid identifier

      08:43:51,901 ERROR [PortalInstances:356] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:176)
      at com.liferay.portal.service.persistence.PasswordPolicyPersistenceImpl.fetchByC_N(PasswordPolicyPersistenceImpl.java:660)
      at com.liferay.portal.service.persistence.PasswordPolicyPersistenceImpl.fetchByC_N(PasswordPolicyPersistenceImpl.java:584)
      at com.liferay.portal.service.impl.PasswordPolicyLocalServiceImpl.checkDefaultPasswordPolicy(PasswordPolicyLocalServiceImpl.java:122)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy41.checkDefaultPasswordPolicy(Unknown Source)
      at com.liferay.portal.service.impl.CompanyLocalServiceImpl.checkCompany(CompanyLocalServiceImpl.java:283)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy14.checkCompany(Unknown Source)
      at com.liferay.portal.service.impl.CompanyLocalServiceImpl.checkCompany(CompanyLocalServiceImpl.java:110)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy14.checkCompany(Unknown Source)
      at com.liferay.portal.service.CompanyLocalServiceUtil.checkCompany(CompanyLocalServiceUtil.java:132)
      at com.liferay.portal.util.PortalInstances._initCompany(PortalInstances.java:351)
      at com.liferay.portal.util.PortalInstances.initCompany(PortalInstances.java:90)
      at com.liferay.portal.servlet.MainServlet.initCompanies(MainServlet.java:922)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:463)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:519)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:32)
      at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:80)
      at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:65)
      at com.liferay.portal.service.persistence.PasswordPolicyPersistenceImpl.fetchByC_N(PasswordPolicyPersistenceImpl.java:634)
      ... 75 more
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.loader.Loader.doList(Loader.java:2297)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
      at org.hibernate.loader.Loader.list(Loader.java:2167)
      at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:936)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:70)
      ... 77 more
      Caused by: java.sql.SQLException: ORA-00904: "PASSWORDPO0_"."MINSYMBOLS": invalid identifier

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      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(Loader.java:270)
      at org.hibernate.loader.Loader.doList(Loader.java:2294)
      ... 84 more
      08:43:51,952 INFO [LuceneServlet:61] Indexing Lucene on startup
      May 19, 2010 8:43:51 AM org.apache.catalina.startup.HostConfig deployDirectory
      INFO: Deploying web application directory tunnel-web
      May 19, 2010 8:43:54 AM org.apache.coyote.http11.Http11Protocol start
      INFO: Starting Coyote HTTP/1.1 on http-8080
      May 19, 2010 8:43:54 AM org.apache.jk.common.ChannelSocket init
      INFO: JK: ajp13 listening on /0.0.0.0:8009
      May 19, 2010 8:43:54 AM org.apache.jk.server.JkMain start
      INFO: Jk running ID=0 time=0/63 config=null
      May 19, 2010 8:43:54 AM org.apache.catalina.startup.Catalina start
      INFO: Server startup in 38374 ms
      08:45:37,234 ERROR [JDBCExceptionReporter:101] ORA-01791: not a SELECTed expression

      08:45:37,240 ERROR [IncludeTag:229] Current URL / generates exception: An exception occurred processing JSP page /html/portlet/journal/article_search_results.jspf at line 35

      32: results = JournalArticleLocalServiceUtil.search(company.getCompanyId(), searchTerms.getGroupId(), searchTerms.getArticleId(), searchTerms.getVersionObj(), searchTerms.getTitle(), searchTerms.getDescription(), searchTerms.getContent(), searchTerms.getType(), searchTerms.getStructureId(), searchTerms.getTemplateId(), searchTerms.getDisplayDateGT(), searchTerms.getDisplayDateLT(), searchTerms.getStatusCode(), searchTerms.getReviewDate(), searchTerms.isAndOperator(), searchContainer.getStart(), searchContainer.getEnd(), searchContainer.getOrderByComparator());
      33: }
      34: else

      { 35: results = JournalArticleLocalServiceUtil.search(company.getCompanyId(), searchTerms.getGroupId(), searchTerms.getKeywords(), searchTerms.getVersionObj(), null, searchTerms.getStructureId(), searchTerms.getTemplateId(), searchTerms.getDisplayDateGT(), searchTerms.getDisplayDateLT(), searchTerms.getStatusCode(), searchTerms.getReviewDate(), searchContainer.getStart(), searchContainer.getEnd(), searchContainer.getOrderByComparator()); 36: }

      37:
      38: searchContainer.setResults(results);

      Stacktrace:
      08:45:37,245 ERROR [IncludeTag:157] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portlet.journal.service.persistence.JournalArticleFinderImpl.findByC_G_A_V_T_D_C_T_S_T_D_S_R(JournalArticleFinderImpl.java:565)
      at com.liferay.portlet.journal.service.persistence.JournalArticleFinderImpl.findByKeywords(JournalArticleFinderImpl.java:312)
      at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.search(JournalArticleLocalServiceImpl.java:1435)
      at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.search(JournalArticleLocalServiceUtil.java:682)
      at org.apache.jsp.html.portlet.journal_005farticles.view_jsp._jspService(view_jsp.java:979)
      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)
      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:177)
      at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:221)
      at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:60)
      at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:3042)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:32)
      at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:98)
      at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:82)
      at com.liferay.portlet.journal.service.persistence.JournalArticleFinderImpl.findByC_G_A_V_T_D_C_T_S_T_D_S_R(JournalArticleFinderImpl.java:539)
      at com.liferay.portlet.journal.service.persistence.JournalArticleFinderImpl.findByKeywords(JournalArticleFinderImpl.java:312)
      at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.search(JournalArticleLocalServiceImpl.java:1435)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy163.search(Unknown Source)
      at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.search(JournalArticleLocalServiceUtil.java:682)
      at org.apache.jsp.html.portlet.journal_005farticles.view_jsp._jspService(view_jsp.java:979)
      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)
      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:177)
      at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:221)
      at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:60)
      at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:3042)
      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)
      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.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:318)
      at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:122)
      at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:274)
      at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:245)
      at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
      at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:302)
      at com.liferay.portal.struts.PortletRequestProcessor.processForwardConfig(PortletRequestProcessor.java:347)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
      at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:225)
      at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:252)
      at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:147)
      at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:203)
      at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
      at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:103)
      at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:66)
      at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:639)
      at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:708)
      at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:421)
      at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1541)
      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)
      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.portal.util.PortalImpl.renderPortlet(PortalImpl.java:3465)
      at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1101)
      at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:161)
      at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:95)
      at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:254)
      at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:182)
      at org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(portlet_jsp.java:826)
      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)
      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.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:338)
      at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:595)
      at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:217)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:154)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:638)
      at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:615)
      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 com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:303)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:139)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:254)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      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.processRequest(ApplicationDispatcher.java:436)
      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
      at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:134)
      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 com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:47)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:248)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:128)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:223)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:387)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:254)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      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.processRequest(ApplicationDispatcher.java:436)
      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
      at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:314)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:109)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:179)
      at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:37)
      at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:106)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
      at java.lang.Thread.run(Thread.java:636)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.loader.Loader.doList(Loader.java:2297)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
      at org.hibernate.loader.Loader.list(Loader.java:2167)
      at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
      at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)
      at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
      at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
      at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:88)
      ... 236 more
      Caused by: java.sql.SQLException: ORA-01791: not a SELECTed expression

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      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(Loader.java:270)
      at org.hibernate.loader.Loader.doList(Loader.java:2294)
      ... 243 more

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 30 weeks, 1 day ago

                Packages

                Version Package
                6.0.3 GA