Re: Error message CX_SY_OPEN_SQL_DB

former_member1128088 · ‎2012 Dec 03

Hi Guys,

I am getting an error CX_SY_OPEN_SQL_DB with the following ABAP statement

DELETE FROM <dbtab> where f1 = val1.

The ST22 dump says "[ASE Error SQL21]WARNING - Fatal Error 605

occurred at <date, time>. Please note the error and time, and contact a

user with System Administrator (SA) authorization.#"

Does anyone has any clue?

Former Member · ‎2012 Dec 03

Hi,

Can you attach the full dump.

Thanks

Simbhu

former_member1128088 · ‎2012 Dec 03

Category Installation Errors

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 30.11.2012 03:11:21

----------------------------------------------------------------------------------------------------

|Short text |

| SQL error 21 when accessing table "ZPM_NOTIF_IND". |

----------------------------------------------------------------------------------------------------

|What happened? |

| Error Text of the Database: "[ASE Error SQL21]WARNING - Fatal Error 605 |

| occurred at Nov 30 2012 3:11AM. Please note the error and time, and contact a |

| user with System Administrator (SA) authorization.

" |

----------------------------------------------------------------------------------------------------

|What can you do? |

| Note which actions and input led to the error. |

| |

| For further help in handling the problem, contact your SAP administrator |

| . |

| |

| You can use the ABAP dump analysis transaction ST22 to view and manage |

| termination messages, in particular for long term reference. |

| |

| Note which actions and input led to the error. |

| |

| For further help in handling the problem, contact your SAP administrator |

| . |

| |

| You can use the ABAP dump analysis transaction ST22 to view and manage |

| termination messages, in particular for long term reference. |

| |

----------------------------------------------------------------------------------------------------

|Error analysis |

| An exception occurred that is explained in detail below. |

| The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught |

| and |

| therefore caused a runtime error. |

| The reason for the exception is: |

| Error Text of the Database: "[ASE Error SQL21]WARNING - Fatal Error 605 |

| occurred at Nov 30 2012 3:11AM. Please note the error and time, and contact a |

| user with System Administrator (SA) authorization.

" |

----------------------------------------------------------------------------------------------------

|How to correct the error |

| Internal call code.........: "[RSQL/DELE/ZPM_NOTIF_IND ]" |

| Please check the entries in the system log (Transaction SM21). |

| |

| If the error occures in a non-modified SAP program, you may be able to |

| find an interim solution in an SAP Note. |

| If you have access to SAP Notes, carry out a search with the following |

| keywords: |

| |

| "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB" |

| "ZPM_INSP_INDEX" or "ZPM_INSP_INDEX" |

| "START-OF-SELECTION" |

| |

| If you cannot solve the problem yourself and want to send an error |

| notification to SAP, include the following information: |

| |

| 1. The description of the current problem (short dump) |

| |

| To save the description, choose "System->List->Save->Local File |

| (Unconverted)". |

| |

| 2. Corresponding system log |

| |

| Display the system log by calling transaction SM21. |

| Restrict the time interval to 10 minutes before and five minutes |

| after the short dump. Then choose "System->List->Save->Local File |

| (Unconverted)". |

| |

| 3. If the problem occurs in a problem of your own or a modified SAP |

| program: The source code of the program |

| In the editor, choose "Utilities->More |

| Utilities->Upload/Download->Download". |

| |

| 4. Details about the conditions under which the error occurred or which |

| actions and input led to the error. |

| |

| If the error occures in a non-modified SAP program, you may be able to |

| find an interim solution in an SAP Note. |

| If you have access to SAP Notes, carry out a search with the following |

| keywords: |

| |

| "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB" |

| "ZPM_INSP_INDEX" or "ZPM_INSP_INDEX" |

| "START-OF-SELECTION" |

| |

| If you cannot solve the problem yourself and want to send an error |

| notification to SAP, include the following information: |

| |

| 1. The description of the current problem (short dump) |

| |

| To save the description, choose "System->List->Save->Local File |

| (Unconverted)". |

| |

| 2. Corresponding system log |

| |

| Display the system log by calling transaction SM21. |

| Restrict the time interval to 10 minutes before and five minutes |

| after the short dump. Then choose "System->List->Save->Local File |

| (Unconverted)". |

| |

| 3. If the problem occurs in a problem of your own or a modified SAP |

| program: The source code of the program |

| In the editor, choose "Utilities->More |

| Utilities->Upload/Download->Download". |

| |

| 4. Details about the conditions under which the error occurred or which |

| actions and input led to the error. |

| |

----------------------------------------------------------------------------------------------------

|System environment |

| SAP Release..... 702 |

| SAP Basis Level. 0009 |

| |

| Application server... "WSAPPSP105" |

| Network address...... "10.86.80.35" |

| Operating system..... "Windows NT" |

| Release.............. "6.1" |

| Hardware type........ "8x AMD64 Level" |

| Character length.... 16 Bits |

| Pointer length....... 64 Bits |

| Work process number.. 57 |

| Shortdump setting.... "full" |

| |

| Database server... "WSAPPSP100" |

| Database type..... "SYBASE" |

| Database name..... "SP1" |

| Database user ID.. "SAPSR3" |

| |

| Terminal.......... " " |

| |

| Char.set.... "C" |

| |

| SAP kernel....... 720 |

| created (date)... "Sep 13 2012 02:22:44" |

| create on........ "NT 6.0 6002 S x86 MS VC++ 16.00" |

| Database version. "Sybase ASE 15.7.0.107 " |

| |

| Patch level. 316 |

| Patch text.. " " |

| |

| Database............. "15.7" |

| SAP database version. 720 |

| Operating system..... "Windows NT 5.1, Windows NT 5.2, Windows NT 6.0, Windows |

| NT 6.1, Windows NT 6.2" |

| |

| Memory consumption |

| Roll.... 0 |

| EM...... 12569376 |

| Heap.... 0 |

| Page.... 24576 |

| MM Used. 1431856 |

| MM Free. 2755264 |

----------------------------------------------------------------------------------------------------

|User and Transaction |

| Client.............. 900 |

| User................ "PROD_BATCH" |

| Language key........ "E" |

| Transaction......... " " |

| Transaction ID...... "85C53AE2D675F125BFA1005056A46AB3" |

| |

| EPP Whole Context ID.... "005056A46AB31EE28EA01A0524C23FA1" |

| EPP Connection ID....... "005056A46AB31EE28ED8B0A450B1FFA1" |

| EPP Caller Counter...... 1 |

| |

| Program............. "ZPM_INSP_INDEX" |

| Screen.............. "SAPMSSY0 1000" |

| Screen Line......... 6 |

| Debugger Active..... "none" |

----------------------------------------------------------------------------------------------------

|Information on where terminated |

| Termination occurred in the ABAP program "ZPM_INSP_INDEX" - in |

| "START-OF-SELECTION". |

| The main program was "ZPM_INSP_INDEX ". |

| |

| In the source code you have the termination point in line 135 |

| of the (Include) program "ZPM_INSP_INDEX". |

| The program "ZPM_INSP_INDEX" was started as a background job. |

| Job Name....... "AXTPMC2UPD" |

| Job Initiator.. "PROD_CTLM" |

| Job Number..... 03111900 |

----------------------------------------------------------------------------------------------------

|Source Code Extract |

----------------------------------------------------------------------------------------------------

|Line |SourceCde |

----------------------------------------------------------------------------------------------------

| 105| |

| 106| |

| 107|PARAMETERS: |

| 108|p_gjahr TYPE bkpf-gjahr, |

| 109|p_upd AS CHECKBOX, |

| 110|p_clr AS CHECKBOX, |

| 111|eq_ind TYPE zpm_equip_tab-equnr, |

| 112|p_notif LIKE qmel-qmnum, |

| 113|p_tst AS CHECKBOX. |

| 114| |

| 115|START-OF-SELECTION. |

| 116| IF p_gjahr IS INITIAL. |

| 117| p_gjahr = sy-datum(4). |

| 118| ENDIF. |

| 119| |

| 120| DATA: notif_list TYPE zpm_notif_tab OCCURS 0, |

| 121| notif_list_wa TYPE zpm_notif_tab, |

| 122| sel_list_notif TYPE zpm_notif_tab OCCURS 0, |

| 123| data_does_not_exist, |

| 124| data_exist. |

| 125|*---- |

| 126| DATA: existing_recs_s TYPE TABLE OF zpm_notif_ind, |

| 127| existing_recs_s_wa TYPE zpm_notif_ind, |

| 128| zpm_notif_tab_s_wa TYPE zpm_notif_tab, |

| 129| sy_tabix_sav TYPE sy-tabix, |

| 130| existing_recs_se TYPE TABLE OF zpm_notif_inde, |

| 131| existing_recs_se_wa TYPE zpm_notif_inde. |

| 132|*---- All data from Notification index tables will be deleted |

| 133| IF p_upd = 'X' AND p_tst NE 'X'. |

| 134| IF NOT p_gjahr IS INITIAL. |

|>>>>>| DELETE FROM zpm_notif_ind WHERE gjahr = p_gjahr. |

| 136| DELETE FROM zpm_notif_inde WHERE gjahr = p_gjahr. |

| 137| ENDIF. |

| 138| ENDIF. |

| 139|*---- Delete records of equip. B2 |

| 140| IF p_clr = 'X' AND eq_ind IS INITIAL. |

| 141| DELETE FROM zpm_equip_tab. |

| 142| ENDIF. |

| 143|*--- Sh BE DELETED or corrected !!! |

| 144| IF p_clr = 'X' AND NOT eq_ind IS INITIAL. |

| 145| DELETE FROM zpm_equip_tab WHERE equnr = space. |

| 146| ENDIF. |

| 147| |

| 148|*---- Validation if Notification index table |

| 149| SELECT * FROM zpm_notif_ind INTO TABLE existing_recs_s WHERE |

| 150| gjahr = p_gjahr. |

| 151| DESCRIBE TABLE existing_recs_s. |

| 152| IF sy-tfill = 0. |

| 153|*---- INDEX - Empty |

| 154| data_does_not_exist = 'X'. |

----------------------------------------------------------------------------------------------------

|Contents of system fields |

----------------------------------------------------------------------------------------------------

|Name |Val. |

----------------------------------------------------------------------------------------------------

|SY-SUBRC|0 |

|SY-INDEX|0 |

|SY-TABIX|58 |

|SY-DBCNT|1 |

|SY-FDPOS|0 |

|SY-LSIND|0 |

|SY-PAGNO|0 |

|SY-LINNO|1 |

|SY-COLNO|1 |

|SY-PFKEY| |

|SY-UCOMM| |

|SY-TITLE|MAM: Program for produce Index of Inspection documents |

|SY-MSGTY|E |

|SY-MSGID|PO |

|SY-MSGNO|238 |

|SY-MSGV1| |

|SY-MSGV2| |

|SY-MSGV3| |

|SY-MSGV4| |

|SY-MODNO|0 |

|SY-DATUM|20121130 |

|SY-UZEIT|031119 |

|SY-XPROG|SAPCNVE |

|SY-XFORM|CONVERSION_EXIT |

----------------------------------------------------------------------------------------------------

|Active Calls/Events |

----------------------------------------------------------------------------------------------------

|No. Ty. Program Include Line |

| Name |

----------------------------------------------------------------------------------------------------

| 1 EVENT ZPM_INSP_INDEX ZPM_INSP_INDEX 135 |

| START-OF-SELECTION |

----------------------------------------------------------------------------------------------------

|Chosen variables |

----------------------------------------------------------------------------------------------------

|Name |

| Val. |

----------------------------------------------------------------------------------------------------

|No. 1 Ty. EVENT |

|Name START-OF-SELECTION |

----------------------------------------------------------------------------------------------------

|P_UPD |

| X |

| 5 |

| 8 |

| 0 |

| 5800 |

|SYST-REPID |

| ZPM_INSP_INDEX |

| 5545445554444522222222222222222222222222 |

| A0DF9E30F9E45800000000000000000000000000 |

| 0000000000000000000000000000000000000000 |

| 5A0050004D005F0049004E00530050005F0049004E0044004500580020002000200020002000200020002000200020|

|P_TST |

| |

| 2 |

| 0 |

| 2000 |

|C_CLASS_C2 |

| ES_CULVERT |

| 455454545522222222 |

| 53F35C652400000000 |

| 000000000000000000 |

| 450053005F00430055004C00560045005200540020002000200020002000200020002000 |

|P_GJAHR |

| 2012 |

| 3333 |

| 2012 |

| 0000 |

| 3200300031003200 |

|ZPM_NOTIF_IND |

| 0000 00000000 00000000 0000|

| 2223333222222222222223333333322222222222223333333322222222222222222222222222222222222222223333|

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|

| 2000200020003000300030003000200020002000200020002000200020002000200020002000200020003000300030|

|SY-XFORM |

| CONVERSION_EXIT |

| 444545544454545222222222222222 |

| 3FE65239FEF5894000000000000000 |

| 000000000000000000000000000000 |

| 43004F004E00560045005200530049004F004E005F0045005800490054002000200020002000200020002000200020|

|<%_TABLE_ZPM_NOTIF_IND> |

| ??? |

| ?????? |

| ???????????? |

|SY-REPID |

| ZPM_INSP_INDEX |

| 5545445554444522222222222222222222222222 |

| A0DF9E30F9E45800000000000000000000000000 |

| 0000000000000000000000000000000000000000 |

| 5A0050004D005F0049004E00530050005F0049004E0044004500580020002000200020002000200020002000200020|

|<%_TABLE_ZPM_NOTIF_INDE> |

| ??? |

| ?????? |

| ???????????? |

----------------------------------------------------------------------------------------------------

|Internal notes |

| The termination was triggered in function "ab_HandleRsqlErrors" |

| of the SAP kernel, in line 724 of the module |

| "//bas/720_REL/src/krn/runt/absapsql.c#22". |

| The internal operation just processed is "SQLS". |

| Internal mode was started at 20121130031119. |

| Internal call code.........: "[RSQL/DELE/ZPM_NOTIF_IND ]" |

----------------------------------------------------------------------------------------------------

|Active Calls in SAP Kernel |

----------------------------------------------------------------------------------------------------

|Lines of C Stack in Kernel (Structure Differs on Each Platform) |

----------------------------------------------------------------------------------------------------

|SAP (R) - R/3(TM) Callstack, Version 1.0 |

|Callstack without Exception: |

|App : disp+work.EXE (pid=41840) |

|When : 11/30/2012 3:11:22.94 |

|Threads : 2 |

|Computer Name : WSAPPSP105 |

|User Name : SAPServiceSP1 |

|Number of Processors: 8 |

|Processor Type: Intel64 Family 6 Model 47 Stepping 2 |

|Windows Version : 6.1 Current Build: 7601 |

|State Dump for Thread Id 7cf10 |

|00000000020680C0 0000000140B803B1 0020002000200020 disp+work!DumpStacks [ntstcdbg.c (548)] |

|00000000020681C0 000000013F712594 00000000746C26B0 disp+work!NTDebugProcess [ntstcdbg.c (383)] |

|00000000020681F0 000000013F926059 00000000746C26B0 disp+work!CTrcStack2 [dptstack.c (354)] |

|0000000002068240 000000013F92B6CF 0000000072B94398 disp+work!rabax_CStackSave [abrabax.c (8680)] |

|0000000002068B50 000000013FA39B25 00000000000002D4 disp+work!ab_rabax [abrabax.c (1429)] |

|0000000002068C00 000000013FAA503D 0000000000000096 disp+work!ab_rsqlerr [abdberr.c (953)] |

|0000000002068DB0 000000013FAAC192 0000000000000034 disp+work!SqlsExecuteCall [absapsql.c (7383)] |

|0000000002068F60 000000013F915631 0000000000000000 disp+work!ab_jsqls [absapsql.c (12003)] |

|00000000020690E0 000000013F988200 00000000000003A8 disp+work!ab_extri [abextri.c (676)] |

|0000000002069130 000000013F9889A5 0000000000000000 disp+work!ab_xevent [abrunt1.c (336)] |

|00000000020691C0 000000013F966039 000007DF000002A0 disp+work!ab_trigg [abrunt1.c (57)] |

|0000000002069250 000000013F77DB96 0000000000000016 disp+work!ab_run [absubmit.c (511)] |

|0000000002069400 000000013F78265D 0000000000000000 disp+work!dynpmcal [dymainstp.c (2732)] |

|0000000002069490 000000013F78190C 0000000002069670 disp+work!dynppai0 [dymainstp.c (1355)] |

|0000000002069560 000000013F73B21F 0000000000000020 disp+work!dynprctl [dymainstp.c (470)] |

|000000000206F7C0 000000013F5C6390 0000000000000000 disp+work!dynpen00 [dymain.c (2029)] |

|000000000206FA90 000000013F5C6B8C FFFFFFFFFFFFFF00 disp+work!TskhLoop [thxxhead.c (4873)] |

|000000000206FAF0 000000013F4ECF36 000000000006C1AC disp+work!ThStart [thxxhead.c (1187)] |

|000000000206FB90 000000013F4C10A1 FFFFFFFF00000001 disp+work!DpMain [dpxxdisp.c (1195)] |

|000000000206FBC0 0000000140E5C4AE 0000000000000001 disp+work!nlsui_main [thxxanf.c (80)] |

|000000000206FBF0 000000007677652D 0000000000000000 disp+work!__tmainCRTStartup [crtexe.c (552)] |

|000000000206FC20 0000000076E6C521 0000000000000000 kernel32!BaseThreadInitThunk |

|000000000206FC70 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |

|State Dump for Thread Id 5085c |

|000000000DA9F980 000007FEFD5CC41F 0000000000000000 ntdll!ZwFsControlFile |

|000000000DA9F9F0 0000000140D4EB8F FFFFFFFFFFFFFFFE KERNELBASE!ConnectNamedPipe |

|000000000DA9FA90 0000000074631D9F 00000000024FF7F0 disp+work!SigIMsgFunc [signt.c (717)] |

|000000000DA9FAC0 0000000074631E3B 00000000746C2AC0 MSVCR100!endthreadex |

|000000000DA9FAF0 000000007677652D 0000000000000000 MSVCR100!endthreadex |

|000000000DA9FB20 0000000076E6C521 0000000000000000 kernel32!BaseThreadInitThunk |

|000000000DA9FB70 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |

----------------------------------------------------------------------------------------------------

|Database Interface Information |

----------------------------------------------------------------------------------------------------

|C|1|ERROR: -1 in function ExeNormalModify (execute) [line 20371] [dbsyb.c#21912] |

|C|1|(21) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 605 occur |

|C|1|red at Nov 30 2012 3:11AM. Please note the error and time, and contact a user [dbsyb.c#2897|

|C|1|with System Administrator (SA) authorization. [dbsyb.c#28978] |

|C|1|sql statement is ==> DELETE FROM "ZPM_NOTIF_IND" WHERE "MANDT" = ? AND "GJAHR" = ? [dbsyb.c#2|

|C|1|/* R3:ZPM_INSP_IN [dbsyb.c#28978] |

|C|1|DEX:83 T:ZPM_NOTIF_IND M:900 */ [dbsyb.c#28978] |

|C|1|transaction aborted by server [dbsyb.c#22054] |

|B|E|***LOG BY4=> sql error 21 performing DEL on table ZPM_NOTIF_IND [dbtran#7|

|B|E|***LOG BY0=> [ASE Error SQL21]WARNING - Fatal Error 605 occurred at Nov 30 2012 3:11AM. Plea|

|B|1|dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL' [dbtran.c#7698] |

|B|1| RSLT: {dbsl=99, tran=1} [dbtran.c#7698] |

|B|1| FHDR: {tab='ZPM_NOTIF_IND', fcode=194, mode=2, bpb=0, dbcnt=0, crsr=0, [dbtran.c#7698] |

|B|1| hold=0, keep=1, xfer=0, pkg=0, upto=0, init:b=0, [dbtran.c#7698] |

|B|1| init:p=0000000000000000, init:#=0, wa:p=0000000000000000, wa:#=0} [dbtran.c#7698] |

|B|1|dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL' [dbtran.c#7729] |

|B|1| STMT: {stmt:#=1, bndfld:#=2, prop=0x1, distinct=0, [dbtran.c#7729] |

|B|1| fld:#=0, alias:p=0000000000000000, fupd:#=0, tab:#=1, where:#=3, [dbtran.c#7729] |

|B|1| groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0} [dbtran.c#7729] |

|B|1| CRSR: {tab='', id=0, hold=0, prop=0, max.in@0=1, fae:blk=0, [dbtran.c#7729] |

|B|1| con:id=0, con:vndr=6, val=2, [dbtran.c#7729] |

|B|1| key:#=1, xfer=0, xin:#=1, row:#=0, upto=0, wa:p=0X000007DF000F8208} [dbtran.c#7729] |

----------------------------------------------------------------------------------------------------

|List of ABAP programs affected |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

| 0|Prg|ZPM_INSP_INDEX | 0|26.08.2012|13:09:53| 64512|E |

| 1|Prg|SAPMSSY0 | 1|07.03.2012|15:13:29| 111616|E |

| 2|Prg|SAPMSSYD | 1|07.03.2012|13:08:41| 24576|E |

| 3|Prg|SAPFSYSCALLS | 1|09.09.2004|14:18:32| 8192|E |

| 4|Prg|RSDBRUNT | 0|07.03.2012|14:12:32| 305152|E |

| 5|Prg|SAPLSPRI | 5|07.03.2012|04:31:45| 395264|E |

| 6|Typ|PRI_PARAMS | 0|02.11.1998|09:46:12| 5120| |

| 7|Typ|ARC_PARAMS | 0|28.08.1997|08:36:28| 5120| |

| 8|Typ|PRI_LAYOUT | 0|06.11.2003|20:30:04| 3072| |

| 9|Typ|PRIPAR_EXT | 0|18.05.2004|14:07:03| 3072| |

| 10|Typ|PRIPAR_EX2 | 0|09.11.2000|14:10:39| 2048| |

| 11|Typ|PRIPAR_EX3 | 0|18.05.2004|14:07:03| 3072| |

| 12|Typ|TPRI_DEF | 0|09.11.2000|14:24:28| 5120| |

| 13|Prg|SAPLSPOO | 13|07.03.2012|04:32:02| 181248|E |

| 14|Typ|TSP03 | 0|02.11.1998|09:57:05| 5120| |

| 15|Typ|USR01 | 0|07.03.2012|04:13:18| 4096| |

| 16|Typ|TSP1D | 0|15.11.2000|17:58:02| 5120| |

| 17|Prg|SAPLRSPOLSTDRV | 17|07.03.2012|04:20:35| 64512|E |

| 18|Typ|TSPOPTIONS | 0|29.01.1997|19:13:56| 2048| |

| 19|Prg|SAPCNVE | 19|09.09.2004|14:36:10| 9216|E |

| 20|Prg|SAPLSPOC | 20|07.03.2012|04:31:54| 177152|E |

| 21|Typ|RSPOCHECK | 0|13.08.1997|12:53:10| 4096| |

| 22|Typ|DEVPAR | 0|04.12.2000|12:46:11| 3072| |

| 23|Typ|RSPOATTR | 0|10.11.1999|17:44:19| 2048| |

| 24|Typ|RSSCR | 0|30.03.2005|10:21:45| 5120| |

| 25|Prg|RSDBSPBL | 0|30.03.2005|10:21:58| 84992|E |

| 26|Prg|SAPDB__S | 0|30.03.2005|10:22:01| 21504|E |

| 27|Typ|VARID | 0|07.03.2012|04:13:21| 5120| |

| 28|Typ|SSCRFIELDS | 0|13.05.1997|12:54:26| 5120| |

| 29|Prg|RSDBSPVA | 0|07.03.2012|13:08:34| 160768|E |

| 30|Prg|%_CSYDB0 | 0|30.03.2005|10:21:45| 40960|E |

| 31|Prg|SAPLSVAR | 31|07.03.2012|13:13:20| 921600|E |

| 32|Typ|RSVAMEMKEY | 0|07.05.1997|13:07:49| 2048| |

| 33|Prg|RSDBSPMC | 0|08.02.2007|23:08:20| 92160|E |

| 34|Typ|DDSHDESCR | 0|03.09.1997|03:05:16| 4096| |

| 35|Typ|SPPARAMS | 0|07.05.1997|13:10:38| 2048| |

| 36|Prg|SAPLICON | 36|25.01.2006|11:07:05| 31744|E |

| 37|Prg|%_CICON | 36|21.10.2010|18:09:37| 126976|E |

| 38|Typ|ICONT | 0|08.02.2007|19:03:36| 2048| |

| 39|Prg|SAPLSABE | 39|22.10.2010|00:18:19| 14336|E |

| 40|Prg|SAPLSECU | 40|12.11.2012|00:15:34| 107520|E |

| 41|Typ|RSSUBINFO | 0|14.10.1999|22:01:03| 3072| |

| 42|Prg|RSDBSPVD | 0|07.03.2012|13:08:34| 102400|E |

| 43|Typ|DFIES | 0|07.03.2012|04:06:40| 10240| |

| 44|Typ|VARI | 0|12.05.1997|15:27:09| 6144| |

| 45|Typ|RVARI | 0|30.03.1998|09:40:50| 4096| |

| 46|Typ|RSVARIVDAT | 0|04.04.1995|16:12:54| 2048| |

| 47|Typ|RSVARKEY | 0|07.05.1997|13:07:54| 2048| |

| 48|Prg|SAPLSSEL | 48|07.03.2012|12:01:32| 1699840|E |

| 49|Prg|RSDBSPDS | 0|25.01.2006|11:07:00| 66560|E |

| 50|Typ|RSEXFCODE | 0|13.08.1997|12:52:57| 2048| |

| 51|Prg|SAPLDSYA | 51|17.11.2007|02:46:39| 52224|E |

| 52|Prg|SAPFSDS1 | 51|30.03.2005|10:22:01| 61440|E |

| 53|Typ|TDCLD | 0|02.11.1998|09:51:35| 5120| |

| 54|Prg|SAPLSDOD | 54|25.01.2006|10:59:45| 52224|E |

| 55|Typ|DOKIL | 0|12.05.1997|16:46:17| 3072| |

| 56|Prg|SAPFSPOR | 0|22.10.2010|01:28:11| 16384|E |

| 57|Typ|RSPARINT | 0|10.04.1995|09:58:38| 2048| |

| 58|Prg|SAPLKGJH | 58|07.03.2012|04:22:55| 11264|E |

| 59|Prg|SAPLSTUP | 59|05.01.2006|12:20:05| 86016|E |

| 60|Prg|SAPLCNDP | 60|07.03.2012|06:53:54| 231424|E |

| 61|Prg|SAPLSCNT | 61|18.02.2005|14:16:06| 34816|E |

| 62|Prg|SAPSHDTV | 61|07.03.2012|14:12:38| 38912|E |

| 63|Prg|SAPFGUICNTL | 1|18.02.2005|14:15:08| 27648|E |

| 64|Prg|SAPLOLEA | 64|07.03.2012|04:17:49| 110592|E |

| 65|Prg|SAPLSGUI | 65|17.11.2007|03:46:16| 105472|E |

| 66|Prg|SAPLSTTM | 66|05.07.2005|13:10:18| 79872|E |

| 67|Prg|SAPLSBDC | 67|10.02.2007|00:58:56| 49152|E |

| 68|Prg|SAPLSFES | 68|07.03.2012|06:57:02| 315392|E |

| 69|Prg|SAPLTHFB | 69|12.11.2012|00:15:34| 472064|E |

| 70|Typ|WPINFO | 0|07.03.2012|04:14:04| 6144| |

| 71|Prg|SAPLURFC | 71|07.03.2012|13:13:47| 26624|E |

| 72|Prg|SAPLSPLUGIN | 72|07.03.2012|06:57:53| 9216|E |

| 73|Typ|SWCBCONT | 0|07.03.2012|04:11:56| 3072| |

| 74|Typ|OLE_VERBS | 0|04.04.1995|16:02:20| 2048| |

| 75|Typ|OLE_PA | 0|04.04.1995|16:02:19| 2048| |

| 76|Typ|SSCRTEXTS | 0|03.09.1997|03:12:33| 3072| |

| 77|Prg|CX_SY_OPEN_SQL_DB=============CP | 77|05.07.2005|13:10:16| 13312|E |

| 78|Prg|CX_SY_OPEN_SQL_ERROR==========CP | 78|05.07.2005|13:10:16| 11264|E |

| 79|Prg|CX_SY_SQL_ERROR===============CP | 79|05.07.2005|13:10:16| 11264|E |

| 80|Prg|CX_DYNAMIC_CHECK==============CP | 80|05.07.2005|13:10:16| 11264|E |

| 81|Prg|CX_ROOT=======================CP | 81|07.03.2012|04:50:36| 13312|E |

| 82|Prg|CX_NO_CHECK===================CP | 82|05.07.2005|13:10:16| 11264|E |

| 83|Typ|ZPM_NOTIF_IND | 0|07.03.2012|04:14:11| 5120| |

| 84|Typ|SYST | 0|09.09.2004|14:18:12| 30720| |

----------------------------------------------------------------------------------------------------

|Directory of Application Tables |

----------------------------------------------------------------------------------------------------

|Name Date Time Lngth |

| Val. |

----------------------------------------------------------------------------------------------------

|Program ZPM_INSP_INDEX |

----------------------------------------------------------------------------------------------------

|SYST 09.09.2004 14:18:12 00004612 |

| \0\0\0\0:\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\x0001\0\0\0\x0001 |

|SY . . : : 00004612 |

| \0\0\0\0:\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\x0001\0\0\0\x0001 |

|VARI . . : : 00003052 |

| 900VAZPM_INSP_INDEX DEF_C2 |

|ZPM_NOTIF_IND . . : : 00000352 |

| 0000 00000000 00000000 |

|SSCRFIELDS 09.09.2004 14:18:02 00001708 |

| |

|SSCRTEXTS . . : : 00000742 |

| |

----------------------------------------------------------------------------------------------------

|Program RSDBRUNT |

----------------------------------------------------------------------------------------------------

|VARID . . : : 00000252 |

| ZPM_INSP_INDEX |

|DFIES . . : : 00001350 |

| |

----------------------------------------------------------------------------------------------------

|Program SAPLSPRI |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| \0\0 |

|USR01 . . : : 00000222 |

| 900PROD_BATCH HK5X |

|PRI_PARAMS . . : : 00000380 |

| 001ZPM_INSP_IND |

|ARC_PARAMS . . : : 00000660 |

| |

|TPRI_DEF . . : : 00002932 |

| 900GV21 \0\0\0\0\x0600##\x0080##\0\0#\0######## |

|TSP1D . . : : 00000320 |

| 0000000000 |

----------------------------------------------------------------------------------------------------

|Program SAPLSPOO |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| LP01 HPLJIIIDsapr3pc1 L\0 |

|TSP1D . . : : 00000320 |

| X_PAPER ANY PL0001000010SAP 1998040711 |

----------------------------------------------------------------------------------------------------

|Program SAPLRSPOLSTDRV |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| \0\0 |

|TSPOPTIONS . . : : 00000432 |

| |

----------------------------------------------------------------------------------------------------

|Program SAPLICON |

----------------------------------------------------------------------------------------------------

|ICONT . . : : 00000130 |

| |

----------------------------------------------------------------------------------------------------

|Program SAPFSDS1 |

----------------------------------------------------------------------------------------------------

|TDCLD . . : : 00000098 |

| RE DOKU 40R XX XXLIMUDOCUX (XR3TRPROGX X| |

----------------------------------------------------------------------------------------------------

|Program SAPLSDOD |

----------------------------------------------------------------------------------------------------

|DOKIL . . : : 00000152 |

| REZPM_INSP_INDEX |

----------------------------------------------------------------------------------------------------

|ABAP Control Blocks (CONT) |

----------------------------------------------------------------------------------------------------

|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|Source Code |Line |

----------------------------------------------------------------------------------------------------

|20120|3095| | | | | | | | | | |

| 69|SQLS|34|0000| | | | | | |ZPM_INSP_INDEX | 135|

| 70|SQLS|06|0011| | | | | | |ZPM_INSP_INDEX | 135|

| 71|PAR1|00|006A| | | | | | |ZPM_INSP_INDEX | 135|

| 72|SQLS|24|0005| | | | | | |ZPM_INSP_INDEX | 135|

| 73|PAR1|00|0003| | | | | | |ZPM_INSP_INDEX | 135|

| 74|PAR1|00|0014| | | | | | |ZPM_INSP_INDEX | 135|

| 75|WHER|28|0002|0000|0000| | | | |ZPM_INSP_INDEX | 135|

| 77|WHER|00|0000|0000|0013| | | | |ZPM_INSP_INDEX | 135|

| 79|WHER|20|0000|0001|0012| | | | |ZPM_INSP_INDEX | 135|

| 81|PAR1|80|0052| | | | | | |ZPM_INSP_INDEX | 135|

| 82|SQLS|3B|0000| | | | | | |ZPM_INSP_INDEX | 135|

|>>>>>|SQLS|15|0000| | | | | | |ZPM_INSP_INDEX | 135|

| 84|SQLS|34|0000| | | | | | |ZPM_INSP_INDEX | 136|

| 85|SQLS|06|0014| | | | | | |ZPM_INSP_INDEX | 136|

| 86|PAR1|00|006B| | | | | | |ZPM_INSP_INDEX | 136|

| 87|SQLS|24|0005| | | | | | |ZPM_INSP_INDEX | 136|

| 88|PAR1|00|0003| | | | | | |ZPM_INSP_INDEX | 136|

| 89|PAR1|00|0014| | | | | | |ZPM_INSP_INDEX | 136|

| 90|WHER|28|0002|0000|0000| | | | |ZPM_INSP_INDEX | 136|

----------------------------------------------------------------------------------------------------

Former Member · ‎2012 Dec 03

Hi,

Please check with basis if you have delete authorization for that table.

thanks

sandeep_katoch · ‎2012 Dec 03

Check this

http://scn.sap.com/thread/3192979

http://scn.sap.com/community/abap/blog/2012/03/26/the-answer-to-the-question-so-why-do-i-get-a-short...

Most commonly this type of error occurs if the size of your SQL statement increases the maximum allowed. There can be more reasons as I can see there is only delete statement where the dump is coming.

But for instance you can refer to the blog link which I have provided above.

One more thing check ZPM_NOTIF_IND table for consistency in transaction DB20 or follow this procedure

http://help.sap.com/saphelp_nwpi711/helpdata/en/f2/31ad7a810c11d288ec0000e8200722/content.htm

Regards,

Sandeep

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My Account

My Account

Error message CX_SY_OPEN_SQL_DB