About STMS Transport Management System error

[Former Member]

Hi guys:

I have already installed IDES 4.6C successfully,but when I login client 000,I run

STMS and windows prompt "configure transport domain" window,and I typed description in description filed ,and click "save" icon but after a while running ,system prompt error information just like below:

ABAP runtime errors DBIF_RSQL_SQL_ERROR

Occurred on 28.07.2007 at 16:42:52

SQL error 8102 occurred when accessing table "TMSALOG ".

What happened?

What can you do?

Please make a note of the actions and input which caused the error.

Please make a note of the actions and input which caused the error.

To resolve the problem, contact your

SAP system administrator.

Choose "Print" for a hard coopy of the termination message. You can

display and adminster short dump messages using Transaction ST22.

Error analysis

How to correct the error

Database error text........: "ORA-08102: index key not found, obj# 55658, dba

117442164 (2)?"

Internal call code.........: "[RSQL/DELE/TMSALOG ]"

Please check the entries in the system log (Transaction SM21).

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"DBIF_RSQL_SQL_ERROR"

"SAPLTMSM " or "LTMSMU10 "

"TMS_MGR_CONFIGURE_CONTROLLER"

If you cannot solve the problem yourself, please send the

following documents to SAP:

[fidel_vales · Accepted solution]

It looks like there is a corruption on the table and/or index.

Check with the command:

<i>Analize table TMSALOG validate structure;</i>

and

<i>

Analize table TMSALOG validate structure;</i>

If the first returns an error, you have a corruption on the table. The second one will also return an error.

If the first one comes clean and the second one comes with an error then the corruption is on the index.

In this case you have to rebuild the indexes (drop and create them )