0041849: Cannot post a document if it has a customized SQL description that returns more than one record

Description

Cannot post a document if it has a customized SQL description that returns more than one record

Steps To Reproduce

Install the 18Q3.5 version
As System Admin role:
   Create a new template for exporting the changes made to core
   Set as Displayed the SQL Description field of Active Tables tab of General Ledger Configuration window
   Export the changes to the template

As group admin role:
   Set the following SQL Description to the Invoice table of 'F&B España, S.A. US/A/Euro' configuration:

select 'Order Document Number: ' || o.documentno || ' ,'
from c_order o, c_invoice i
where i.c_order_id = o.c_order_id
and i.c_invoice_id = @RecordId@
UNION
select 'Invoice Document Number: ' || documentno || ' '
from c_invoice
where c_invoice_id = @RecordId@

   Create a Sales Order:
      Document Type: POS Order
   Add a product with stock and complete it
   Go to Sales Invoice window and post the created invoice
   Check its description. It concatenates the result of the two queries

Upgrade the instance to a version which includes the fix of 40523 issue (18Q4.4, 19Q.1 or higher)

As group admin role:
   Go to Sales Invoice window and unpost the created invoice
   Try to post it and check it finishes with the following error:
      Process failed during execution
   The log shows:
org.openbravo.erpCommon.ad_forms.AcctServer - AcctServer - postCommitjavax.servlet.ServletException: @CODE=@query did not return a unique result: 2

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0041848

closed

markmm82

Cannot post a document if it has a customized SQL description that returns more than one record

Notes
(0114673) hgbot (developer) 2019-09-19 18:26	Repository: erp/backports/3.0PR19Q3.1 Changeset: 45f5100585a83a86bfdf8673430dd0f9d9600fcf Author: Mark Molina <mark.molina <at> doceleguas.com> Date: Wed Sep 18 21:49:30 2019 -0300 URL: http://code.openbravo.com/erp/backports/3.0PR19Q3.1/rev/45f5100585a83a86bfdf8673430dd0f9d9600fcf [^] Fix for issue 41849: Cannot post a document if it has customized SQL description that returns more than one record. When the customized SQL description returned more than one record, an exception was thrown because the query was executed expecting an unique result. Now is executed with getResultList and all the resultant descriptions are append to the description. --- M src/org/openbravo/erpCommon/ad_forms/FactLine.java ---

(0114676) Sandrahuguet (developer) 2019-09-19 18:28	code review + testing ok

Issue History
Date Modified	Username	Field	Change
2019-09-18 15:39	Sandrahuguet	Type	defect => backport
2019-09-18 15:39	Sandrahuguet	Target Version	=> 3.0PR19Q3.2
2019-09-19 08:00	Sandrahuguet	Target Version	3.0PR19Q3.2 => 3.0PR19Q3.1
2019-09-19 18:26	hgbot	Checkin
2019-09-19 18:26	hgbot	Note Added: 0114673
2019-09-19 18:28	Sandrahuguet	Status	scheduled => resolved
2019-09-19 18:28	Sandrahuguet	Fixed in Version	=> 3.0PR19Q3.1
2019-09-19 18:28	Sandrahuguet	Fixed in SCM revision	=> https://code.openbravo.com/erp/backports/3.0PR19Q3.1/rev/45f5100585a83a86bfdf8673430dd0f9d9600fcf [^]
2019-09-19 18:28	Sandrahuguet	Resolution	open => fixed
2019-09-19 18:28	Sandrahuguet	Review Assigned To	=> Sandrahuguet
2019-09-19 18:28	Sandrahuguet	Note Added: 0114676
2019-09-19 18:28	Sandrahuguet	Status	resolved => closed