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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037680
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajorsometimes2017-12-22 11:012018-01-25 11:07
ReporterJONHMView Statuspublic 
Assigned Torqueralta 
PriorityhighResolutionfixedFixed in VersionRR17Q3.3
StatusclosedFix in branchFixed in SCM revision30ee68f47d5b
ProjectionnoneETAnoneTarget VersionRR17Q3.3
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

0037680: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0037543 closedrqueralta Error in module script UpdateCashupReport because name column has 60 chars length 

-  Notes
(0101864)
hgbot (developer)
2018-01-22 19:48

Repository: retail/backports/3.0RR17Q3.3/org.openbravo.retail.posterminal
Changeset: 30ee68f47d5b4291542d7358afa3b5ba4aebab60
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.0RR17Q3.3/org.openbravo.retail.posterminal/rev/30ee68f47d5b4291542d7358afa3b5ba4aebab60 [^]

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

- Issue History
Date Modified Username Field Change
2018-01-19 10:16 marvintm Type defect => backport
2018-01-19 10:16 marvintm Target Version => RR17Q3.3
2018-01-22 19:48 hgbot Checkin
2018-01-22 19:48 hgbot Note Added: 0101864
2018-01-22 19:48 hgbot Status scheduled => resolved
2018-01-22 19:48 hgbot Resolution open => fixed
2018-01-22 19:48 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2942fcbbaa9ba592b760e06d204f51add4238d0b [^] => http://code.openbravo.com/retail/backports/3.0RR17Q3.3/org.openbravo.retail.posterminal/rev/30ee68f47d5b4291542d7358afa3b5ba4aebab60 [^]
2018-01-25 11:07 marvintm Status resolved => closed
2018-01-25 11:07 marvintm Fixed in Version => RR17Q3.3


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker