Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032727Retail ModulesWeb POSpublic2016-04-20 13:082016-04-22 12:45
Reporteradrianromero 
Assigned ToSandrahuguet 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression levelQA functional test
Regression date2016-03-07
Regression introduced in releasemain
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a676 [^]
Triggers an Emergency PackNo
Summary0032727: Error thrown when finding related services for a list of lines
DescriptionWhen listing common services for two or more lines an OBDAL message is raised.

This is the exception thrown in the log:

122652 [http-8080-5] ERROR org.openbravo.mobile.core.process.JSONRowConverter - Error in JSON process: java.math.BigDecimal cannot be cast to java.lang.Long
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Long
    at org.hibernate.type.descriptor.java.LongTypeDescriptor.unwrap(LongTypeDescriptor.java:36)
    at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$1.doBind(BigIntTypeDescriptor.java:52)
    at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:91)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
    at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:67)
    at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:571)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1716)
    at org.hibernate.loader.Loader.scroll(Loader.java:2605)
    at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:514)
    at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:415)
    at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:269)
    at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1353)
    at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:90)
    at org.openbravo.mobile.core.process.ProcessHQLQuery$1.buildResponse(ProcessHQLQuery.java:255)
    at org.openbravo.mobile.core.process.ProcessHQLQuery$1.buildResponse(ProcessHQLQuery.java:263)
    at org.openbravo.mobile.core.process.ProcessHQLQuery.exec(ProcessHQLQuery.java:213)
    at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:42)
    at org.openbravo.mobile.core.process.MobileService.execProcess(MobileService.java:241)
    at org.openbravo.mobile.core.process.MobileService.execServiceName(MobileService.java:204)
    at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:101)
    at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:71)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
    at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:745)
122657 [http-8080-5] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: java.math.BigDecimal cannot be cast to java.lang.Long
Steps To ReproduceEnable all high volumes preferences
* Log in the WebPOS
* Tap on search button and add to the receipt the following products: TV, bed and sofa.
* Select all lines
* Click on services icon to list all common services
An OBDAL message error is displayed
Proposed Solution
Additional Information
TagsSER-QA
Relationships
depends on backport 0032731RR16Q2 closed Sandrahuguet Error thrown when finding related services for a list of lines 
caused by defect 0031257RR16Q2 closed Sandrahuguet Prevent sql injection in SimpleQueryBuilder 
Attached Filesdiff issue32727.diff (2,262) 2016-04-20 13:41
https://issues.openbravo.com/file_download.php?file_id=9289&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-04-20 13:08adrianromeroNew Issue
2016-04-20 13:08adrianromeroAssigned To => Retail
2016-04-20 13:08adrianromeroTriggers an Emergency Pack => No
2016-04-20 13:09adrianromeroRegression level => QA functional test
2016-04-20 13:09adrianromeroRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a676 [^]
2016-04-20 13:10adrianromeroTag Attached: SER-QA
2016-04-20 13:10adrianromeroRelationship addedcaused by 0031257
2016-04-20 13:41adrianromeroFile Added: issue32727.diff
2016-04-20 15:14SandrahuguetStatusnew => scheduled
2016-04-20 15:52mtaalAssigned ToRetail => Sandrahuguet
2016-04-20 16:21SandrahuguetRegression date => 2016-03-07
2016-04-20 16:21SandrahuguetRegression introduced in release => main
2016-04-20 18:00SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11812#r11812
2016-04-20 18:01SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11815#r11815
2016-04-21 09:19SandrahuguetRelationship deleteddepends on 0032732
2016-04-22 08:11hgbotCheckin
2016-04-22 08:11hgbotNote Added: 0085859
2016-04-22 08:11hgbotStatusscheduled => resolved
2016-04-22 08:11hgbotResolutionopen => fixed
2016-04-22 08:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5fb5b9ee81ac6d38a1e944b72538d37b3d3283cc [^]
2016-04-22 08:13hgbotCheckin
2016-04-22 08:13hgbotNote Added: 0085860
2016-04-22 08:13hgbotCheckin
2016-04-22 08:13hgbotNote Added: 0085861
2016-04-22 08:15SandrahuguetReview Assigned To => mtaal
2016-04-22 08:16hgbotCheckin
2016-04-22 08:16hgbotNote Added: 0085862
2016-04-22 08:19hgbotCheckin
2016-04-22 08:19hgbotNote Added: 0085863
2016-04-22 08:59SandrahuguetReview Assigned Tomtaal => marvintm
2016-04-22 08:59SandrahuguetReview Assigned Tomarvintm => migueldejuana
2016-04-22 12:45migueldejuanaNote Added: 0085888
2016-04-22 12:45migueldejuanaStatusresolved => closed

Notes
(0085859)
hgbot   
2016-04-22 08:11   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 5fb5b9ee81ac6d38a1e944b72538d37b3d3283cc
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Apr 21 13:35:39 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5fb5b9ee81ac6d38a1e944b72538d37b3d3283cc [^]

Fixed issue 32727 Error thrown when finding related services for a list of lines

---
M src/org/openbravo/mobile/core/process/SimpleQueryBuilder.java
---
(0085860)
hgbot   
2016-04-22 08:13   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 58bbbd38959133bcb3ec8261c95052fa164c7463
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Apr 21 13:28:20 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/58bbbd38959133bcb3ec8261c95052fa164c7463 [^]

related to issue 32727: Error thrown when finding related services for a list of lines

---
M web/org.openbravo.retail.posterminal/js/components/servicesfilter.js
---
(0085861)
hgbot   
2016-04-22 08:13   
Repository: tools/automation/pi-mobile
Changeset: b74bc8978eed09cde198d06c38a79d66f43caedf
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 20 17:53:32 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/b74bc8978eed09cde198d06c38a79d66f43caedf [^]

related to issue 32727 QuantityRules_UniqueQuantity in hgvol

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/services/QuantityRules_UniqueQuantity.java
---
(0085862)
hgbot   
2016-04-22 08:16   
Repository: erp/pmods/org.openbravo.retail.stockcriteria
Changeset: 83130c78b59b206c9346964955d74d411354773c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Apr 22 08:15:58 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.stockcriteria/rev/83130c78b59b206c9346964955d74d411354773c [^]

related to issue 32727 added number fieldtype

---
M web/org.openbravo.retail.stockcriteria/js/hookStockCriteria.js
---
(0085863)
hgbot   
2016-04-22 08:19   
Repository: erp/pmods/org.openbravo.retail.pricecriteria
Changeset: 6cc7b12c294c69de92e7800be02f38e911aeb25b
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Apr 22 08:19:23 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.pricecriteria/rev/6cc7b12c294c69de92e7800be02f38e911aeb25b [^]

related to issue 32727 added number fieldtype

---
M web/org.openbravo.retail.pricecriteria/js/hookPriceCriteria.js
---
(0085888)
migueldejuana   
2016-04-22 12:45   
Tested and reviewed