Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
replied

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

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

Regards.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question