Dear All,
In our multi-threaded Red Hat Linux (Version 7.1) based application, We declare static
cursors with equal condition in where clause. While fetching data from database using
these cursors, our application dumps core in FETCH statements frequently.
We enabled the precompiler trace ( long trace ) for our application and found
that, "SQLCODE: -602 System error: AK Datapart too short" error in precompiler
trace file for FETCH statements. For some Fetch statement, mfIndex init is negative (
mfIndex init : -32757 ) and in such cases, our application dumps core and we have
"ERR -11607 COMMUNIC sql03_receive: illegal reference: 0" error logged in appldiag
file.
For the above mentioned communication and system error, SAPDB error messages
pdf file says that the database is in inconsistent state and we have to shutdown the
database and contact the SAP LABS. This is happening in our client place. So please
help us to solve the problem.
The stack entries from the core dump is as follows:
gdb output of core:
#0 0x0821d234 in p01bmfentryadd ()
#1 0x0821b8bf in p01baparsen ()
#2 0x08205ef3 in pr01cParse ()
#3 0x0820552a in pr01cEnd ()
#4 0x0820c0fc in pr01SQLExecute ()
#5 0x0820a03c in pr01PrecomExecute ()
#6 0x08202b7f in sqlCPCExecute ()
When we went a little deeper, we found that the "p04trint2" function is
causing the
problem. Is there a problem with this function in SAPDB? If so, do we have any
workaround for this?
Moreover, Can anyone help us on the following :
1. What is the Maximum limit for FETCH statements that can be executed in a
single connection?
2. What is the Meaning of mfIndex init variable used in precompiler trace ?
3. In which case will we get "System error: AK Datapart too short" and
"COMMUNIC sql03_receive: illegal reference: 0" error ?
Can any one throw some light please ?
Regards
Chandar
____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
