DBIF_RSQL_TABLE_UNKNOWN PAT05 on fresh new ECC 6.0 SR3 DB2 9.5
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 ?