Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0022366 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | critical | always | 2012-11-21 12:42 | 2012-11-22 18:03 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | ioritzCia | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 41823da572dd | ||||
| Projection | none | ETA | none | Target Version | 3.0MP18 | |||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP16 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | egoitz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0022366: The multidimensional tax report does not close connection on oracle. | |||||||
| Description | The 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 Solution | Close the prepared statemente. | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0054432) hgbot (developer) 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 (viewer) 2012-11-22 18:03 |
verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-11-21 12:42 | egoitz | New Issue | |
| 2012-11-21 12:42 | egoitz | Assigned To | => ioritzCia |
| 2012-11-21 12:42 | egoitz | Modules | => Core |
| 2012-11-21 12:42 | egoitz | OBNetwork customer | => Yes |
| 2012-11-21 17:01 | ioritzCia | Relationship added | related to 0022368 |
| 2012-11-21 17:15 | hgbot | Checkin | |
| 2012-11-21 17:15 | hgbot | Note Added: 0054432 | |
| 2012-11-21 17:15 | hgbot | Status | new => resolved |
| 2012-11-21 17:15 | hgbot | Resolution | open => fixed |
| 2012-11-21 17:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/41823da572dd7bcaa9a89f6f94d4aa7b0f68b2c2 [^] |
| 2012-11-22 10:18 | ioritzCia | Relationship added | related to 0022372 |
| 2012-11-22 10:23 | egoitz | Relationship added | related to 0022373 |
| 2012-11-22 13:27 | ioritzCia | Tag Attached: Performance | |
| 2012-11-22 18:03 | egoitz | Review Assigned To | => egoitz |
| 2012-11-22 18:03 | egoitz | Note Added: 0054462 | |
| 2012-11-22 18:03 | egoitz | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |