Q
Problem solve Get help with specific problems with your technologies, process and projects.

Delphi application error

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.


This was last published in October 2004

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close