471,122 Members | 1,656 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Help for error: DRDA Application Requester, sqljrParseMrspReply2


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.websphere.ce.cm.StaleConnectionException: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003

SystemErr R Exception occurred in CodeServlet.performTaskFind: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; 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- Instance:db2 Node:000
PID:123456(java) TID:3195 Appid:GAE02875.C8FA
DRDA Application Requester sqljrParseMrspReply2 Probe:150 ADM2503C A datastream parsing error has been detected. A dump has been

2007-01-25- I265922C348 LEVEL: Error
PID : 712746 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrParseMrspReply2, probe:150
2007-01-25- I266271C642 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
APPID : GAE02875
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 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)

2007-01-25- I266914C172 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:22
MESSAGE : Attempted to free NULL pointer.
[0] 0xD3104E94 sqlofmblkEx + 0x8E4
[1] 0xD2CDFAEC sqljrFreeMrspObjects__FP18db2UCRtnResSetInfo + 0x98
[2] 0xD30A3048 sqljrParseMrspReply2__FP7UCintfcUsP19SQLJR_CURSORP IDLIST + 0xD94
[3] 0xD30A02A8 sqljrParseExecuteReply__FP7UCintfc + 0x4720
[4] 0xD3060138 sqljrParse__FP7UCintfc + 0x1C4
[5] 0xD3011ED8 sqljrDrdaArExecute__FP7UCintfcP9UCstpInfo + 0x830
[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.

Jan 26 '07 #1
0 2257

Post your reply

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

Similar topics

reply views Thread by xixi | last post: by
reply views Thread by Hemant Shah | last post: by
2 posts views Thread by Mike | last post: by
1 post views Thread by Raquel | last post: by
6 posts views Thread by p175 | last post: by
8 posts views Thread by joe.weinstein | last post: by

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.