Skip to Content
author's profile photo Former Member
Former Member

Table 'TRSTIT' could not be accessed after upgrade

Hello,

After upgrade from Enterprise 2.00(640Kernel) to ECC6.0(700Kernel), TRSTIT table become invalid:

SE16 -> "no database table exists for TRSTIT"

SE14 -> DB Object -> check -> Table is not exist in database

Runtime Object -> check -> consistent

SE11 -> popup "Table TRSTIT does not exist in the database"

But still could view the table structure afterwards.

DB schema has not been changed, and other tables work fine with only this table running into error.

Tried in SQLplus

select * from dba_tables where table_name ='TRSTIT';

result seems alright:

owner table tablespace .....

SAPPSE TRSTIT PSAPPSE .....

The upgrade was finished successfully.

Could somebody suggest why this happens?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 18, 2008 at 06:27 AM

    Hello. Are you update optimizer statistics (db13 for example) ?

    Try to check in DB02(or DBACOCKPIT) --> Diagnostics --> Missing tables and indexes.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2008 at 11:48 AM

    do you still have an un-upgraded system avaialbe? check if this table existed back then.

    if not, go into SE14 and create table.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Eric,

      There isn't any un-upgrade system left.

      The table was okay before the upgrade.

      I found the table as per Sergo's advice.

      There are also other tables missing... Could you advice the reason?

      Best Regards,

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.