Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
0037458Openbravo LocalizationsLocalization Mexicopublic2017-12-12 10:222017-12-14 09:02
0037458: [Contabilidad en Medios Electronicos]: length of variables in conele_docnum_trg should be defined relative to fact_acct columns
[Contabilidad en Medios Electronicos]: size of variables in conele_docnum_trg should be defined relative to fact_acct columns.

Thus, if a user increases the size of a column, the variable could save its value
As system admin role:
   Increase the length of the following columns:

   Create a business partner and add a name longer than 60 characters
   Create a sales invoice for that business partner
   Try to post it and check the following error message is shown:
      "Process failed during execution"

   The log shows:
      ERROR org.openbravo.erpCommon.ad_forms.FactLineData - SQL error in query: INSERT INTO Fact_Acct ...
Exception:org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60) Where: PL/pgSQL function conele_docnum_trg() line 115 at SQL statement
No tags attached.
Issue History
2017-12-12 10:22ngarciaNew Issue
2017-12-12 10:22ngarciaAssigned To => tegik_forge
2017-12-12 17:12psanjuanNote Added: 0101001
2017-12-12 17:22ngarciaIssue Monitored: networkb
2017-12-14 09:02psanjuanNote Added: 0101030
2017-12-14 09:02psanjuanStatusnew => scheduled
2017-12-14 09:02psanjuanStatusscheduled => resolved
2017-12-14 09:03psanjuanNote Edited: 0101030bug_revision_view_page.php?bugnote_id=0101030#r16435

2017-12-12 17:12   
issue reported in Tegik support tool as: [^]
2017-12-14 09:02   
(edited on: 2017-12-14 09:03)
Module updated with the fix of this issue. Install version 1.5.8 [^]