Deleted import support package

[Former Member]

Hi Gurus

I want to delete the support package from queue, but this shows me the message.

You cannot reset the queue from import phase 'RUN_SPDD_?'

I want delete the import. Exist any form?

Best Regards

[Former Member]

Hi luis,

If you want to delete the queue you have delete the entries from table PAT01 & PAT 03.

Connect to oracle as sysdba in NT/oraSID in UNIX use command

delete from sap<sid>.pat01 where PATCH='<sapkhxxx>';

commit;

delete from sap<sid>.pat03 where PATCH='<sapkhxxx>';

NOTE:Please be cautious before mentioning the patch, it is advised to take the back up of pat01&03

commit;

Cheers,

Shyam.

[former_member194737]

Hi,

You are almost done with the SP. If you want to try the same SP import from the begining onceagin - then delete the entry from PAT01(relevent entry's - not all) and the entry with "?" in PAT03 and delete any import's in import queue(using STMS_IMPORT)relevent for this and try again.

You can try all this if it is your personal system.

This steps are not recommanded to do it in Production or importent systems.

still if you wnat to try, make sure to backup the system/SAP before trying all this options.

If it is productive (Dev/Prd) You may want to post a message with SAP to resolve this error and proceed as per the direction from SAP.

GoodLuck

GoodLuck,.

[Former Member]

Hi,

First of all I will not recommend to delete the entries from PAT* tables since its only clears the status of support packs applied.

But as you have described that it has reached up to RUN_SPDD ? state then go ahead and run the SPDD transaction to complete applying support packs.

If you are facing any error while applying the support pack then update this message with the errors in logfile.

Kind Regards

Neenad

[Former Member]

CHeck if you can reset the queue.

If you can, then reset it and then you may redefine the queue.

But from the error text you provided, it is not possible to reset the queue now.

So, go ahead and complete the queue import.

[Former Member]

Dear Friend

I've enter the table PAT01 and I've ckecked the SP SAPKH47007.

For delete the record, can I executed from SQL? or from SE16?

Best Regards

[former_member190272]

Hi

Luis u delete the record from SE16

Thanks&Regards

Pankaj

[Former Member]

HI Luis,

PFB a good thread on a similar issue. Just check for some info on this issue..

http://sap.ittoolbox.com/groups/technical-functional/sap-r3-basis/reset-of-queue-in-dd-activation-28...

br,

Sri

Award points for helpful answers