Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2019-09-18 15:012019-09-19 18:28
ReporterngarciaView Statuspublic 
Assigned Tomarkmm82 
PriorityimmediateResolutionfixedFixed in Version3.0PR19Q2.3
StatusclosedFix in branchFixed in SCM revisiond1654ee5a5a6
ProjectionnoneETAnoneTarget Version3.0PR19Q2.3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
Regression level
Regression date2019-05-03
Regression introduced in release3.0PR19Q3
Regression introduced by commit [^]
Triggers an Emergency PackNo

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

DescriptionCannot post a document if it has a customized SQL description that returns more than one record
Steps To ReproduceInstall 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@
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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0041848 closedmarkmm82 Cannot post a document if it has a customized SQL description that returns more than one record 

-  Notes
hgbot (developer)
2019-09-19 18:26

Repository: erp/backports/3.0PR19Q2.3
Changeset: d1654ee5a5a63480995b1d74a31c7779c1227a75
Author: Mark Molina <mark.molina <at>>
Date: Wed Sep 18 21:47:53 2019 -0300
URL: [^]

Fix for issue 41850: 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/
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.0PR19Q2.3
2019-09-19 18:26 hgbot Checkin
2019-09-19 18:26 hgbot Note Added: 0114674
2019-09-19 18:28 Sandrahuguet Status scheduled => resolved
2019-09-19 18:28 Sandrahuguet Fixed in Version => 3.0PR19Q2.3
2019-09-19 18:28 Sandrahuguet Fixed in SCM revision => [^]
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: 0114677
2019-09-19 18:28 Sandrahuguet Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker