Short dump error DBIF_RSQL_TABLE_UNKNOWN

Former Member — Thu, 28 Feb 2008 08:54:39 GMT

Hi Experts,

We are using a job having program "ATPBD001" to Refresh the buffer. Yesterday this job failed with the short dump error

DBIF_RSQL_TABLE_UNKNOWN.

The message is coming like " One of the tables in the statement accessing table "ATP_RESB " is unknown ".

Today the same job run successfully. what could be the possible root cause of the error ?

Here is the source code for reference :

004370 atp_resb-sobkz = sobkzk

004380 *} INSERT

004390 CLEAR atp_resb-sobkz.

004400 * checks

004410 resb_check atp_resb

004420 p_atpmex.

004430 ENDSELECT.

004440 ENDIF. " IF NOT g_t441v-skbdp IS

004450

004460 ENDIF. " IF s_index_flg = swoff.

004470 ELSE.

004480 SELECT *

004490 FROM atp_resb

004500 INTO atp_resb

004510 WHERE matnr = atpmat-matnr

004520 AND werks = atpmat-werks

004530 AND xloek = space

004540 AND kzear = space

004550 *{ REPLACE PA8K040916

004560 *\ AND sobkz IN (space, sobkzk)

004570 *XFO 16.12.2005 H908220 wrong ATP for spe

004580 *(del) AND sobkz IN (space, sobkz

004590 *} REPLACE

004600 AND bdmng > atp_resb~enmng

004610 AND txtps = space

004620 AND schgt = space

004630 AND dbskz = space

004640 AND ( vorab IS NULL

> OR vorab = space ).

004660 *{ INSERT PA8K040916

Re: Short dump error DBIF_RSQL_TABLE_UNKNOWN

Former Member — Thu, 28 Feb 2008 17:13:53 GMT

Check noe 950317.

rob