Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POScriticalalways2016-11-07 10:302016-11-15 17:51
ReporterguillermogilView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityimmediateResolutionfixedFixed in VersionRR16Q3.3
StatusclosedFix in branchFixed in SCM revision7da8fb59bf9f
ProjectionnoneETAnoneTarget VersionRR16Q3.3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toguilleaer
Regression levelQA functional test
Regression date2016-07-26
Regression introduced in releaseRR16Q3
Regression introduced by commit [^]
Triggers an Emergency PackNo

0034408: [RR16Q3] It is not possible to load on WebPOS if you have more than 35000 products

DescriptionIt is not possible to load on WebPOS if you have more than 35000 products.
You get the following error on the load:

95b61838 9878538 [http-8080-5] ERROR - Error in JSON process: could not execute query using scroll
org.hibernate.exception.GenericJDBCException: could not execute query using scroll
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
    at org.hibernate.exception.SQLStateConverter.convert(
    at org.hibernate.exception.JDBCExceptionHelper.convert(
    at org.hibernate.loader.Loader.scroll(
    at org.hibernate.loader.hql.QueryLoader.scroll(
    at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(
    at org.hibernate.engine.query.HQLQueryPlan.performScroll(
    at org.hibernate.impl.SessionImpl.scroll(
    at org.hibernate.impl.QueryImpl.scroll(
    at javax.servlet.http.HttpServlet.service(
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(
    at javax.servlet.http.HttpServlet.service(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.openbravo.utils.SessionExpirationFilter.doFilter(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.openbravo.utils.CharsetFilter.doFilter(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.openbravo.client.kernel.KernelFilter$1.doAction(
    at org.openbravo.client.kernel.KernelFilter.doFilter(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(
    at org.openbravo.dal.core.DalRequestFilter.doFilter(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.apache.catalina.core.StandardWrapperValve.invoke(
    at org.apache.catalina.core.StandardContextValve.invoke(
    at org.apache.catalina.core.StandardHostValve.invoke(
    at org.apache.catalina.valves.ErrorReportValve.invoke(
    at org.apache.catalina.core.StandardEngineValve.invoke(
    at org.apache.catalina.connector.CoyoteAdapter.service(
    at org.apache.coyote.http11.Http11Processor.process(
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Caused by: org.postgresql.util.PSQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.
    at org.postgresql.jdbc.PgResultSet.checkScrollable(
    at org.postgresql.jdbc.PgResultSet.absolute(
    at org.hibernate.loader.Loader.advance(
    at org.hibernate.loader.Loader.getResultSet(
    at org.hibernate.loader.Loader.scroll(
    ... 47 more

Also it does not stop the loading process and it should.
Steps To ReproduceChange the limit and offset parameters in the standard sampledata.

Try to load WebPOS
Proposed SolutionIt seems to be a wrong backport:
16Q3 - Wrong: [^]
16Q2 - OK: [^]

It should be needed to remove the following line:
limit = limit - queryRows;
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by backport 0033536RR16Q3 closedranjith_qualiantech_com Masterdata loading fails when pagination happens 
blocks defect 0034407 closedRetail [RR16Q3] It is not possible to load on WebPOS if you have more than 35000 products 

-  Notes
hgbot (developer)
2016-11-07 12:28

Repository: retail/backports/3.0RR16Q3.3/
Changeset: 7da8fb59bf9f44607f56b41bd415cce4dc617a71
Author: Ranjith S R <ranjith <at>>
Date: Mon Nov 07 15:38:46 2016 +0530
URL: [^]

Fixes issue 34408 : Removed Unnessary code in ProcessHQLQuery

- Line should be removed in the issue 33536, but its not
- Removed line is unnecessary and it has to be removed in the changeset 701f8f37413c, but its not

M src/org/openbravo/mobile/core/process/

- Issue History
Date Modified Username Field Change
2016-11-07 10:43 marvintm Type defect => backport
2016-11-07 10:43 marvintm Target Version => RR16Q3.3
2016-11-07 10:47 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2016-11-07 10:54 guillermogil Relationship added caused by 0033536
2016-11-07 12:28 hgbot Checkin
2016-11-07 12:28 hgbot Note Added: 0091198
2016-11-07 12:28 hgbot Status scheduled => resolved
2016-11-07 12:28 hgbot Resolution open => fixed
2016-11-07 12:28 hgbot Fixed in SCM revision => [^]
2016-11-15 17:51 guilleaer Review Assigned To => guilleaer
2016-11-15 17:51 guilleaer Status resolved => closed
2016-11-15 17:51 guilleaer Fixed in Version => RR16Q3.3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker