0038423: error executing module script UpdateCashupReport when there are transactions with decription lenght higher than 60

Description

when there are transactions related with cashups, with description length higher than 60, the module script:

org.openbravo.retail.posterminal/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport

is returning one error:

value too long for type character varying(60) [java
] 212844 ERROR - Error executing moduleScript org.openbravo.retail.posterminal.
modulescript.UpdateCashupReport: @CODE=0@ERROR: value too long for type character varying(60)

Steps To Reproduce

in previous release (for example, 16q4), update one transaction related with a cashup and gl item, increasing the description text to long description (more than 60 chars), and update to 17Q2 or higher

Proposed Solution

see diff attached

Tags

No tags attached.

Attached Files

fixIssue.diff [^] (721 bytes) 2018-04-20 15:09 [Show Content] [Hide Content]

diff --git a/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql b/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql
--- a/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql
+++ b/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/UpdateCashupReport_data.xsql
@@ -70,7 +70,7 @@
         '100',
         'Y',
         cashup.obpos_paymentmethodcashup_id,
-        trans.description,
+        substr(trans.description, 1, 60) as description,
         cashup.rate,
         cashup.isocode,
         abs(coalesce(trans.depositamt - trans.paymentamt,0)),

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0037543

closed

rqueralta

Error in module script UpdateCashupReport because name column has 60 chars length

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2018-04-20 15:09	malsasua	New Issue
2018-04-20 15:09	malsasua	Assigned To	=> Retail
2018-04-20 15:09	malsasua	File Added: fixIssue.diff
2018-04-20 15:09	malsasua	OBNetwork customer	=> Yes
2018-04-20 15:09	malsasua	Resolution time	=> 1525989600
2018-04-20 15:09	malsasua	Triggers an Emergency Pack	=> No
2018-04-25 08:36	ranjith_qualiantech_com	Relationship added	duplicate of 0037543
2018-05-10 22:08	rqueralta	Assigned To	Retail => rqueralta
2018-05-10 22:09	rqueralta	Status	new => scheduled
2018-05-14 09:06	marvintm	Review Assigned To	=> marvintm
2018-05-14 09:06	marvintm	Status	scheduled => closed
2018-05-14 09:06	marvintm	Resolution	open => duplicate