Problem with SPAM in CRM 5.0

[Former Member]

I am currently installing the support stack to take us to patch level SAP BASIS 12 on CRM 5.0.

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

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

7, block 34280 (2)"

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

When I dig into things I find it is because of index DDFTX_{0. 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

<b>Connected thru SAPSR3</b>

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.

i tried from SE11 also. But same problem.

thanks in advace</b>

[Former Member · Accepted solution]

Still not solved this problem ??

awaiting for solution from gurus.

Thanks

[Former Member · Accepted solution]

Hi,

Try using DROP INDEX <DBSCHEMA>."DDFTX~0" where <DBSCHEMA> is your SAP ABAP schema/owner

Regards,

Mike

[Former Member · Accepted solution]

Hi,

I am faced the problem same your error.

And after i read this post message, i ensure to drop this table.

Now SPAM can continue.

Thank.

Kor