Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037678Retail ModulesWeb POSpublic2017-12-22 11:012018-01-25 11:27
ReporterJONHM 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR18Q1Fixed in VersionRR18Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket49906
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037678: Error in module script UpdateCashupReport because name column has 60 chars length
DescriptionThere is an error in module script UpdateCashupReport (insertCashManagementEvents method) when description field from 'fin_finacc_transaction' table have more than 60 chars, because 'name' column length from 'OBPOS_Paymentcashup_Events' table has only 60 chars.
Steps To Reproduceupdate to 3.0RR17Q2 having descriptions in fin_finacc_transaction with more than 60 chars

It shows message: ERROR: value too long for type character varying(60)
Proposed SolutionOption 1) Change the 'name' column length of OBPOS_Paymentcashup_Events table from 60 to 255 chars

Option 2) Limit the lenght of the description to 60 chars when importing:
line 73: substr(trans.description, 60),

https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/file/tip/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql#l73 [^]
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037543 closed rqueralta Error in module script UpdateCashupReport because name column has 60 chars length 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-19 10:16marvintmTypedefect => backport
2018-01-19 10:16marvintmTarget Version => RR18Q1
2018-01-22 19:41hgbotCheckin
2018-01-22 19:41hgbotNote Added: 0101860
2018-01-22 19:41hgbotStatusscheduled => resolved
2018-01-22 19:41hgbotResolutionopen => fixed
2018-01-22 19:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2942fcbbaa9ba592b760e06d204f51add4238d0b [^] => http://code.openbravo.com/retail/backports/3.0RR18Q1/org.openbravo.retail.posterminal/rev/ed3ac66e7b1f35c2d0fb98c8829e4682f523ac2f [^]
2018-01-25 11:27marvintmStatusresolved => closed
2018-01-25 11:27marvintmFixed in Version => RR18Q1

Notes
(0101860)
hgbot   
2018-01-22 19:41   
Repository: retail/backports/3.0RR18Q1/org.openbravo.retail.posterminal
Changeset: ed3ac66e7b1f35c2d0fb98c8829e4682f523ac2f
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Dec 26 11:44:54 2017 -0500
URL: http://code.openbravo.com/retail/backports/3.0RR18Q1/org.openbravo.retail.posterminal/rev/ed3ac66e7b1f35c2d0fb98c8829e4682f523ac2f [^]

Fixed issue 37678: Error in module script UpdateCashupReport because name column
has 60 chars length

---
M build/classes/org/openbravo/retail/posterminal/modulescript/UpdateCashupReportData.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql
---