[LRA-207] SQL Query error with Events Portlet. Created: 09/Jun/15 Updated: 27/Jun/15 Resolved: 26/Jun/15 |
|
| Status: | Closed |
| Project: | Liferay Apps |
| Component/s: | Events |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Pavan [X] (Inactive) | Assignee: | Jose Ross [X] (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Liferay Portal 6.2 CE GA3
Latest Events Portlet *MSSQL Server 2012 |
||
| MoSCoW: | Must do |
| Resolution Date: |
| 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. |
| Comments |
| Comment by Jose Ross [X] (Inactive) [ 26/Jun/15 ] |
|
The problem was caused by a generated SQL sentence that certain databases are unable to execute.
The solution provided is to use an additional parameter in the DynamicQuery to assure that the resulting SQL sentence is valid in any database. |
| Comment by mcalvo [ 26/Jun/15 ] |
|
It was fixed in this pull request https://github.com/rivetlogic/liferay-events/pull/3 |
| Comment by Pavan [X] (Inactive) [ 27/Jun/15 ] |
| Thanks. |