Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022373Localization Pack: SpainAEAT 349public2012-11-22 10:232013-03-04 13:07
Reporteregoitz 
Assigned ToioritzCia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary0022373: Cursors are not closed when when using 349 report
DescriptionCursors are not closed when when using 349 report
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 349 report
-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 Solution
Additional Information
TagsPerformance
Relationships
related to defect 00223663.0MP18 closed ioritzCia Openbravo ERP The multidimensional tax report does not close connection on oracle. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-11-22 10:23egoitzNew Issue
2012-11-22 10:23egoitzAssigned To => ioritzCia
2012-11-22 10:23egoitzOBNetwork customer => Yes
2012-11-22 10:23egoitzRelationship addedrelated to 0022366
2012-11-22 10:42hgbotCheckin
2012-11-22 10:42hgbotNote Added: 0054450
2012-11-22 10:42hgbotStatusnew => resolved
2012-11-22 10:42hgbotResolutionopen => fixed
2012-11-22 10:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/c9665f245aadf642157246063af721ee21757589 [^]
2012-11-22 13:27ioritzCiaTag Attached: Performance
2013-03-04 13:07jonalegriaesarteStatusresolved => closed

Notes
(0054450)
hgbot   
2012-11-22 10:42   
Repository: erp/pmods/org.openbravo.module.aeat349.es
Changeset: c9665f245aadf642157246063af721ee21757589
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Nov 22 10:39:10 2012 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/c9665f245aadf642157246063af721ee21757589 [^]

Fixes issue 22373: Cursors are not closed when using 349 report.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java
M src/org/openbravo/module/aeat349/es/AEAT349ReportDao.java
---