ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SQLSTATE 24502

Post new topic  Reply to topic
 SQLSTATE 24502 « View previous topic :: View next topic » 
Author Message
tenacious
PostPosted: Thu May 12, 2005 1:31 pm    Post subject: SQLSTATE 24502 Reply with quote

Newbie

Joined: 21 Jan 2005
Posts: 6
We have an existing application using mqi 2.1.
The execute node contains passthru sql.
When we pass parameters in so that the result set of the sql contains 32 records, the flow works correctly, meaning the messages are placed on the output queue.

When the result set contains 48 records, we see the SQLSTATE 24502 error.
Database error: SQL State '24502'; Native Error Code '-502'; Error Text '[IBM][CLI Driver][DB2/6000] SQL0502N The cursor specified in an OPEN statement is already open. SQLSTATE=24502


It doesn't seem to matter the order we run.... for ex:
reboot the machine
run the 48 record query ----> sqlerror
run the 32 record query ----> successful
run the 48 record query -----> sqlerror

Has anyone seen this error ?
Any help would be appreciated.
Back to top
View user's profile Send private message
JT
PostPosted: Thu May 12, 2005 3:48 pm    Post subject: Reply with quote

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
Post the SQL statement as it appears in your code.
Back to top
View user's profile Send private message
Ian
PostPosted: Fri May 13, 2005 5:03 am    Post subject: Reply with quote

Disciple

Joined: 22 Nov 2002
Posts: 152
Location: London, UK
Quote:

Database error: SQL State '24502'; Native Error Code '-502'; Error Text '[IBM][CLI Driver][DB2/6000] SQL0502N The cursor specified in an OPEN statement is already open. SQLSTATE=24502


The error message here would suggest to me that you are calling a stored procedure to return a result set.

Please post the WMQI ESQL statement (and stored procedure ?) so that we have more information with which to make comment.
_________________
Regards, Ian
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SQLSTATE 24502
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.