Problem with SPAM Update

[Former Member]

All,

I am have 46D installed on Oracle 10G and HPUXIA 64.

I am trying to update the spam in my system for 46C .It goes well upto DD Activation and while activates the in active objects ,it fails with return code 8(import_proper phase) and with below error message

1 -- Sm21 shows

Ora-02168

2 --St22 dump shows DBIF_RSQL_TABLE_UNKNOWN

3 -- SPAM Log

15:27:38: Retcode 1: error in DDL statement for PAT05 - repeat

Error 2168-ORA-02168: invalid value for FREELISTS when executing ADD-FIELD of

Error in DDL statement for when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of PAT05

0 shadow nametabs activated; DDL executed

1 shadow nametab activations resulted in errors

End: Activation of shadow nametabs with DDL (20081218152750)

Activating inactive nametabs

End date and time : 20081218152750

Ended with return code: ===> 8 <===

I have checked all oss notes without any success.Please help to give some resolution.

Regards

Amit

[Former Member]

Thanks Markus and Eric

I have looked at the note and seems to be the right note for my problem.I will come back to you guys after applying this note.

Thankyou for your time.

Regards

Amit

[markus_doehr2]

Check

Note 627246 - Error when you create new objects. ORA-02168

Markus

[Former Member]

Thanks Markus. It works ! (SAP Note 627246).

Regards,

Ludovic

Message was edited by: LUDOVIC PIERRE HAYE

[Former Member]

Hi

system is at SAP Basis 35 , ABAP 35 .

Release 46C

Kernel 1396.

How to resolve the issue.

Thanks

Amit

[former_member204746]

This is exactly what I thought.

you support pack level is really old and it cannot handle all LMTS/ASSM situations.

apply SAP note recommended by Markus Doehr or apply Basis support pack 49 (SAPKB46C49).

[former_member204746]

what is your BASIS support pack level? If it is very old, this kind of problem can occur, especially if your converted to locally managed tablespaces.