on 12-04-2008 12:03 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.