473,612 Members | 2,129 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help for error: DRDA Application Requester, sqljrParseMrspR eply2

1 New Member
Hi,

I have Java application running on Websphere Application Server 6.0 This application connects to Mainframe DB2 using CLI type 2 driver. The application uses websphere connection pool mechanism.

I have stored procedures which are called from the application and one particular stored procedure call throws the below error:

SystemErr R SQL exception: com.ibm.websphe re.ce.cm.StaleC onnectionExcept ion: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003

SystemErr R Exception occurred in CodeServlet.per formTaskFind: java.rmi.Server Exception: RemoteException occurred in server thread; nested exception is:
java.rmi.Remote Exception: ; nested exception is:
java.lang.Error : Illegal ConnectO state: DESTROYED




Before the above errors seen on SystemErr, I see the db2 logs have the below trace.

2007-01-25-09.31.52.093982 Instance:db2 Node:000
PID:123456(java ) TID:3195 Appid:GAE02875. C8FA
DRDA Application Requester sqljrParseMrspR eply2 Probe:150 ADM2503C A datastream parsing error has been detected. A dump has been
generated.

2007-01-25-09.31.52.141257-480 I265922C348 LEVEL: Error
PID : 712746 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
APPID : GAE02875.C8FA
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrParseMrspR eply2, probe:150
RETCODE:ZRC=0x8 037008D=-2143879027=SQLJ R_SYNTAX "SYNTAX ERROR"
2007-01-25-09.31.52.160111-480 I266271C642 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
APPID : GAE02875
DATA #1 : SQLCA, PD_DB2_TYPE_SQL CA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 17
sqlerrmc: 0x124C"("0100") "
sqlerrp : sqljrexr
sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2007-01-25-09.31.52.160270-480 I266914C172 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
APPID : GAE02875.C8FA
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:22
MESSAGE : Attempted to free NULL pointer.
CALLSTCK:
[0] 0xD3104E94 sqlofmblkEx + 0x8E4
[1] 0xD2CDFAEC sqljrFreeMrspOb jects__FP18db2U CRtnResSetInfo + 0x98
[2] 0xD30A3048 sqljrParseMrspR eply2__FP7UCint fcUsP19SQLJR_CU RSORPIDLIST + 0xD94
[3] 0xD30A02A8 sqljrParseExecu teReply__FP7UCi ntfc + 0x4720
[4] 0xD3060138 sqljrParse__FP7 UCintfc + 0x1C4
[5] 0xD3011ED8 sqljrDrdaArExec ute__FP7UCintfc P9UCstpInfo + 0x830
[6] 0xD2D793E0 CLI_sqlCallProc edure__FP17CLI_ STATEMENTINFOP1 9CLI_ERRORHEADE RINFO + 0x320
[7] 0xD2D959CC SQLExecute2__FP 17CLI_STATEMENT INFOP19CLI_ERRO RHEADERINFO + 0xE48
[8] 0xD2D933F8 SQLExecute + 0xBC8
[9] 0xD0B2E760 ?unknown + 0xFFFFFFE7


I have checked the parameters sent to stored procedure and everything is correct.I do not have this problem on a development server but the issue is in only a User Acceptance test server.

Any help would be greatly appreciated.

Thanks
Jan 26 '07 #1
0 2439

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2149
by: xixi | last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. such error generated , please help me understand this , thanks 2004-01-12-14.09.02.400000 Instance:DB2 Node:000 PID:1788(db2syscs.exe) TID:980 Appid:none DRDA Application Server sqljsCleanup Probe:60 DIA0001E An internal error occurred. Report the following error code : "ZRC=0xFFFFFBF6".
0
2055
by: Hemant Shah | last post by:
Folks, I have DB2 UDB 7.2 EE installed on AIX 5.2 system. I think I am at latest fixpack, see output of lslpp below. I have also installed DB2 UDB 7.2 EE on RedHat Linux 7.3 I believe that is also at the latest fix pack, see rpm output below. The database is on AIX system and on the Linux system it is cataloged as remote database.
1
4233
by: Rohit Raghuwanshi | last post by:
Hello all, we are running a delphi application with DB2 V8.01 which is causing deadlocks when rows are being inserted into a table. Attaching the Event Monitor Log (DEADLOCKS WITH DETAILS) here. From the log it looks like the problem happens when 2 threads insert 1 record each in the same table and then try to aquire a NS (Next Key Share) lock on the record inserterd by the other thread. Thanks Rohit
2
5554
by: Mike | last post by:
Greetings, Having a major problem here. running version 8.2 on win2003 server. The problem I am having is backing up a database seems to get to the last part of the backup and then fails. This brings the whole instance down and it has to be restarted. In addition the job seems to be stuck in the TOOLSDB as if I try to delete the backup job I get "The task is currently running". So I went to the command line and tried "db2 backup database...
1
9701
by: Raquel | last post by:
This is a stored procedure that resides on Mainframe and gets executed on the client by connecting to the mainframe through DB2 connect. It was executing fine till yesterday when I executed a table change and successfully Rebound the package associated with the stored procedure. Since then, it is giving a strange problem. When the client executes the program that calls the stored procedure SP1, the stored procedure does not get executed...
6
9621
by: p175 | last post by:
2006-08-14-17.46.13.656000-240 I1472H436 LEVEL: Warning PID : 1452 TID : 336 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SQ4V6 APPHDL : 0-9 APPID: *LOCAL.DB2.060814214011 AUTHID : DB2ADMIN FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, probe:2089 MESSAGE : Unable to find donor to satisfy minSize constraint Does...
8
2084
by: joe.weinstein | last post by:
Hi, and thanks in advance. I am reading documentation for a JDBC driver which uses DRDA to talk to DB2, but seems to imply that some DB2 installations/configurations might make DRDA access optional. Joe Weinstein at BEA Systems
0
3955
by: zhif | last post by:
I checked db2diag.log. There are the following two kinds of error messages (I) 2007-04-09-14.23.06.313673-240 I50090C517 LEVEL: Error PID : 54008 TID : 1 PROC : db2agentg (HAMDB2 ) 0 INSTANCE: db2inst1 NODE : 000 DB : CAT_DWGS APPHDL : 0-604 APPID: CF82B7D0.C6B9.070409152519 FUNCTION: DB2 UDB, DRDA Application...
1
6482
by: matias.cornejo | last post by:
I was looking de db2diag.log (DB2 V7, AIX) and I have this error and It's creating every 5 minutes the file .000 PID:312050(db2agent (idle)) Appid:none drda_as sqljp_ddm_dict_search Pdrobe:413 Error DIA5000C A DRDA as Token "RECOVERABLE" was detected. The diagnostic data returned is (SRVDGN) : FUNCTION ID = 0144 , PROBE POINT = 0413, REASON CODE = 0x0200000F, RETURN CODE 1 = 0x0000C200, RETURN CODE 2 = 0x00000000,
0
8162
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8605
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8565
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8246
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5532
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4045
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4109
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2550
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1695
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.