reg: Error showing that table is not in the data base

[Former Member]

Please go through the below error and give me a suggestion to solve it

Error Analysis:

a table is referred to in an sap open sql statement that either does not exist or is unknown to ABAP data dictionary the table involved is "TWPSRVlOGS" or another table accessed in the statement.

the table "TWPSRVlOGS" already exists but it is going to a dump .

otherwise please provide a SNOTE.

thanks in advance

rahul

Edited by: rahul nuthi on Sep 11, 2008 8:04 AM

[Former Member · Accepted solution]

Hi ,

I mean go to SE14 ->Tablename -> -> Indexes -> Select one index -> Create database index

Execute the procedure for all indexes of this table. Afterwards check

whether the issue persists.

Thanks & Regards,

Pradeep Srigiri

[jonathon_sells3 · Accepted solution]

Why would the Create Database Index button be grayed out?

[Former Member]

Hi,

The below notes might help you in this case.

#540463 - FAQ: Consistency Checks + Block Corruptions ,,

#23345 - Consistency check of ORACLE database ,,

#365481 - Block corruptions If you have performance

problems,

The runtime object of table is inconsistent. The same occurs for the database object. Could you please try to activate this table in SE11

If its active in se11 then activation of table is done in background via SE14.

check the status of the job every so often and check the consistency of the runtime object and database object after the job is completed.

If the run time object is consistent and the database obect is inconsistent then idexes doesnot exist on database.

If its the case follow the below procedure:

Execute the following procedure in order to create

them:

- SE14 -> MSEG -> Indexes -> Select one index -> Create database index

Execute the procedure for all indexes of this table.Afterwards check whether the issue persists.

Thanks & Regards,

Pradeep Srigiri

[Former Member]

Dear Rahul,

May be somebody has deleted that table via SE14(database utility)

Just check it from se11 that whether this table exist or not.

PS:Correct me if I am wrong.

Regards,

Ashutosh

[Former Member]

we did it, the table exists