Missing tables in DB02

[Former Member]

Hi Gurus,

In DB02 / Diagnostics displays that following tables are missing:

- ORA_COCKPIT_HELPER

- SFHOT

- T77TNM_IFPROPS

- YINFTOOL

I found some sap notes how to solve the issue, but was not able to.

1. What are these tables.

2. Do I need them, if NOT which tables can be deleted, and how exactly

3. Required tables ho can I create them

Pl. give exact instructions

- ZZCON_TEMP (Tried to delete in SE14 / SE11) could not delete.

Pl. advse how to solve the issue, thanks for your help in advance.

sahmad

[Former Member]

Thanks everyone we have resolved the issue

[Former Member]

HI Ahmad,

I had the same issue with different indexes but for same TABLE : ora_cockpit_helper.

I had run the SQL statement and the missing indexes are gone. However, missing table ora_cockpit_helper still exists.

got same error - ORA-00903 : invalid table name. What should I paste into <p_sql_stmt_text> ?

May I know how did you resolve the issue.

[symon_braunbaer]

Dear S Ahmad,

please kindly describe the exact solution, as I am facing the same problem, I have been trying to fix this for several hours and still nothing !!

Many thanks in advance!

[Former Member]

Hello Symon.

For PLAN_TABLE:

cd D:\oracle\SID\11204\RDBMS\ADMIN  (or your location of this script)

sqlplus / as sysdba

@utlxplan.sql

For ORA_COCKPIT_HELPER:

transaction dbacockpit> sql statment

Just execute any sql request and the table will be recreated

[symon_braunbaer]

Hello Igor and many thanks for replying.

I have tried to execute a few queries in SQL Command Editor in ST04, like:

select * from dual;

or

select bname from SAPSR3.USR02;

They've got through, they are producing results, but I still have that table as missing in the ABAP dictionary. On DB level the table exists:

SQL> desc SAPSR3.ORA_COCKPIT_HELPER;

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

SORTED_BY                                          VARCHAR2(26)

SQL_ID                                             VARCHAR2(13)

EXECUTIONS                                         VARCHAR2(11)

RECORDS                                            VARCHAR2(13)

VALUE                                              VARCHAR2(13)

VALUE_PER_EXEC                                     VARCHAR2(14)

PERCENT                                            VARCHAR2(7)

MODULE                                             VARCHAR2(64)

SQL_TEXT                                           VARCHAR2(4000)

SQL> select count(*) from SAPSR3.ORA_COCKPIT_HELPER;

  COUNT(*)

----------

         0

Please kindly advise on how to fix that.

P.S.: I have the same problem with table MLICHECK~

While there are quite a few notes about MLICHECK, I didn't find anything about MLICHECK~

Many thanks !!

[Former Member]

Hello Symon! ORA_COCKPIT_HELPER is a temporary table, the information is stored in this table only for a period of execution a request. So zero records in this table - is not a problem. ORA_COCKPIT_HELPER doesn't need to be activated in the dictionary, only on a database level.

Unfortunately I don't know anything about MLICHECK

[symon_braunbaer]

Hi Igor and many thanks for your question. It means, that either the table has to be dropped after purgint the temporary data, or I should make an entry in DBDIFF...

Thanks for specifying this.

P.S.: I already solved MLICHECK~ with the help of Reagan, so don't worry about it. Thank you!

[Former Member]

Hi Symon, no, table hasn't to be dropped. It stay in system empty, and when you execute some sql queries in dbacockpit -  the table begin to grow, and it will be empty after end of query. I think so.

[symon_braunbaer]

Well, this is really puzzling then...

It's a temporary table, so I think it should be created and destroyed with each query.

I have also checked - no ORA_COCKPIT_HELPER in the DEV system and in the

production system, it exists under 2 schemata 😄 Really funny...

There is no problem in executing Queries from SAP GUI in ST04 on the system

where the table doesn't exist...

[Former Member]

Transaction DB02 reports a data inconsistency between the database and the ABAP Dictionary:

1) ORA_COCKPIT_HELPER: Read note Note 1374746 - DBA Cockpit: Temporary table ORA_COCKPIT_HELPER it says how to create the missing table ORA_COCKPIT_HELPER

Goto your SQL prompt and the commmand as per note

SQL>create global temporary table ora_cockpit_helper as

select * from ( <p_sql_stmt_text> ) where 1=0

It was just not get created for SAP dictionary. Simple create it....

2) SFHOT: is defined in the ABAP Dictionary as a cluster table and was accidentally created in the database in a previous release. Check that the table is correctly defined in R/3. To do this, you can activate the table in transaction SE11. If this can be done without any errors, the table can be deleted from the database. Use database tools to do this. Read how to go for it from SAPnote :33814

3)T77TNM_IFPROPS: The customizing table T77TNM_IFPROPS only exists in release 4.70 as stated in note 1130425; hence during an upgrade from this release, you might notice that the table and the runtime objects exist without the DDIC reference. Follow as "Note 1396592 - Table T77TNM_IFPROPS - Upgrade discrepancies" says ...

No idea about your fourth table....

all the best !

[Former Member]

SQL>create global temporary table ora_cockpit_helper as

    select * from ( <p_sql_stmt_text> ) where 1=0

ERROR at line 1:

ORA-00903: invalid table name. What should I paste into <p_sql_stmt_text> ?