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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039978
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2019-01-18 14:242019-02-04 09:10
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in VersionRR19Q2
StatusclosedFix in branchFixed in SCM revisionf0f44765333f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039978: Tapping on the show services button in a negative line raises an error

DescriptionIf activated all the remote preferences. In a receipt with a return line that has a product with services, tapping on the show services button an error is raised.

The exception raised in the backed is:
2019-01-18 13:46:13,038 [http-bio-8080-exec-2] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.master.Product: Error when generating query: null (null)
java.lang.NumberFormatException: null
    at java.math.BigDecimal.<init>(BigDecimal.java:494) ~[?:1.8.0_191]
    at java.math.BigDecimal.<init>(BigDecimal.java:383) ~[?:1.8.0_191]
    at java.math.BigDecimal.<init>(BigDecimal.java:806) ~[?:1.8.0_191]
    at org.openbravo.retail.posterminal.ServicesHQLCriteria.getHQLFilter(ServicesHQLCriteria.java:31) ~[ServicesHQLCriteria.class:?]
    at org.openbravo.retail.posterminal.ServicesHQLCriteria$Proxy$_$$_WeldClientProxy.getHQLFilter(ServicesHQLCriteria$Proxy$_$$_WeldClientProxy.java) ~[ServicesHQLCriteria.class:?]
    at org.openbravo.mobile.core.process.SimpleQueryBuilder$HQLCriteria.getPart(SimpleQueryBuilder.java:572) ~[SimpleQueryBuilder$HQLCriteria.class:?]

The error is because in this line: https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/file/tip/web/org.openbravo.retail.posterminal/js/components/servicesfilter.js#l241 [^]
minimumSelected === Infinity
Steps To Reproduce1. In backend set all "Enable Remote..." preferences to 'Y'
2. Login in web pos add add a line with the product "Sofa"
3. Select the created line and tap on the button "Return Line". The quantity becomes -1.
4. Tap on the "Show services" button

Observe an error is raised
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0109066)
hgbot (developer)
2019-01-22 12:05

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: da22035f94c0b492f9a36477f8f53e05641293eb
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Jan 21 17:14:07 2019 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/da22035f94c0b492f9a36477f8f53e05641293eb [^]

Fixed issue 39978: Tapping on the show services button in a negative line raises
an error

- Replaced Infinity by Number.MAX_VALUE property

---
M web/org.openbravo.retail.posterminal/js/components/servicesfilter.js
---
(0109145)
adrianromero (manager)
2019-01-24 10:08

This fix does not work in Oracle. This is the error raised:

2019-01-24 06:11:17,643 [ajp-bio-127.0.0.1-8009-exec-1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-01426: numeric overflow
(0109324)
hgbot (developer)
2019-01-30 11:28

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: f0f44765333f38066245922f375090f747317b9f
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jan 24 18:14:39 2019 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f0f44765333f38066245922f375090f747317b9f [^]

Fixes issue 39978: Tapping on the show services button in a negative line raises an error
Using 999999999999 as a safe maximum value common for PostgreSQL and Oracle

---
M web/org.openbravo.retail.posterminal/js/components/servicesfilter.js
---
(0109325)
hgbot (developer)
2019-01-30 11:28

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 9ffb537e19fa7e5990c18708339d5d5cff39586f
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jan 29 08:59:20 2019 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9ffb537e19fa7e5990c18708339d5d5cff39586f [^]

Related to issue 39978: Tapping on the show services button in a negative line raises an error

---
M web/org.openbravo.retail.posterminal/js/components/servicesfilter.js
---
(0109456)
hgbot (developer)
2019-02-03 02:51

Repository: tools/automation/pi-mobile
Changeset: c598a2ae8f094631bbae0508029e738eada0f9d3
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Tue Jan 22 11:48:54 2019 -0500
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/c598a2ae8f094631bbae0508029e738eada0f9d3 [^]

Related to issue 39978: added automated test

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/services/I39978_VerifyNoErrorOnShowServicesInNegativeLine.java
---

- Issue History
Date Modified Username Field Change
2019-01-18 14:24 adrianromero New Issue
2019-01-18 14:24 adrianromero Assigned To => Retail
2019-01-18 14:24 adrianromero Triggers an Emergency Pack => No
2019-01-18 14:30 adrianromero Description Updated View Revisions
2019-01-18 14:30 adrianromero Steps to Reproduce Updated View Revisions
2019-01-18 14:49 marvintm Resolution time => 1548975600
2019-01-19 19:28 rqueralta Assigned To Retail => rqueralta
2019-01-22 12:05 hgbot Checkin
2019-01-22 12:05 hgbot Note Added: 0109066
2019-01-22 12:05 hgbot Status new => resolved
2019-01-22 12:05 hgbot Resolution open => fixed
2019-01-22 12:05 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/da22035f94c0b492f9a36477f8f53e05641293eb [^]
2019-01-24 10:08 adrianromero Note Added: 0109145
2019-01-24 10:08 adrianromero Status resolved => new
2019-01-24 10:08 adrianromero Resolution fixed => open
2019-01-24 18:02 adrianromero Assigned To rqueralta => adrianromero
2019-01-24 18:02 adrianromero Status new => scheduled
2019-01-30 11:28 hgbot Checkin
2019-01-30 11:28 hgbot Note Added: 0109324
2019-01-30 11:28 hgbot Status scheduled => resolved
2019-01-30 11:28 hgbot Resolution open => fixed
2019-01-30 11:28 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/da22035f94c0b492f9a36477f8f53e05641293eb [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f0f44765333f38066245922f375090f747317b9f [^]
2019-01-30 11:28 hgbot Checkin
2019-01-30 11:28 hgbot Note Added: 0109325
2019-02-03 02:51 hgbot Checkin
2019-02-03 02:51 hgbot Note Added: 0109456
2019-02-04 09:10 marvintm Review Assigned To => marvintm
2019-02-04 09:10 marvintm Status resolved => closed
2019-02-04 09:10 marvintm Fixed in Version => RR19Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker