Ansicht
Dokumentation
05176 - SQL 502 Cursor already open 4.6C V4R5
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL Application Log DocumentationThis documentation is copyright by SAP AG.
SQL 502 Cursor already open 4.6C V4R5
Mike & Volker & GroupWe'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
TXBHW - Original Tax Base Amount in Local Currency rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by SAP AG.
Length: 3030 Date: 20240426 Time: 213553 sap01-206 ( 2 ms )