Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022366Openbravo ERP09. Financial managementpublic2012-11-21 12:422012-11-22 18:03
Reporteregoitz 
Assigned ToioritzCia 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP16 
Target Version3.0MP18Fixed in Version 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022366: The multidimensional tax report does not close connection on oracle.
DescriptionThe multidimensional tax report does not close connection on oracle.
After execute the report having data on the result many cursors are not closed.
Steps To Reproduce-Execute the following query at oracle:
SELECT sql_text, COUNT(*)
  FROM v$open_cursor
 GROUP BY sql_text
 ORDER BY COUNT(*) DESC;
-Execute the multidimensional tax report, to get data on the result.
-Execute again the query:
SELECT sql_text, COUNT(*)
  FROM v$open_cursor
 GROUP BY sql_text
 ORDER BY COUNT(*) DESC;

See that there are many open_cusors for the following statement:

SELECT C_CURRENCY_CONVERT(:1 , :2 , :3 , :4 , NULL, :5 ) FRO


Proposed SolutionClose the prepared statemente.
Additional Information
TagsPerformance
Relationships
related to defect 0022368 closed ioritzCia Openbravo ERP UIDefinition has a not closed PreparedStatement 
related to defect 0022372 closed ioritzCia Openbravo ERP Not closed PreparedStatment. 
related to defect 0022373 closed ioritzCia Localization Pack: Spain Cursors are not closed when when using 349 report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-11-21 12:42egoitzNew Issue
2012-11-21 12:42egoitzAssigned To => ioritzCia
2012-11-21 12:42egoitzModules => Core
2012-11-21 12:42egoitzOBNetwork customer => Yes
2012-11-21 17:01ioritzCiaRelationship addedrelated to 0022368
2012-11-21 17:15hgbotCheckin
2012-11-21 17:15hgbotNote Added: 0054432
2012-11-21 17:15hgbotStatusnew => resolved
2012-11-21 17:15hgbotResolutionopen => fixed
2012-11-21 17:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/41823da572dd7bcaa9a89f6f94d4aa7b0f68b2c2 [^]
2012-11-22 10:18ioritzCiaRelationship addedrelated to 0022372
2012-11-22 10:23egoitzRelationship addedrelated to 0022373
2012-11-22 13:27ioritzCiaTag Attached: Performance
2012-11-22 18:03egoitzReview Assigned To => egoitz
2012-11-22 18:03egoitzNote Added: 0054462
2012-11-22 18:03egoitzStatusresolved => closed

Notes
(0054432)
hgbot   
2012-11-21 17:15   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 41823da572dd7bcaa9a89f6f94d4aa7b0f68b2c2
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Nov 21 17:02:26 2012 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/41823da572dd7bcaa9a89f6f94d4aa7b0f68b2c2 [^]

Fixes issue 22366: The report does not close connection on oracle.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/utility/Utility.java
---
(0054462)
egoitz   
2012-11-22 18:03   
verified