Cannot view Products in Admin 1.5M4 (Merchandising Module)
Posted: Wed Oct 26, 2011 3:29 am
Hi
I managed to get the Admin 1.5M4 console running using MySQL and Tomcat 6. However i am getting a error when trying to view the products. I type in a product name in the filter ('orig'), hit enter, and then recieve a popup with the following message
FETCH
Error while processing RPC request:
Unable to fetch results for org.broadleafcommerce.core.catalog.domain.Product
This is the extract from the logs...
Could i be doing something wrong?
I managed to get the Admin 1.5M4 console running using MySQL and Tomcat 6. However i am getting a error when trying to view the products. I type in a product name in the filter ('orig'), hit enter, and then recieve a popup with the following message
FETCH
Error while processing RPC request:
Unable to fetch results for org.broadleafcommerce.core.catalog.domain.Product
This is the extract from the logs...
Code: Select all
Hibernate: select this_.PRODUCT_ID as PRODUCT1_23_3_, this_.ACTIVE_END_DATE as ACTIVE2_23_3_, this_.ACTIVE_START_DATE as ACTIVE3_23_3_, this_.DEFAULT_CATEGORY_ID as DEFAULT20_23_3_, this_.DESCRIPTION as DESCRIPT4_23_3_, this_.CONTAINER_SHAPE as CONTAINER5_23_3_, this_.DEPTH as DEPTH23_3_, this_.DIMENSION_UNIT_OF_MEASURE as DIMENSION7_23_3_, this_.GIRTH as GIRTH23_3_, this_.HEIGHT as HEIGHT23_3_, this_.CONTAINER_SIZE as CONTAINER10_23_3_, this_.WIDTH as WIDTH23_3_, this_.IS_FEATURED_PRODUCT as IS12_23_3_, this_.IS_MACHINE_SORTABLE as IS13_23_3_, this_.LONG_DESCRIPTION as LONG14_23_3_, this_.MANUFACTURE as MANUFAC15_23_3_, this_.MODEL as MODEL23_3_, this_.NAME as NAME23_3_, this_.WEIGHT as WEIGHT23_3_, this_.WEIGHT_UNIT_OF_MEASURE as WEIGHT19_23_3_, this_2_.SKU_ID as SKU1_25_3_, case when this_1_.PRODUCT_ID is not null then 1 when this_.PRODUCT_ID is not null then 0 end as clazz_3_, categoryim2_.CATEGORY_ID as CATEGORY1_16_0_, categoryim2_.ACTIVE_END_DATE as ACTIVE2_16_0_, categoryim2_.ACTIVE_START_DATE as ACTIVE3_16_0_, categoryim2_.DEFAULT_PARENT_CATEGORY_ID as DEFAULT10_16_0_, categoryim2_.DESCRIPTION as DESCRIPT4_16_0_, categoryim2_.DISPLAY_TEMPLATE as DISPLAY5_16_0_, categoryim2_.LONG_DESCRIPTION as LONG6_16_0_, categoryim2_.NAME as NAME16_0_, categoryim2_.URL as URL16_0_, categoryim2_.URL_KEY as URL9_16_0_, categoryim3_.CATEGORY_ID as CATEGORY1_16_1_, categoryim3_.ACTIVE_END_DATE as ACTIVE2_16_1_, categoryim3_.ACTIVE_START_DATE as ACTIVE3_16_1_, categoryim3_.DEFAULT_PARENT_CATEGORY_ID as DEFAULT10_16_1_, categoryim3_.DESCRIPTION as DESCRIPT4_16_1_, categoryim3_.DISPLAY_TEMPLATE as DISPLAY5_16_1_, categoryim3_.LONG_DESCRIPTION as LONG6_16_1_, categoryim3_.NAME as NAME16_1_, categoryim3_.URL as URL16_1_, categoryim3_.URL_KEY as URL9_16_1_, skuimpl4_.SKU_ID as SKU1_27_2_, skuimpl4_.ACTIVE_END_DATE as ACTIVE2_27_2_, skuimpl4_.ACTIVE_START_DATE as ACTIVE3_27_2_, skuimpl4_.AVAILABLE_FLAG as AVAILABLE4_27_2_, skuimpl4_.DESCRIPTION as DESCRIPT5_27_2_, skuimpl4_.DISCOUNTABLE_FLAG as DISCOUNT6_27_2_, skuimpl4_.LONG_DESCRIPTION as LONG7_27_2_, skuimpl4_.NAME as NAME27_2_, skuimpl4_.RETAIL_PRICE as RETAIL9_27_2_, skuimpl4_.SALE_PRICE as SALE10_27_2_, skuimpl4_.TAXABLE_FLAG as TAXABLE11_27_2_ from BLC_PRODUCT this_ left outer join BLC_PRODUCT_SKU this_1_ on this_.PRODUCT_ID=this_1_.PRODUCT_ID left outer join BLC_PRODUCT_SKU_ONE_XREF this_2_ on this_.PRODUCT_ID=this_2_.PRODUCT_ID left outer join BLC_CATEGORY categoryim2_ on this_.DEFAULT_CATEGORY_ID=categoryim2_.CATEGORY_ID left outer join BLC_CATEGORY categoryim3_ on categoryim2_.DEFAULT_PARENT_CATEGORY_ID=categoryim3_.CATEGORY_ID left outer join BLC_SKU skuimpl4_ on this_2_.SKU_ID=skuimpl4_.SKU_ID where lower(this_.NAME) like ? offset ? limit ?
[ WARN] 10:03:05 JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000
[ERROR] 10:03:05 JDBCExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'offset 23 limit 10' at line 1
[ERROR] 10:03:05 BasicPersistenceModule - Problem fetching results for org.broadleafcommerce.core.catalog.domain.Product
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:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at org.broadleafcommerce.openadmin.server.dao.BaseHibernateCriteriaDao.query(BaseHibernateCriteriaDao.java:53)
at org.broadleafcommerce.openadmin.server.service.persistence.module.BasicPersistenceModule.fetch(BasicPersistenceModule.java:812)
at org.broadleafcommerce.openadmin.server.service.persistence.PersistenceManagerImpl.fetch(PersistenceManagerImpl.java:208)
at org.broadleafcommerce.openadmin.server.service.DynamicEntityRemoteService.fetch(DynamicEntityRemoteService.java:113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
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 $Proxy95.fetch(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.invokeMethodOnService(GWTRPCServiceExporter.java:169)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.processCall(GWTRPCServiceExporter.java:338)
at org.broadleafcommerce.openadmin.security.CompatibleGWTSecuredRPCServiceExporter.processCall(CompatibleGWTSecuredRPCServiceExporter.java:100)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:243)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.handleRequest(GWTRPCServiceExporter.java:407)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:304)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'offset 23 limit 10' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
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:2533)
... 86 more
[ WARN] 10:03:43 CompatibleGWTSecuredRPCServiceExporter - org.broadleafcommerce.openadmin.client.service.ServiceException: Unable to fetch results for org.broadleafcommerce.core.catalog.domain.Product
Hibernate: select customerim0_.CUSTOMER_ID as CUSTOMER1_7_, customerim0_.CREATED_BY as CREATED2_7_, customerim0_.DATE_CREATED as DATE3_7_, customerim0_.DATE_UPDATED as DATE4_7_, customerim0_.UPDATED_BY as UPDATED5_7_, customerim0_.CHALLENGE_ANSWER as CHALLENGE6_7_, customerim0_.CHALLENGE_QUESTION_ID as CHALLENGE16_7_, customerim0_.CUSTOMER_LOCALE as CUSTOMER7_7_, customerim0_.EMAIL_ADDRESS as EMAIL8_7_, customerim0_.FIRST_NAME as FIRST9_7_, customerim0_.LAST_NAME as LAST10_7_, customerim0_.PASSWORD as PASSWORD7_, customerim0_.PASSWORD_CHANGE_REQUIRED as PASSWORD12_7_, customerim0_.RECEIVE_EMAIL as RECEIVE13_7_, customerim0_.IS_REGISTERED as IS14_7_, customerim0_.USER_NAME as USER15_7_ from BLC_CUSTOMER customerim0_ where customerim0_.USER_NAME=?
Could i be doing something wrong?