Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0037679 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Retail Modules] Web POS | major | sometimes | 2017-12-22 11:01 | 2018-01-25 11:04 | |||
| Reporter | JONHM | View Status | public | |||||
| Assigned To | rqueralta | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR17Q4.1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 3e19851450fa | ||||
| Projection | none | ETA | none | Target Version | RR17Q4.1 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | marvintm | |||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | 49906 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0037679: Error in module script UpdateCashupReport because name column has 60 chars length | |||||||
| Description | 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. | |||||||
| Steps To Reproduce | 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) | |||||||
| Proposed Solution | 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 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0101862) hgbot (developer) 2018-01-22 19:46 |
Repository: retail/backports/3.0RR17Q4.1/org.openbravo.retail.posterminal Changeset: 3e19851450fae679b0ddebfa7411bca82383ffbe 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.0RR17Q4.1/org.openbravo.retail.posterminal/rev/3e19851450fae679b0ddebfa7411bca82383ffbe [^] Fixed issue 37679: 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-01-19 10:16 | marvintm | Type | defect => backport |
| 2018-01-19 10:16 | marvintm | Target Version | => RR17Q4.1 |
| 2018-01-22 19:46 | hgbot | Checkin | |
| 2018-01-22 19:46 | hgbot | Note Added: 0101862 | |
| 2018-01-22 19:46 | hgbot | Status | scheduled => resolved |
| 2018-01-22 19:46 | hgbot | Resolution | open => fixed |
| 2018-01-22 19:46 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2942fcbbaa9ba592b760e06d204f51add4238d0b [^] => http://code.openbravo.com/retail/backports/3.0RR17Q4.1/org.openbravo.retail.posterminal/rev/3e19851450fae679b0ddebfa7411bca82383ffbe [^] |
| 2018-01-25 11:04 | marvintm | Status | resolved => closed |
| 2018-01-25 11:04 | marvintm | Fixed in Version | => RR17Q4.1 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |