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

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0037679

Retail Modules

Web POS

public

2017-12-22 11:01

2018-01-25 11:04

Reporter

JONHM

Assigned To

rqueralta

Priority

high

Severity

major

Reproducibility

sometimes

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

RR17Q4.1

Fixed in Version

RR17Q4.1

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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 [^]

Additional Information