Uploaded image for project: 'Liferay Apps'
  1. Liferay Apps
  2. LRA-207

SQL Query error with Events Portlet.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Component/s: Events
    • Labels:
      None
    • Environment:
      Liferay Portal 6.2 CE GA3
      Latest Events Portlet
      *MSSQL Server 2012
    • MoSCoW:
      Must do

      Description

      I got a stable running Liferay Portal. Decided to work with Rivet Logic's Events Portlet.
      1)Installed from Marketplace.(recently)
      2)Followed the documentation and added Events Display and Events Management to Different pages.
      3)The moment i click event Display page, I get the following Error.

      Column "rivetlogic_event_Event.eventDate" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

      Full StakeTrace:
      __________________________________________________________
      11:19:37,550 ERROR [http-bio-8080-exec-20][JDBCExceptionReporter:82] Column "rivetlogic_event_Event.eventDate" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
        211:19:37,552 ERROR [http-bio-8080-exec-20][BasePersistenceImpl:244] Caught unexpected exception org.hibernate.exception.SQLGrammarException
        311:19:37,554 ERROR [http-bio-8080-exec-20][EventLocalServiceImpl:203] null
        4com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.SQLGrammarException: could not execute query
        5 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:251)
        6 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:144)
        7 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.countWithDynamicQuery(BasePersistenceImpl.java:105)
        8 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.countWithDynamicQuery(BasePersistenceImpl.java:90)
        9 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       10 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       11 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       12 at java.lang.reflect.Method.invoke(Method.java:606)
       13 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:320)
       14 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
       15 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
       16 at com.liferay.portal.dao.shard.advice.ShardPersistenceAdvice.invoke(ShardPersistenceAdvice.java:54)
       17 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       18 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
       19 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       20 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
       21 at com.sun.proxy.$Proxy484.countWithDynamicQuery(Unknown Source)
       22 at com.rivetlogic.event.service.impl.EventLocalServiceImpl.getPublicEventsCount(EventLocalServiceImpl.java:201)
       23 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       24 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       25 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       26 at java.lang.reflect.Method.invoke(Method.java:606)
       27 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
       28 at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
       29 at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
       30 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       31 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       32 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       33 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       34 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       35 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       36 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       37 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       38 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       39 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       40 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       41 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       42 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       43 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       44 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       45 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       46 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       47 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
       48 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
       49 at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
       50 at com.sun.proxy.$Proxy483.getPublicEventsCount(Unknown Source)
       51 at com.rivetlogic.event.service.EventLocalServiceUtil.getPublicEventsCount(EventLocalServiceUtil.java:358)
       52 at org.apache.jsp.html.eventportlet.view_jsp._jspService(view_jsp.java:358)
       53 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
       54 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
       55 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
       56 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
       57 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
       58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
       59 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
       60 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       61 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
       62 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
       63 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
       64 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       65 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
       66 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
       67 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
       68 at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:331)
       69 at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:112)
       70 at com.liferay.util.bridges.mvc.MVCPortlet.include(MVCPortlet.java:371)
       71 at com.liferay.util.bridges.mvc.MVCPortlet.include(MVCPortlet.java:387)
       72 at com.rivetlogic.event.portlet.EventPortlet.doView(EventPortlet.java:113)
       73 at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:213)
       74 at com.liferay.util.bridges.mvc.MVCPortlet.doDispatch(MVCPortlet.java:323)
       75 at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
       76 at com.rivetlogic.event.portlet.EventPortlet.render(EventPortlet.java:159)
       77 at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:103)
       78 at com.liferay.portlet.ScriptDataPortletFilter.doFilter(ScriptDataPortletFilter.java:55)
       79 at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
       80 at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
       81 at com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:112)
       82 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
       83 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
       84 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       85 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
       86 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
       87 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
       88 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       89 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
       90 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
       91 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
       92 at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:583)
       93 at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:656)
       94 at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:362)
       95 at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1233)
       96 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
       97 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
       98 at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
       99 at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
      100 at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
      101 at com.liferay.portlet.PortletContainerImpl._doRender(PortletContainerImpl.java:655)
      102 at com.liferay.portlet.PortletContainerImpl.render(PortletContainerImpl.java:138)
      103 at com.liferay.portlet.SecurityPortletContainerWrapper.render(SecurityPortletContainerWrapper.java:141)
      104 at com.liferay.portlet.RestrictPortletContainerWrapper.render(RestrictPortletContainerWrapper.java:126)
      105 at com.liferay.portal.kernel.portlet.PortletContainerUtil.render(PortletContainerUtil.java:156)
      106 at com.liferay.portal.action.RenderPortletAction.execute(RenderPortletAction.java:91)
      107 at com.liferay.portal.action.UpdateLayoutAction.addPortlet(UpdateLayoutAction.java:318)
      108 at com.liferay.portal.action.UpdateLayoutAction.getJSON(UpdateLayoutAction.java:270)
      109 at com.liferay.portal.struts.JSONAction.execute(JSONAction.java:78)
      110 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      111 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      112 at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:178)
      113 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      114 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
      115 at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
      116 at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:549)
      117 at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:526)
      118 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      119 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      120 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      121 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
      122 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      123 at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:359)
      124 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      125 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      126 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      127 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      128 at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
      129 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      130 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      131 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      132 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      133 at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:293)
      134 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      135 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      136 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      137 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      138 at com.liferay.portal.servlet.filters.jsoncontenttype.JSONContentTypeFilter.processFilter(JSONContentTypeFilter.java:42)
      139 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      140 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      141 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      142 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      143 at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
      144 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      145 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      146 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      147 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      148 at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88)
      149 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      150 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      151 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      152 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
      153 at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:226)
      154 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
      155 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      156 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      157 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
      158 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
      159 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
      160 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
      161 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
      162 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
      163 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
      164 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
      165 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
      166 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
      167 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
      168 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
      169 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      170 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      171 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      172 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      173 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
      174 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      175 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
      176 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
      177 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      178 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      179 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
      180 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
      181 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
      182 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      183 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      184 at java.lang.Thread.run(Thread.java:745)
      185Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      186 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
      187 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      188 at org.hibernate.loader.Loader.doList(Loader.java:2545)
      189 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      190 at org.hibernate.loader.Loader.list(Loader.java:2271)
      191 at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
      192 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
      193 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
      194 at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:94)
      195 at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:88)
      196 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:141)
      197 ... 178 more
      198Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column "rivetlogic_event_Event.eventDate" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
      199 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
      200 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
      201 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
      202 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
      203 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
      204 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
      205 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
      206 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
      207 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
      208 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
      209 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      210 at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
      211 at org.hibernate.loader.Loader.doQuery(Loader.java:802)
      212 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      213 at org.hibernate.loader.Loader.doList(Loader.java:2542)
      214 ... 186 more


      _____________________________________________________
      How ever i don't see any Error on Front end pages. i see them only in Console.

      I found the code that causing this error.
      Class: com.rivetlogic.event.service.impl.EventLocalServiceImpl
      Line no: 102
      Code: Order order = OrderFactoryUtil.asc(EVENT_DATE_COLUMN);

      The above code seems to be a problem with MSSQL Server.
      I just Commented the line, and Seems Everything is Working fine.

      Thanks,

      PS: i never submitted an issue, So, please excuse for any mistakes.

        Attachments

          Activity

            People

            • Assignee:
              jose.ross Jose Ross [X] (Inactive)
              Reporter:
              PavanJdev Pavan [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Resolution Date:

                Zendesk Support