Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032731Retail ModulesWeb POSpublic2016-04-20 13:082016-06-07 16:43
Reporteradrianromero 
Assigned ToSandrahuguet 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2Fixed in VersionRR16Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
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
Summary0032731: 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
TagsNo tags attached.
Relationships
blocks defect 0032727 closed Sandrahuguet Error thrown when finding related services for a list of lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-04-20 15:14SandrahuguetTypedefect => backport
2016-04-20 15:14SandrahuguetTarget Version => RR16Q2
2016-04-20 15:56SandrahuguetAssigned ToRetail => Sandrahuguet
2016-04-20 16:28SandrahuguetRegression date => 2016-03-07
2016-04-20 16:28SandrahuguetRegression introduced in release => main
2016-04-20 18:01SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11814#r11814
2016-04-22 08:28hgbotCheckin
2016-04-22 08:28hgbotNote Added: 0085867
2016-04-22 08:32hgbotCheckin
2016-04-22 08:32hgbotNote Added: 0085868
2016-04-22 08:32hgbotStatusscheduled => resolved
2016-04-22 08:32hgbotResolutionopen => fixed
2016-04-22 08:32hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/573cc8a2507756fdad5da947decde213bb8635ff [^]
2016-06-07 16:43marvintmReview Assigned To => marvintm
2016-06-07 16:43marvintmStatusresolved => closed
2016-06-07 16:43marvintmFixed in Version => RR16Q2

Notes
(0085867)
hgbot   
2016-04-22 08:28   
Repository: retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal
Changeset: 6f00f8f4a294cb76b3f9cb6dee47ba8dc7b963f3
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Apr 22 08:27:45 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal/rev/6f00f8f4a294cb76b3f9cb6dee47ba8dc7b963f3 [^]

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

---
M web/org.openbravo.retail.posterminal/js/components/servicesfilter.js
---
(0085868)
hgbot   
2016-04-22 08:32   
Repository: retail/backports/3.0RR16Q2/org.openbravo.mobile.core
Changeset: 573cc8a2507756fdad5da947decde213bb8635ff
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Apr 22 08:32:10 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/573cc8a2507756fdad5da947decde213bb8635ff [^]

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

---
M src/org/openbravo/mobile/core/process/SimpleQueryBuilder.java
---