Ansicht
Dokumentation
03765 - SQL 502: Cursor already open
General Data in Customer Master Addresses (Business Address Services)This documentation is copyright by SAP AG.
SQL 502: Cursor already open
Hello Mike,I don't know your release, but as of 4.5A the kernel and the DBSL (database
system layer) are to be patched seperately. So you have to install the patch
for KERNEL and for LIB_DBSL. You should go to the latest patches and retry.
It's really interesting, that it work s 2-tier and fails 3-tier. The name of
the cursor is created in the DBSL and is "quite normal". When the SQL0502
occurs, either the DBSL made an error or the DB2/400 made an error. That is
mostly hard to detect. As your problem seems to be reproducible (hopefully
not only after hours or days running!), you should open an OSS ticket when
it still persists with the latest pateches on the SAP site and the PTFs on
the IBM site. Then we would have to analyze whether realy 2 cursors of this
name were opened within the same commit boundary or they if they were opened
with "with hold" in order to survive a commit (=> SAP error) or if this was
not the case (=>IBM-error).
Regards
Volker
Durban Tours - Südafrika Safari
ROGBILLS - Synchronize billing plans General Material Data
This documentation is copyright by SAP AG.
Length: 1422 Date: 20240420 Time: 100724 sap01-206 ( 2 ms )
