Skip to Content
avatar image
Former Member

DDIC_ACTIVATION Error during application of Support Pack SAPKH47007

Hi All,

We were trying to apply Support Pack SAPKH47007 and it gave us an error in DDIC_Activation Phase and when i checked the logs it gave us this error

Relationship TMFK-TDID for table TTXS does not exist

Check dependent search help S_TMFK_SETTLE

Search help S_TMFK_SETTLE is consistent

I searched and found one Relevant Note for this SAP Note Num : 625098 and it tells us to delete the following fields

Delete the fields FLG_AK_PAYM_FICA and FLG_AK_PAYM_FIAR from the table

I went to SE11 and i dont see this fields there, and even though if i see them i dont think i can delete them coz it is asking Developer Key.

Upon further checking i found that if we delete the Contents in Pat01 and Pat03 we can go ahead and redo the support packs from begining. Can anyone throw some light on this as to how safe is this?

Regards,

Ershad Ahmed.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 04, 2008 at 12:29 PM

    Your problem is described in

    Note 782140 - OCS: Known problems with Support Packages in Basis Rel. 6.20

    SPAM certainly popped up with that note - did you read it?

    To fix it you will need to open an OSS call.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2008 at 03:03 AM

    Hello Markus

    Thanks for the reply i read that OSS note which Spam Popped up and that note redirects us to 625098 .

    Is there any other way apart from creating an OSS message???

    Regards,

    Ershad Ahmed.

    Add comment
    10|10000 characters needed characters exceeded

    • Did you read the note I gave you?

      The note says:

      Symptom: An error occurs in the DDIC_ACTIVATION phase when you import Support Package SAPKH47007. The DDIC activation log records the following error messages:
        Relationship TMFK-TDID for table TTXS does not exist

      <...>

      Solution: A general solution to the problem is available with R/3 Support Package SAPKH47010. To avoid the error, import the Support Packages SAPKH47007 and SAPKH47010 together in a queue.
      If you have already encountered this error, the queue must be reset and extended to include Support Package SAPKH47010. Since you cannot reset the queue from the DDIC_ACTIVATION phase using normal means, this must be done by SAP Support (Component BC-UPG-OCS).

      Markus

  • avatar image
    Former Member
    Dec 05, 2008 at 03:22 AM

    Hello Markus,

    I have read the notes which u gave me.. There is no way we can reset the queue when ur in DDIC_ACTIVATION phase.... Now in order to go back .. we have to delete the entries from PAT01 and PAT03 Tables.... I faced the same issue once earlier and i truncated the tables after that we had to do restoration as the System was in Inconsistent state... So trying to figure out the right way to delete the contents from PAT01 and PAT03 Tables .

    Regards,

    Ershad Ahmed

    Add comment
    10|10000 characters needed characters exceeded

    • All I can tell you is:

      Do not fiddle with PAT tables!*

      They just contain the state of SPAM, nothing else. The system will still have the wrong data in it. That must be reset using "internal tools" in a special sequence. Since one needs to know exactly what has to be done in which sequence I would the support let do that for you.

      If you have a backup, restore it and apply the patch again but add the package to the queue, that fixes the problem - according to that note.

      I´m sorry, that is not very convenient but if a note says, that you should use support to do that it would be negligent to ignore that, especially if it´s a production system.

      Markus

  • avatar image
    Former Member
    Dec 05, 2008 at 03:45 AM

    Hello Markus,

    Thanks very much for ur time, One last thing before i would go ahead and restore

    try this before your restore . I was checking on google and found this. Not sure if it will

    help. Have u come across these earlier???

    at command line

    tp r3i all <SID> pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL tag=spam -Dclientcascade=yes -Drepeatonerror=8

    then go in se37

    ocs_reset_queue

    hit F8

    SAPM

    x

    hit execute go back and redefine your queue in spam and try again , it worked for me

    Regards,

    Ershad Ahmed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2008 at 04:55 AM

    Hello Markus

    I was able to resolve the issue and now my system is back to normal with out the Restore.. I have pasted the soltuin in my previous post.

    Regards,

    Ershad Ahmed

    Add comment
    10|10000 characters needed characters exceeded

    • And you are SURE that things you read by searching google are the correct way to "solve" the problem? I doubt so because that package alone had a problem when implementing as documented in the note. The only way to circumvent this is to bind additional SPs.

      SPAM may be successful but nobody can guarantee that the system is in a consistent state now.

      I am doing SAP Basis for 13+ years and I never head to deal with that OCS* program nor with a command line TP to "overcome" a patch installation issue.

      Markus