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

DLFileEntryLocalServiceUtil#getExtraSettingsFileEntries API doesn't work on Oracle DB

    Details

      Description

      Description
      The DLFileEntryLocalServiceUtil#getExtraSettingsFileEntries API calls a Finder method that runs a custom SQL query to find all the file entries and file versions that have a non-null, non-empty extraSettings. However, this custom SQL query fails on Oracle databases.

      Steps to Reproduce
      1. Start up Liferay connected to an Oracle DB and log in as the admin user.
      2. Navigate to Control Panel > Server Administration > Script.
      3. Verify that the Language is set to Groovy, and paste the following into the Script box:

      import com.liferay.document.library.kernel.service.DLFileEntryLocalServiceUtil;
      
      try {
          DLFileEntryLocalServiceUtil.getExtraSettingsFileEntries(0, 1);
      }
      catch (Exception e) {
          e.printStackTrace();
      }
      

      Expected Result: The script completes successfully and there are no errors in the logs.
      Actual Result: The following error appears in the logs upon running the script:

      2021-08-09 23:03:05.803 ERROR [http-nio-8080-exec-9][JDBCExceptionReporter:234] ORA-00932: inconsistent datatypes: expected - got CLOB_ [Sanitized]
      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.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.findByExtraSettings(DLFileEntryFinderImpl.java:386)
              at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getExtraSettingsFileEntries(DLFileEntryLocalServiceImpl.java:1093)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
              at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
              at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
              at com.sun.proxy.$Proxy87.getExtraSettingsFileEntries(Unknown Source)
              at com.liferay.document.library.kernel.service.DLFileEntryLocalServiceUtil.getExtraSettingsFileEntries(DLFileEntryLocalServiceUtil.java:618)
              at com.liferay.document.library.kernel.service.DLFileEntryLocalServiceUtil$getExtraSettingsFileEntries.call(Unknown Source)
              at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
              at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
              at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
              at Script1.run(Script1.groovy:4)
              at com.liferay.portal.scripting.groovy.internal.GroovyExecutor.eval(GroovyExecutor.java:64)
              at com.liferay.portal.scripting.internal.ScriptingImpl.eval(ScriptingImpl.java:87)
              at com.liferay.portal.scripting.internal.ScriptingImpl.exec(ScriptingImpl.java:108)
              at com.liferay.server.admin.web.internal.portlet.action.EditServerMVCActionCommand.runScript(EditServerMVCActionCommand.java:525)
              at com.liferay.server.admin.web.internal.portlet.action.EditServerMVCActionCommand.doProcessAction(EditServerMVCActionCommand.java:209)
              at com.liferay.portal.kernel.portlet.bridges.mvc.BaseMVCActionCommand.processAction(BaseMVCActionCommand.java:57)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.callActionMethod(MVCPortlet.java:357)
              at com.liferay.portal.kernel.portlet.LiferayPortlet.processAction(LiferayPortlet.java:88)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.processAction(MVCPortlet.java:247)
              at com.liferay.portlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:77)
              at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:50)
              at com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:115)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
              at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)
              at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:63)
              at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:120)
              at org.eclipse.equinox.http.servlet.internal.servlet.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:48)
              at com.liferay.portlet.internal.InvokerPortletImpl.invoke(InvokerPortletImpl.java:569)
              at com.liferay.portlet.internal.InvokerPortletImpl.invokeAction(InvokerPortletImpl.java:609)
              at com.liferay.portlet.internal.InvokerPortletImpl.processAction(InvokerPortletImpl.java:286)
              at com.liferay.portal.monitoring.internal.portlet.MonitoringInvokerPortlet.processAction(MonitoringInvokerPortlet.java:195)
              at com.liferay.portlet.internal.PortletContainerImpl._processAction(PortletContainerImpl.java:517)
              at com.liferay.portlet.internal.PortletContainerImpl.lambda$processAction$0(PortletContainerImpl.java:148)
              at com.liferay.portlet.internal.PortletContainerImpl._preserveGroupIds(PortletContainerImpl.java:421)
              at com.liferay.portlet.internal.PortletContainerImpl.processAction(PortletContainerImpl.java:141)
              at com.liferay.portlet.SecurityPortletContainerWrapper.processAction(SecurityPortletContainerWrapper.java:92)
              at com.liferay.portlet.RestrictPortletContainerWrapper.processAction(RestrictPortletContainerWrapper.java:72)
              at com.liferay.portal.kernel.portlet.PortletContainerUtil.processAction(PortletContainerUtil.java:117)
              at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:368)
              at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:174)
              at com.liferay.portal.struts.PortalRequestProcessor._process(PortalRequestProcessor.java:401)
              at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:151)
              at com.liferay.portal.internal.servlet.MainServlet.doPost(MainServlet.java:213)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
              at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:632)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
              at com.liferay.shielded.container.internal.proxy.ServletWrapper.service(ServletWrapper.java:113)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.upload.servlet.request.filter.internal.UploadServletRequestFilter.processFilter(UploadServletRequestFilter.java:120)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.remote.cors.internal.servlet.filter.PortalCORSServletFilter.processFilter(PortalCORSServletFilter.java:237)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.servlet.filters.lockout.LockoutFilter.processFilter(LockoutFilter.java:58)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:339)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:183)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104)
              at com.liferay.shielded.container.internal.proxy.FilterWrapper.doFilter(FilterWrapper.java:79)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:710)
              at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
              at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
              at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
              at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:455)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
              at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:99)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
              at com.liferay.shielded.container.internal.proxy.ServletWrapper.service(ServletWrapper.java:113)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.upload.servlet.request.filter.internal.UploadServletRequestFilter.processFilter(UploadServletRequestFilter.java:120)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.remote.cors.internal.servlet.filter.PortalCORSServletFilter.processFilter(PortalCORSServletFilter.java:237)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:368)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.servlet.filters.lockout.LockoutFilter.processFilter(LockoutFilter.java:58)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:339)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:87)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:265)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:245)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147)
              at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:183)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99)
              at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
              at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
              at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
              at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
              at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104)
              at com.liferay.shielded.container.internal.proxy.FilterWrapper.doFilter(FilterWrapper.java:79)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
              at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)
              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)
              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:748)
      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:39)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:188)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168)
              at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84)
              at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53)
              at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.findByExtraSettings(DLFileEntryFinderImpl.java:382)
              ... 195 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:2545)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
              at org.hibernate.loader.Loader.list(Loader.java:2271)
              at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
              at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
              at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
              at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176)
              ... 199 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
      
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
              at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
              at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
              at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
              at org.hibernate.loader.Loader.doQuery(Loader.java:802)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2542)
              ... 206 more
      Caused by: Error : 932, Position : 925, Sql = SELECT * FROM (SELECT DISTINCT DLFileEntry.fileEntryId AS fileEntr1_73_0_, DLFileEntry.mvccVersion AS mvccVers2_73_0_, DLFileEntry.ctCollectionId AS ctCollec3_73_0_, DLFileEntry.uuid_ AS uuid4_73_0_, DLFileEntry.externalReferenceCode AS external5_73_0_, DLFileEntry.groupId AS groupId73_0_, DLFileEntry.companyId AS companyId73_0_, DLFileEntry.userId AS userId73_0_, DLFileEntry.userName AS userName73_0_, DLFileEntry.createDate AS createDate73_0_, DLFileEntry.modifiedDate AS modifie11_73_0_, DLFileEntry.classNameId AS classNa12_73_0_, DLFileEntry.classPK AS classPK73_0_, DLFileEntry.repositoryId AS reposit14_73_0_, DLFileEntry.folderId AS folderId73_0_, DLFileEntry.treePath AS treePath73_0_, DLFileEntry.name AS name73_0_, DLFileEntry.fileName AS fileName73_0_, DLFileEntry.extension AS extension73_0_, DLFileEntry.mimeType AS mimeType73_0_, DLFileEntry.title AS title73_0_, DLFileEntry.description AS descrip22_73_0_, DLFileEntry.extraSettings AS extraSe23_73_0_, DLFileEntry.fileEntryTypeId AS fileEnt24_73_0_, DLFileEntry.version AS version73_0_, DLFileEntry.size_ AS size26_73_0_, DLFileEntry.smallImageId AS smallIm27_73_0_, DLFileEntry.largeImageId AS largeIm28_73_0_, DLFileEntry.custom1ImageId AS custom29_73_0_, DLFileEntry.custom2ImageId AS custom30_73_0_, DLFileEntry.manualCheckInRequired AS manualC31_73_0_, DLFileEntry.expirationDate AS expirat32_73_0_, DLFileEntry.reviewDate AS reviewDate73_0_, DLFileEntry.lastPublishDate AS lastPub34_73_0_ FROM DLFileEntry INNER JOIN DLFileVersion ON DLFileVersion.fileEntryId = DLFileEntry.fileEntryId WHERE (CAST(DLFileEntry.extraSettings AS VARCHAR (4000)) IS NOT NULL) OR (CAST(DLFileVersion.extraSettings AS VARCHAR (4000)) IS NOT NULL) AND DLFileEntry.ctCollectionId = 0 AND DLFileVersion.ctCollectionId = 0 ORDER BY DLFileEntry.modifiedDate DESC) WHERE rownum <= :1 , OriginalSql = SELECT * FROM (SELECT DISTINCT DLFileEntry.fileEntryId AS fileEntr1_73_0_, DLFileEntry.mvccVersion AS mvccVers2_73_0_, DLFileEntry.ctCollectionId AS ctCollec3_73_0_, DLFileEntry.uuid_ AS uuid4_73_0_, DLFileEntry.externalReferenceCode AS external5_73_0_, DLFileEntry.groupId AS groupId73_0_, DLFileEntry.companyId AS companyId73_0_, DLFileEntry.userId AS userId73_0_, DLFileEntry.userName AS userName73_0_, DLFileEntry.createDate AS createDate73_0_, DLFileEntry.modifiedDate AS modifie11_73_0_, DLFileEntry.classNameId AS classNa12_73_0_, DLFileEntry.classPK AS classPK73_0_, DLFileEntry.repositoryId AS reposit14_73_0_, DLFileEntry.folderId AS folderId73_0_, DLFileEntry.treePath AS treePath73_0_, DLFileEntry.name AS name73_0_, DLFileEntry.fileName AS fileName73_0_, DLFileEntry.extension AS extension73_0_, DLFileEntry.mimeType AS mimeType73_0_, DLFileEntry.title AS title73_0_, DLFileEntry.description AS descrip22_73_0_, DLFileEntry.extraSettings AS extraSe23_73_0_, DLFileEntry.fileEntryTypeId AS fileEnt24_73_0_, DLFileEntry.version AS version73_0_, DLFileEntry.size_ AS size26_73_0_, DLFileEntry.smallImageId AS smallIm27_73_0_, DLFileEntry.largeImageId AS largeIm28_73_0_, DLFileEntry.custom1ImageId AS custom29_73_0_, DLFileEntry.custom2ImageId AS custom30_73_0_, DLFileEntry.manualCheckInRequired AS manualC31_73_0_, DLFileEntry.expirationDate AS expirat32_73_0_, DLFileEntry.reviewDate AS reviewDate73_0_, DLFileEntry.lastPublishDate AS lastPub34_73_0_ FROM DLFileEntry INNER JOIN DLFileVersion ON DLFileVersion.fileEntryId = DLFileEntry.fileEntryId WHERE (CAST(DLFileEntry.extraSettings AS VARCHAR (4000)) IS NOT NULL) OR (CAST(DLFileVersion.extraSettings AS VARCHAR (4000)) IS NOT NULL) AND DLFileEntry.ctCollectionId = 0 AND DLFileVersion.ctCollectionId = 0 ORDER BY DLFileEntry.modifiedDate DESC) WHERE rownum <= ?, Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB
      
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
              ... 227 more
      

        Attachments

          Activity

            People

            Assignee:
            jeremy.chen Jeremy Chen
            Reporter:
            michael.bowerman Michael Bowerman
            Participants of an Issue:
            Recent user:
            Enterprise Release HU
            Engineering Assignee:
            Michael Bowerman
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              8 weeks ago

                Packages

                Version Package
                7.3.X
                Master