Skip to Content
0
Former Member
Jun 26, 2008 at 10:22 PM

DBIF_RSQL_TABLE_UNKNOWN PAT05 on fresh new ECC 6.0 SR3 DB2 9.5

126 Views

Hi i successfully installed ECC6.0 SR3 on SLES 10 SP2 64bit with DB6 9.5

with enabled Row Compression and deffered table creation.

There were no errors during installation.

I've setup STMS and generated profiles.

I've installed polish language and tried to update SPAM to version SAPKD70028 .

When Import Proper has begun error have appeared :

Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

Date and Time 27.06.2008 00:15:38

Short text

A table is unknown or does not exist.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLSPAM" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

Error analysis

A table is referred to in an SAP Open SQL statement that either does not

exist or is unknown to the ABAP Data Dictionary.

The table involved is "PAT05 " or another table accessed in the statement.

Trigger Location of Runtime Error

Program SAPLSPAM

Include LSPAMU67

Row 32

Module type (FUNCTION)

Module Name SPAM_READ_OPTIONS

Line SourceCde

2 *"----


3 ""Lokale Schnittstelle:

4 *" EXPORTING

5 *" VALUE(OPTIONS) LIKE PAT05 STRUCTURE PAT05

6 *" VALUE(EV_IN_REL) LIKE SY-SAPRL

7 *"----


8 ************************************************************************

9 * This function reads the SPAM settings stored in table PAT05.

10 * If the options do not yet exist default them as follows:

11 * - Option 'Transmission monitor' = inactive

12 * - Option 'Scenario' = 'S' (standard)

13 * - Option 'Generate backup' = inactive

14 * - Option 'Perform generation' = inactive

15 * - Option 'Create data file' = active

16 * - Option 'Save data file' = active

17 *

18 ************************************************************************

19 * New: Only scenario 'S' and 'T' will be stored in function module *

20 * SPAM_UPDATE_PAT05. Scenario 'X' will not be stored any longer *

21 * in SPAM_UPDATE_PAT05 (PAT05)! Instead of scenario 'X' *

22 * scenario 'S' and INACT_IMP = 'X' ist set in PAT05. *

23 * Therefore this module will only return 'S' (with INACT_IMP set*

24 * or not) or 'T' as possible scenarios. *

25 * inactimpao is a new field in PAT05 for downtime minimized*

26 * import mode for Scenario 'A' *

27 ************************************************************************

28

29 CLEAR: options.

30

31 ev_in_rel = '46'. "'50' "default lower release for inactive import

>>>>> SELECT SINGLE * FROM pat05

33 WHERE sysid = sy-sysid.

34

35 IF syst-subrc = 0. "Options exist

36 options = pat05.

37 * normalize the boolean attributes (wipe out a mysterious error);

38 * all values <> 'X' are treated as space

39 IF options-eps_mon <> on.

40 options-eps_mon = off.

41 ENDIF.

42 IF sy-saprl(2) < ev_in_rel(2). "#EC PORTABLE

43 * inactive report import is switched off by ev_in_rel

44 options-inactimpao = off.

45 options-inact_imp = off.

46 IF options-scenario = gc_inactimp_scenario.

47 * scenario is 'X' (in old strategy possible),

48 * so continue with scenario 'S'

49 options-scenario = gc_standard_scenario.

50 ENDIF.

51 ELSE.

23:33:10 DIA 001 000 DDIC BY 4 Database error -159 at INS access to table DDXTT

23:33:10 DIA 001 000 DDIC BY 0 > SQL0159N The statement references "SAPIED.DDXTT" which

23:33:10 DIA 001 000 DDIC BY 0 > identifies a(n) "TABLE" rather than a(n) "VIEW".

23:33:10 DIA 001 000 DDIC BY 0 > SQLSTATE=42809

23:33:11 DIA 001 000 DDIC AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

23:33:11 DIA 001 000 DDIC AB 1 > Short dump "080626 233311 IBMExpre ss01_IED_00 " generated

23:33:14 DIA 003 000 DDIC BY 4 Database error -159 at INS access to table DDXTT

23:33:14 DIA 003 000 DDIC BY 0 > SQL0159N The statement references "SAPIED.DDXTT" which

23:33:14 DIA 003 000 DDIC BY 0 > identifies a(n) "TABLE" rather than a(n) "VIEW".

23:33:14 DIA 003 000 DDIC BY 0 > SQLSTATE=42809

23:33:15 DIA 003 000 DDIC AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

23:33:15 DIA 003 000 DDIC AB 1 > Short dump "080626 233315 IBMExpre ss01_IED_00 " generated

23:34:10 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:10 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#BTABD COMPRESS YES" is too long. Th

23:34:10 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:13 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:13 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#BTABD COMPRESS YES" is too long. Th

23:34:13 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:16 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:16 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#BTABD COMPRESS YES" is too long. Th

23:34:16 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:19 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:19 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#BTABD COMPRESS YES" is too long. Th

23:34:19 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:23 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:23 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#PROTD COMPRESS YES" is too long. Th

23:34:23 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:26 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:26 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#PROTD COMPRESS YES" is too long. Th

23:34:26 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:29 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:29 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#PROTD COMPRESS YES" is too long. Th

23:34:29 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:34:32 BTC 013 000 DDIC BY 2 Database error -107 at EXE

23:34:32 BTC 013 000 DDIC BY 0 > SQL0107N The name "IED#PROTD COMPRESS YES" is too long. Th

23:34:32 BTC 013 000 DDIC BY 0 > maximum length is "18". SQLSTATE=42622

23:35:23 DIA 000 000 MOZDZINSKI BZ A Table PAT05 does not exist in the database with ID R/3

23:35:23 DIA 000 000 MOZDZINSKI AB 0 Run-time error "DBIF_RSQL_TABLE_UNKNOWN" occurred

23:35:24 DIA 000 000 MOZDZINSKI AB 1 > Short dump "080626 233523 IBMExpre ss01_IED_00 " generated

In fact PAT05 is not available under SE16N:

No database table exists for table PAT05

What is going on ?