Ansicht
Dokumentation

03759 - SQL 502: Cursor already open

03759 - SQL 502: Cursor already open

PERFORM Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

SQL 502: Cursor already open

SAPers,

I have encountered a strange short dump. We receive a DBIF_RSQL_SQL_ERROR
when running a stock transport upload program on our application server.
Specifically, we receive a SQL 502 error, specifying "Cursor C0ZVADEK0102060
already open" and listing an API job as the culprit. However, when the same
program is run on our database server, no error occurs.

I don't understand the context of this cursor nor reasons why the system
would be attempting to create a duplicate cursor. The short dump occurs
while processing an include within program ZVADEK01 (a copy of RVADEK01
print control program). Because of this, I understand why the cursor
contains the ZVADEK01 portion of its name, but what about the remainder of
its name? Does it provide clues as to what's happening?

At this point, I did basic stuff such as deleting the SQL package specified
in the trace file, regenerated the ABAP program, etc. Not only did none of
this have an effect, I don't know what to try next. If anyone has
information as to this specific error or general information regarding
cursors, please let me know. Any information is greatly appreciated.

Thanks in advance,
Mike D. Martin
SAP Basis Administrator
AO * SOLA
707-763-9911 x6106
email: <mailto:mmartinZs...>





[Non-text portions of this message have been removed]


Durban Tours - Südafrika Safari

BAL Application Log Documentation   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 1940 Date: 20240329 Time: 084112     sap01-206 ( 4 ms )