Short dump 'Table does not exist in database'

[Former Member]

Hello All,

When a report is executing it is going to short dump by saying 'Table does not exist in database'. As per the short dump analysis this issue is happening because of the following Native SQL statement statement :

Program : %_T050N0 (This is a dynamic program generating by SAP )

Form Name : DYN_LIC_SEL_TOT

exec sql performing LOOP_MOVE_WRITE_ISAP.

select single_plate, itm_num, ctry_code, model_lot,

lic_hold_flg, qty into :dcat-lplate, :dcat-matnr,

:dcat-werks, :dcat-charg, :dcat-holdflag,

:dcat-qty from ZLICENSE_R2 where itm_num = :p_matnr and

model_lot = :p_charg

endexec.

As per the customer this issue occurring since they migrated the SAP back-end data base from Oralce to DB6. Here I felt that ZLICENSE_R2 is not migrated from the Oracle to DB6. But as per the BASIS Team, even this table was not maintained in Oracle also. If the table was not maintained in the Oracle, this issue should have been there even before migration also.

Following is the short dump details:

Short text

Table does not exist in database.

What happened?

The table or view name used does not

exist in the database.

The error occurred in the current database connection "DEFAULT".

What can you do?

Check the spelling of the table names in your report.

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_NATIVE_SQL_ERROR', was not

caught in

procedure "DYN_LIC_SEL_TOT" "(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:

Triggering SQL statement: "select single_plate, itm_num, ctry_code, model_lot,

lic_hold_flg, qty from ZLICENSE_R2 where itm_num = ? and model_lot = ? "

Database error code: "-204"

Could you please let me know what might be the reason for this issue.

Many Thanks in Advance.

[Former Member]

Transaction SE11, input ZLICENSE_R2 for table name, and display the table. Did the table display? If not, that is the main problem.

If the table displays, go to menu item Utilities -> Database Object -> Database Utility

In the resulting screen, under the "Status" fields, you should see text "Exists in the database." If you don't, then the table exists in the dictionary, but doesn't exist in the database system. Click the "Create database table" button and then you should be able to run the program.

You may need basis team's help to carryout some of these actions.

[Former Member]

HI,

check in the oracle db does the table ZLICENSE_R2 exist or not

[rahul2000]

Hi Chandra,

Please go through the link below.I guess it will help.

Rahul