Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0022373 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Localization Pack: Spain] AEAT 349 | major | always | 2012-11-22 10:23 | 2013-03-04 13:07 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | ioritzCia | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | c9665f245aad | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Support ticket | ||||||||
| OBNetwork customer | OBPS | |||||||
| Regression introduced in release | ||||||||
| Summary | 0022373: Cursors are not closed when when using 349 report | |||||||
| Description | Cursors 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  | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
		  Relationships		[ Relation Graph ] 
		[ Dependency Graph ] 
			 | 
|||||||||
  | 
|||||||||
  		Notes	 | 
|
| 
				(0054450) hgbot (developer) 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 ---  | 
  Issue History	 | 
|||
| Date Modified | Username | Field | Change | 
| 2012-11-22 10:23 | egoitz | New Issue | |
| 2012-11-22 10:23 | egoitz | Assigned To | => ioritzCia | 
| 2012-11-22 10:23 | egoitz | OBNetwork customer | => Yes | 
| 2012-11-22 10:23 | egoitz | Relationship added | related to 0022366 | 
| 2012-11-22 10:42 | hgbot | Checkin | |
| 2012-11-22 10:42 | hgbot | Note Added: 0054450 | |
| 2012-11-22 10:42 | hgbot | Status | new => resolved | 
| 2012-11-22 10:42 | hgbot | Resolution | open => fixed | 
| 2012-11-22 10:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/c9665f245aadf642157246063af721ee21757589 [^] | 
| 2012-11-22 13:27 | ioritzCia | Tag Attached: Performance | |
| 2013-03-04 13:07 | jonalegriaesarte | Status | resolved => closed | 
| Copyright © 2000 - 2009 MantisBT Group |