Openbravo Issue Tracking System - Retail Modules
View Issue Details
0037543Retail ModulesWeb POSpublic2017-12-22 11:012018-01-19 10:16
JONHM 
rqueralta 
highmajorsometimes
closedfixed 
5
 
RR18Q2 
marvintm
No
0037543: Error in module script UpdateCashupReport because name column has 60 chars length
There 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.
update 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)
Option 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 [^]
No tags attached.
depends on backport 0037678RR18Q1 closed rqueralta Error in module script UpdateCashupReport because name column has 60 chars length 
depends on backport 0037679RR17Q4.1 closed rqueralta Error in module script UpdateCashupReport because name column has 60 chars length 
depends on backport 0037680RR17Q3.3 closed rqueralta Error in module script UpdateCashupReport because name column has 60 chars length 
has duplicate defect 0038423 closed rqueralta error executing module script UpdateCashupReport when there are transactions with decription lenght higher than 60 
Issue History
2017-12-22 11:01JONHMNew Issue
2017-12-22 11:01JONHMAssigned To => Retail
2017-12-22 11:01JONHMResolution time => 1515711600
2017-12-22 11:01JONHMTriggers an Emergency Pack => No
2017-12-22 11:02JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16492#r16492
2017-12-26 14:31rqueraltaAssigned ToRetail => rqueralta
2017-12-26 14:32rqueraltaStatusnew => scheduled
2018-01-05 15:45hgbotCheckin
2018-01-05 15:45hgbotNote Added: 0101602
2018-01-05 15:45hgbotStatusscheduled => resolved
2018-01-05 15:45hgbotResolutionopen => fixed
2018-01-05 15:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2942fcbbaa9ba592b760e06d204f51add4238d0b [^]
2018-01-09 13:54marvintmReview Assigned To => marvintm
2018-01-09 13:54marvintmStatusresolved => closed
2018-01-09 13:54marvintmFixed in Version => RR18Q2
2018-01-19 10:16marvintmStatusclosed => new
2018-01-19 10:16marvintmResolutionfixed => open
2018-01-19 10:16marvintmFixed in VersionRR18Q2 =>
2018-01-19 10:16marvintmStatusnew => scheduled
2018-01-19 10:16marvintmStatusscheduled => resolved
2018-01-19 10:16marvintmFixed in Version => RR18Q2
2018-01-19 10:16marvintmResolutionopen => fixed
2018-01-19 10:16marvintmStatusresolved => closed
2018-04-25 08:36ranjith_qualiantech_comRelationship addedhas duplicate 0038423

Notes
(0101602)
hgbot   
2018-01-05 15:45   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 2942fcbbaa9ba592b760e06d204f51add4238d0b
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Dec 26 11:44:54 2017 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2942fcbbaa9ba592b760e06d204f51add4238d0b [^]

Fixed issue 37543: 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
---