Resetting SPAM queue

[Former Member]

Dears,

Due to some issue I want to reset my SPAM queue,As its in status XPRA_EXECUTION so it can't be reseted by GOto-reset queue option.

I heard that there is one other way to reset queue by deleting entries from some tables.

Please suggest me how can i reset my queue.

Shivam

[markus_doehr2]

Do not do that.

Your imports are already in the system. If you reset your queue and delete entries out of PAT* tables, this will leave your system in an inconsistent state.

Check your import logs, dumps and check the joblogs of user DDIC.

Resetting the SPAM will only do that - reset that transaction, your system is still not ready.

Markus

[Former Member]

Hi,

Yes Mr. Markus I totally agree with you, I suggested to open OSS befor reseting OCS queue.

regards,

kaushal

[Former Member]

Hi,

yes there is a way to reset queue, but i suggest you to open OSS message.

regards,

kaushal

[Former Member]

Hi Kaushal,

Thanks for the information.

I will do the same but can you plz tell me that procedure also just for knowledge.

Shivam

[Former Member]

HI,

there is one function module OCS_RESET_QUEUE ( SE37) for reset queue

and table related to status of queue is PAT01, PAT03

regards,

kaushal