Problem with SPAM in Solution Manager

[Former Member]

I am currently installing the support stack to take us to patch level 8 on Solution Manager 4.0.

I am in the DDIC_ACTIVATION phase and have failed due to an ORA-8102 error on DDFTX:

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

13, block 54800 (2)"

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

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

When I dig into things I find it is because of index DDFTX_{1. I am trying to drop and recreate the index, but get errors due to the "}" using either:

drop index DDFTX~1 from DDFTX;

drop index "DDFTX~1" from DDFTX

ERROR at line 1:

ORA-00911: invalid character

Additionally, when I go to re-create, it would be appreciated if someone can give some assistance with the proper statement to issue at the SQL level.

[Former Member]

Hi all,

Am facing same problem in SPAM but in CRM system. While appliying SP (SAP_BASIS 12 SP.).

<b>DDIC_ACTIVATION phase and have failed due to an ORA-8102 error on DDFTX:</b>

Connected.

SQL> DROP INDEX "DDFTX~0"

2 ;

DROP INDEX "DDFTX~0"

*

ERROR at line 1:

ORA-01418: specified index does not exist

SQL> DROP INDEX DDFTX~0

2 ;

DROP INDEX DDFTX~0

*

ERROR at line 1:

ORA-00911: invalid character

<b>Unable to drop index also

i tried from SE11 also. But same problem</b>.

thanks in advace

[Former Member]

Hi,

Chk the note 157907

Regrds

Umesh K

[Former Member]

Hi Joseph,

after recreating the index, did you retry and got the same error?

Might be you should analyze your db accordig to SAP Note 365481.

Or do you see more/other ORA-errors?

Regards

Guido

[Former Member]

I doubt it will drop an index on a database level when you are dropping it via SE11. I'd suggest you to do it from DB side (e.g. via sqlplus). I am pretty sure that drop index sap<SID>."<index name>" should work (there should be the real SID you defined for your system instead of <sid>).

Regards,

Mike

[Former Member]

Unfortunately, none of those worked. If I go into SE11 and view the index through the table, I am able to drop it and re-create it, but it makes no difference to SPAM. It still fails at the same point.

Any other suggestions?

Thanks!

[Former Member]

Hi Joseph,

how about drop index "DDXTX_{" or sapr3."DDXTX}"?

Regards

Guido

[Former Member]

Also you can try - drop index sap<SID>."DDXTX~1"

Regards,

Mike