Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0032727
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2016-04-20 13:082016-04-22 12:45
ReporteradrianromeroView Statuspublic 
Assigned ToSandrahuguet 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5fb5b9ee81ac
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomigueldejuana
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
Summary

0032727: 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
TagsSER-QA
Attached Filesdiff file icon issue32727.diff [^] (2,262 bytes) 2016-04-20 13:41 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0032731RR16Q2 closedSandrahuguet Error thrown when finding related services for a list of lines 
caused by defect 0031257RR16Q2 closedSandrahuguet Prevent sql injection in SimpleQueryBuilder 

-  Notes
(0085859)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2016-04-22 12:45

Tested and reviewed

- Issue History
Date Modified Username Field Change
2016-04-20 13:08 adrianromero New Issue
2016-04-20 13:08 adrianromero Assigned To => Retail
2016-04-20 13:08 adrianromero Triggers an Emergency Pack => No
2016-04-20 13:09 adrianromero Regression level => QA functional test
2016-04-20 13:09 adrianromero Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a676 [^]
2016-04-20 13:10 adrianromero Tag Attached: SER-QA
2016-04-20 13:10 adrianromero Relationship added caused by 0031257
2016-04-20 13:41 adrianromero File Added: issue32727.diff
2016-04-20 15:14 Sandrahuguet Status new => scheduled
2016-04-20 15:52 mtaal Assigned To Retail => Sandrahuguet
2016-04-20 16:21 Sandrahuguet Regression date => 2016-03-07
2016-04-20 16:21 Sandrahuguet Regression introduced in release => main
2016-04-20 18:00 Sandrahuguet Steps to Reproduce Updated View Revisions
2016-04-20 18:01 Sandrahuguet Steps to Reproduce Updated View Revisions
2016-04-21 09:19 Sandrahuguet Relationship deleted depends on 0032732
2016-04-22 08:11 hgbot Checkin
2016-04-22 08:11 hgbot Note Added: 0085859
2016-04-22 08:11 hgbot Status scheduled => resolved
2016-04-22 08:11 hgbot Resolution open => fixed
2016-04-22 08:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5fb5b9ee81ac6d38a1e944b72538d37b3d3283cc [^]
2016-04-22 08:13 hgbot Checkin
2016-04-22 08:13 hgbot Note Added: 0085860
2016-04-22 08:13 hgbot Checkin
2016-04-22 08:13 hgbot Note Added: 0085861
2016-04-22 08:15 Sandrahuguet Review Assigned To => mtaal
2016-04-22 08:16 hgbot Checkin
2016-04-22 08:16 hgbot Note Added: 0085862
2016-04-22 08:19 hgbot Checkin
2016-04-22 08:19 hgbot Note Added: 0085863
2016-04-22 08:59 Sandrahuguet Review Assigned To mtaal => marvintm
2016-04-22 08:59 Sandrahuguet Review Assigned To marvintm => migueldejuana
2016-04-22 12:45 migueldejuana Note Added: 0085888
2016-04-22 12:45 migueldejuana Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker