Skip to Content
0
Aug 12, 2023 at 03:40 PM

CO11N or COHV SAP ERROR No data found for specified key in table by table KSSK

274 Views Last edit Aug 13, 2023 at 01:02 AM 2 rev

Dear All,

When I run COHV,CO11N,SAP ABAP Dump :” No data found for specified key in table.”,SAP ABAP SAPLCLSC SELECT_VIA_KSSK Dump.help me!

ABAP Dump Analysis:

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 in procedure "SELECT_VIA_KSSK" "(FORM)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated.

The reason for the exception is:

Table "KSSK" does not contain a data record with the specified key. The SAP internal database interface was called with the expectation that a data record would be found.

How to correct the error Probably the only way to eliminate the error is to correct the program. - 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_KEY_NOT_FOUND" "CX_SY_OPEN_SQL_DB" "SAPLCLSC" or "LCLSCF2C" "SELECT_VIA_KSSK" The exception must either be prevented, caught within proedure "SELECT_VIA_KSSK" "(FORM)", or its possible occurrence must be declared in the RAISING clause of the procedure.

Information on where terminated Termination occurred in the ABAP program "SAPLCLSC" - in "SELECT_VIA_KSSK". The main program was "SAPLCORU_S ". In the source code you have the termination point in line 461 of the (Include) program "LCLSCF2C". The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in procedure "SELECT_VIA_KSSK" "(FORM)", but it was neither handled locally nor declared in the RAISING clause of its signature. The procedure is in program "SAPLCLSC "; its source code begins in line 6 of the (Include program "LCLSCF2C ".


ABAP Source Code Extract:image.png

Operations in SAP:

CO11N

image.png

SAP Dump Point

image.png

Attachment txt is the current data.

bp000002448-sap-table-kssk-dbdata.txtbp000002448-sap-table-mcha-dbdata.txtbp000002448-sap-program-table-l-objects-tab.txtbp000002448-sap-program-table-l-h-objects-tab.txt

thanks.

Klaus Wang.