Ansicht
Dokumentation

05176 - SQL 502 Cursor already open 4.6C V4R5

05176 - SQL 502 Cursor already open 4.6C V4R5

Vendor Master (General Section)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

SQL 502 Cursor already open 4.6C V4R5

Mike & Volker & Group



We've had a SQL 502 problem for months that I was hoping would fix
itself.....wishful thinking

Anyway, it's time to tackle this issue & get rid of it



We've gathered all the SRVJOB; DBG; DEV trace; joblog data for the problem
(using that cool RSTRC000 program)

- In the joblog; we see the cursor was already opened

- In the joblog; we see a COMMIT between the 2 opens

- In the DEV trace; it shows WITHHOLD=NO



What is the next step on this?



Can see that STDCSRN00019 is opened twice in the joblog

02/22/02 15:16:54 QSQOPEN QSYS (PAGE 2815 OF JOBLOG)

From module . . . . . . . . : QSQOPEN

From procedure . . . . . . : CLEANUP

Statement . . . . . . . . . : 17409

To module . . . . . . . . . : QSQOPEN

To procedure . . . . . . . : CLEANUP

Statement . . . . . . . . . : 17409

Message . . . . : Cursor STDCSRN00019 opened.



02/22/02 15:16:56 QSQROUTE QSYS (PAGE 2906 OF JOBLOG)

From module . . . . . . . . : QSQCLNUP

From procedure . . . . . . : SQROUTE_CLEANUP

Statement . . . . . . . . . : 2631

To module . . . . . . . . . : QSQCLNUP

To procedure . . . . . . . : SQROUTE_CLEANUP

Statement . . . . . . . . . : 2631

Message . . . . : Commit completed.



02/22/02 15:16:56 QSQOPEN QSYS (PAGE 2907 OF JOBLOG)

From module . . . . . . . . : QSQOPEN

From procedure . . . . . . : CLEANUP

Statement . . . . . . . . . : 17409

To module . . . . . . . . . : QSQOPEN

To procedure . . . . . . . : CLEANUP

Statement . . . . . . . . . : 17409

Message . . . . : Cursor STDCSRN00019 already open



Fri Feb 22 15:16:56 2002


*** ERROR => Error -502 in function exec_cached_op


[dbsldb4.cpp 6704]


Cursor name: "STDCSRN00019"


Library name: R3P01X0000


Package name: S503


Statement name: IDNJEBEMEHAFBHIG


withhold: NO


Reopen: FALSE


***LOG BY4=> sql error -502 performing SEL on table S503 [dbtran 6980
]

***LOG BY0=> Cursor STDCSRN00019 already open. Job=436280/P0100/WP01 [dbtran
698





Doreen Anderson

Ball Horticultural Company

dandersoZb...

(630) 231-3600 x3214





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


Durban Tours - Südafrika Safari

BAL Application Log Documentation   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 3030 Date: 20240304 Time: 215125     sap01-206 ( 3 ms )