Online Tutorials & Training Materials | STechies.com
Register Login

DBSQL_TABLE_UNKNOWN with report SMIGR_CREATE_DDL

|| || 0

DBSQL_TABLE_UNKNOWN with report SMIGR_CREATE_DDL
Stechies

Getting following dump while generating of SQL statements with report SMIGR_CREATE_DDL

Runtime Error Long Text

Category Installation Errors

Runtime Errors DBSQL_TABLE_UNKNOWN

Short Text

Table is unknown or does not exist.

Message E2I224 / I224(E2) Table & does not exist in the database

Error Analysis

The database has returned SQL code "SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view in schema : line 1 col 39 (at pos 38)".

"DBSQL_TABLE_UNKNOWN"

"CL_RSMIGR_DDST_SYB============CP" bzw. CL_RSMIGR_DDST_SYB============CM003

"GET_DDSTORAGE_F_FACT_TABLE" / "GET_DDSTORAGE_E_FACT_TABLE"

Solution

A BW table is defined in the SAP Data Dictionary ("DDIC") but does not exist on the database.

Alternatives:

  1. Active the corresponding BW objects to generate the related tables on the database.
  2. Or delete the corresponding BW object if it is not needed anymore.
  3. Apply the code corrections as a support package or implement the attached Correction Instruction with /nS. This correction will skip tables which are defined only in the DDIC and not on the databse, the migration will ignore them.
  • SAP BW 7.02 (SAP NW BW7.0 EHP 2)

    Import Support Package 17 for SAP NetWeaver BW 7.02 (SAPKW70217) into your BW system. The Support Package will be available as soon as SAP 2017437 with the short text "Preliminary Version SAPBWNews BW 7.02 ABAP SP17", which describes this Support Package in more detail, is d for customers.
  • SAP BW 7.30

    Import Support Package 13 for SAP BW 7.30 (SAPKW73013) into your BW system. The Support Package will be available as soon as SAP 2021667 with the short text "SAPBWNews BW 7.30 ABAP SP13", which describes this Support Package in more detail, is d for customers.
  • SAP BW 7.31 (SAP NW BW 7.3 EHP 1)

    Import Support Package 14 for SAP BW 7.31 (SAPKW73114) into your BW system. The Support Package will be available as soon as SAP 2030844 with the short text "Preliminary Version SAPBWNews NW BW 7.31/7.03 ABAP SP14", which describes this Support Package in more detail, is d for customers.
  • SAP BW 7.40

    Import Support Package 9 for SAP BW 7.40 (SAPKW74009) into your BW system. The Support Package will be available as soon as SAP 2030800 with the short text "Preliminary Version SAPBWNews NW BW 7.4 ABAP SP09", which describes this Support Package in more detail, is d for customers.


In urgent cases you can use the correction instructions.

Before you use the correction instructions, make sure that you check SAP 1668882 for transaction S.

This SAP might already be available before the Support Package is d. In this case, however, the short text still contains the term "preliminary version".


Related Articles

0.0127 seconds.