When we run the upgrade prepare we get an error during the import phase (MVNTAB_TOOL) stating that the tables don't exist in the database and they are not active. If we go to SE11 and try to view a table (usr02, for example) we get a "table does not exist in the database" information message.
If i click on the help button of the message it says:
Table USR02 does not exist in the database Message no. E2224 Diagnosis This is a transparent table which is defined in the ABAP/4 Dictionary, but does not exist on the database. No data can be stored yet in the table for this reason. System response Information. Procedure You can create the table on the database with the database utility (SE14). You can also activate the table again. In this case, the table is automatically created on the database.
If we then go to SE14 (with usr02, for example) it finds the table but gives the status as not existing in the database. We cannot reconstruct the table as this option is greyed out, so is the the option to "delete" or "activate and adjust database". We can only "create database table". If we choose "create database table" we get an SQL error:
SQL0601N The name of the object to be created is identical to the existing name "SAPDKE.USR02" of type "TABLE". SQLSTATE=42710
So the strange thing is, from the database side, the table does exist -- also confirmed in DB02 table snapshot -- but the SAP system does not see the table in the database.
These type of errors used to appear on older SAP releases with either SQL-Server or Informix. The system was running fine but almost all data dictionary transactions -- SE11, SE14, SE16 and others -- were unable to find the tables in the database -- exactly the behavior you are describing. For SQL-Server and Informix, patches in the form of transport requests exist.
The best course of action would be to open an OSS message.
Dig Deeper on SAP implementation and upgrades
Related Q&A from Bert Vanstechelman
An SAP user wants to know the risks of changing time zones in ECC 6.0. Continue Reading
An SAP user wants to know how to access an SAP IDES 4.7 system via the Internet through SAP GUI. Continue Reading
A SearchSAP.com reader wants to know how an increase of indexes and tables after upgrade to SAP ECC 6.0 will affect the memory requirements of a DB2 ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.