tracker issue : CF-3179303

select a category, or use search below
(searches all categories and all time range)

cfbdinfo does not close recordsets

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Matt Fox / Matt Fox (mattfox78)

Created: 05/01/2012

Components: Database

Versions: 9.0.1

Failure Type: Crash

Found In Build/Fixed In Build: 9.0.1 /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 0

Problem Description: cfbdinfo does not close recordsets

Steps to Reproduce:  repeatedly execute cfbdinfo calls against an IBM iSeries 7.1 DB2 database.  In our test setup this took about 1700 executions

Actual Result: "Error Executing Database Query.[SQL7049] An internal object limit has been exceeded" in the application logs

Expected Result: no error

Any Workarounds: not use cfbdinfo tag

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3179303

External Customer Info:
External Company:  
External Customer Name: mattfox78
External Customer Email:  
External Test Config: My Hardware and Environment details: Windows 2008 IIS7 CF9.01 connecting to IBM iSeries 7.1 DB2 database



Stack traces performed on the JDBC driver reveal stored prco calls to get schema information is not closing result sets when using the AS400JDBCDataBaseMetaData class getter methods. For instance when using the methods .getTables(), .getColumns(), .getPrimaryKeys(), and .getExternalKeys these methods return a result set. That result set is not closed until the application closes the result set. The SQL7049 error is encountered at some point as there is a limit of 256 open stored procedure result sets in the scope of a connection. The getter methods use stored procedure calls to get the result set so not closing these result sets will eventually encounter the isssue. The more the workload, likely the quicker the application will encounter the issue. The limit of "256 open stored procedure result sets" recently began to be enforced in a recent iSeries 7.1 upgrade.\ Have not tested in CF10 yet, but would guess the problem is still present.
Comment by External U.
19575 | May 01, 2012 12:43:39 PM GMT
Hi Matt, Could you share your datasource(ColdFusion) configuration details ? In the Advance settings of the datasource is "Maintain connections across client requests" checked. (Comment added from ex-user id:gtiwari)
Comment by Adobe D.
19576 | May 08, 2012 05:09:10 AM GMT
Gaurav - Yes the "Maintain connections across client requests" box is checked. Will post the other values of the Advanced settings tomorrow.
Comment by External U.
19577 | May 17, 2012 08:32:55 PM GMT
Is this issue still occurring? By any chance, have you tried it on ColdFusion 10?
Comment by Nimit S.
19578 | February 21, 2014 12:07:06 AM GMT
We have not heard anything back on this issue. Hence, closing this bug. If you are still facing this issue please let us know so that we can re-open this bug.
Comment by Nimit S.
19579 | December 03, 2014 01:41:53 AM GMT