Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037605Retail ModulesWeb POSpublic2018-01-10 11:022018-01-25 11:41
Reporterjorge-garcia 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression levelQA functional test
Regression date2017-11-09
Regression introduced in releasemain
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/0bd84a6557f1 [^]
Triggers an Emergency PackNo
Summary0037605: UpdateIsLayawayData module script s failing if you update to 17Q3 or less
DescriptionUpdateIsLayawayData module script s failing if you update to 17Q3 or less
Steps To Reproduce1) Update retail Pack module to 3.0RR17Q3 tag
2) Do and update.database
3) Verify a error is raised due to a malformed query of the modulescript
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0037606RR18Q1 closed jorge-garcia UpdateIsLayawayData module script s failing if you update to 17Q3 or less 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-10 11:02jorge-garciaNew Issue
2018-01-10 11:02jorge-garciaAssigned To => jorge-garcia
2018-01-10 11:02jorge-garciaOBNetwork customer => No
2018-01-10 11:02jorge-garciaRegression level => QA functional test
2018-01-10 11:02jorge-garciaRegression introduced in release => main
2018-01-10 11:02jorge-garciaRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/0bd84a6557f1 [^]
2018-01-10 11:02jorge-garciaTriggers an Emergency Pack => No
2018-01-10 11:04jorge-garciaRegression date => 2017-11-09
2018-01-10 11:04jorge-garciaStatusnew => scheduled
2018-01-10 11:09hgbotCheckin
2018-01-10 11:09hgbotNote Added: 0101647
2018-01-10 11:09hgbotStatusscheduled => resolved
2018-01-10 11:09hgbotResolutionopen => fixed
2018-01-10 11:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5e5666df52b889c704c39183ea2d3b8986ff7a78 [^]
2018-01-10 12:41hgbotCheckin
2018-01-10 12:41hgbotNote Added: 0101648
2018-01-10 12:41hgbotCheckin
2018-01-10 12:41hgbotNote Added: 0101649
2018-01-10 12:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5e5666df52b889c704c39183ea2d3b8986ff7a78 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d050cd715c29bfab3e2822920a07c523bc3a1dea [^]
2018-01-25 11:41marvintmReview Assigned To => marvintm
2018-01-25 11:41marvintmStatusresolved => closed
2018-01-25 11:41marvintmFixed in Version => RR18Q2

Notes
(0101647)
hgbot   
2018-01-10 11:09   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5e5666df52b889c704c39183ea2d3b8986ff7a78
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Wed Jan 10 11:03:39 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5e5666df52b889c704c39183ea2d3b8986ff7a78 [^]

Fixed issue 37605: UpdateIsLayawayData module script s failing if you update to
17Q3 or less

A parenthesis is missing in the query

---
M build/classes/org/openbravo/retail/posterminal/modulescript/UpdateIsLayawayData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateIsLayaway_Data.xsql
---
(0101648)
hgbot   
2018-01-10 12:41   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c5c1e53e8491e01583eebffa64e7157f3a4c03c3
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Wed Jan 10 12:21:01 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c5c1e53e8491e01583eebffa64e7157f3a4c03c3 [^]

Related to issue 37605: UpdateIsLayawayData module script s failing if you update to
17Q3 or less

Backed out changeset 5e5666df52b8

---
M build/classes/org/openbravo/retail/posterminal/modulescript/UpdateIsLayawayData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateIsLayaway_Data.xsql
---
(0101649)
hgbot   
2018-01-10 12:41   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d050cd715c29bfab3e2822920a07c523bc3a1dea
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Wed Jan 10 12:41:33 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d050cd715c29bfab3e2822920a07c523bc3a1dea [^]

Fixed issue 37605: UpdateIsLayawayData module script s failing if you update to
17Q3 or less

A parenthesis is missing in the query

Modulescript compiled now with java 7.

---
M build/classes/org/openbravo/retail/posterminal/modulescript/UpdateIsLayawayData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateIsLayaway_Data.xsql
---