QUESTION POSED ON: 28 October 2004
We are running a Delphi application that accesses the iSeries for records. We are now receiving the following error message:
From . :QSQCALL
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 24635
To module . . . . . . . . . : QSQCALL
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 24635
Message . . . . : An internal object limit has been exceeded.
Cause . . . . . : The SQL statement cannot be run successfully because an
Internal object limitation has been encountered. The reason code is 1. The
Operation failed for one of the following reasons: 1 - The maximum number of
Stored procedures with open result sets has been exceeded. 2 - An internal
Space limitation has been reached while processing result sets. Recovery .
. . : The reason codes and their recovery follow: 1 - Either fetch a
Result set or close an open result set for a stored procedure. 2 - Fetch or
Close one or more open result sets, or reduce the size of the array result set.
Any ideas on how to fix this will be greatly appreciated.
|