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.
The message indicated that you probably connect Delphi and call a stored procedure to get the records (rather then using direct SQL ).
If this is the case, the stored procedure will need to be compiled differently with activation group set to *caller.
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
Dig Deeper on FTP
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.