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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041420
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2019-07-22 19:112019-08-05 08:53
ReporterguillermogilView Statuspublic 
Assigned Toalekosmp86 
PrioritynormalResolutionfixedFixed in VersionRR19Q4
StatusclosedFix in branchFixed in SCM revisiona58838d2da07
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041420: Loading a ticket with a payment that is not configured fails

DescriptionThe payment type of the current payment is not configured for the webpos
The following error appears:

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 1, column 383 [select p.paymentMethod.name as name, p.account.id as account, obpos_currency_rate(p.account.currency, p.organization.currency, null, null, p.client.id, p.organization.id) as rate, obpos_currency_rate(p.organization.currency, p.account.currency, null, null, p.client.id, p.organization.id) as mulrate, p.account.currency.iSOCode as isocode from FIN_Payment as p where p.id=:paymentId)]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:133) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:164) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:715) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:731) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:105) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.openbravo.retail.posterminal.PaidReceipts.exec(PaidReceipts.java:460) ~[classes/:?]
        ... 53 more
Steps To ReproduceCreate a ticket with Credit card
Deconfigure the payment method
Reload Webpos
Load that ticket
Proposed SolutionSee diff attached
TagsNo tags attached.
Attached Filesdiff file icon Issue41420.diff [^] (1,139 bytes) 2019-07-22 19:21 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0041622 closedrqueralta Invoices paid with inactive payment methods cannot be printed from WebPOS 

-  Notes
(0113793)
hgbot (developer)
2019-08-02 20:02

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a58838d2da07b7ad137f0410f680c503677320a4
Author: Guillermo Gil <guillermo.gil <at> openbravo.com>
Date: Mon Jul 22 18:36:52 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a58838d2da07b7ad137f0410f680c503677320a4 [^]

Fixed issue 41420: Removed wrong ) on PaidReceipts

---
M src/org/openbravo/retail/posterminal/PaidReceipts.java
---

- Issue History
Date Modified Username Field Change
2019-07-22 19:11 guillermogil New Issue
2019-07-22 19:11 guillermogil Assigned To => Retail
2019-07-22 19:11 guillermogil OBNetwork customer => Gold
2019-07-22 19:11 guillermogil Resolution time => 1564783200
2019-07-22 19:11 guillermogil Triggers an Emergency Pack => No
2019-07-22 19:21 guillermogil File Added: Issue41420.diff
2019-07-22 19:21 guillermogil Reproducibility have not tried => always
2019-08-01 20:54 alekosmp86 Assigned To Retail => alekosmp86
2019-08-02 20:02 hgbot Checkin
2019-08-02 20:02 hgbot Note Added: 0113793
2019-08-02 20:02 hgbot Status new => resolved
2019-08-02 20:02 hgbot Resolution open => fixed
2019-08-02 20:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a58838d2da07b7ad137f0410f680c503677320a4 [^]
2019-08-05 08:53 marvintm Review Assigned To => marvintm
2019-08-05 08:53 marvintm Status resolved => closed
2019-08-05 08:53 marvintm Fixed in Version => RR19Q4
2019-08-09 11:03 aaroncalero Relationship added related to 0041622

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker