PI Queues Deletion

[Former Member]

Hi Guys,

i have one queue "XBTS0000" with status as "SYSFAIL" ststus text as "XI Error CLIENT_RECEIVE_FAILED.INTERNAL : QUEUE STOPPED". This queue stucked on 9th Dec 2011.

In same Queue on 12th one more message got stucked with status text as " Transaction Recorded ".

Now its showing as "XBTS0000" as status "SYSFAIL" with entries 2.

Here my question i dont want that 2 messages now. can i delete that queue ..? is it possible.. ? if its how ?

Can any one please help me on this.

Thanks,

Siva.

[Former Member · Accepted solution]

HI,

can i delete that queue ..? is it possible.. ? if its how ?

better to Restart the queue*

if we want to delete Queue , please go through beloe link:

.

thanks,

[Former Member · Accepted solution]

Hi

you can just delete the SYSFAIL entries and restart the queue for other entries, I would not delete the entire queue, you would delete other messages which are waiting for those SYSFAIL entries.

Regards.

[xinjiang_li · Accepted solution]

What's the difference between unlock,delete and delete without activation?

[Former Member · Accepted solution]

Hi

Double click on queue and you will see messages, delete the entries with SYSFAIL and go back to queue list again and unlock the queue, it will start processing, status of the queue should turn into RUNNING state.

Regards.

[Former Member · Accepted solution]

Hi,

Thanks for ur inputs.

i dont want RUNNING status entries..can i delete RUNNING status entries also..?

Regards,

Siva.

[Former Member · Accepted solution]

Hi,

i dont want RUNNING status entries..can i delete RUNNING status entries also..?

yes you can delete RUNNING status entries also. but best way is try to register and activate all queues from the tcode sxmb_adm - manage queues.

regards,

ganesh.

[Former Member · Accepted solution]

Hi Ganesh,

Thanks for ur inputs.

This is Client Proxy Interface. BW to Legacy system.

In BW we have tidal job set up. whenever that message fails then our BW team re triggered that tidal job.after that its working fine.

but still in that BW queue previous messages stucked on that 3 messages showing as status "RUNNING". when i double click on that queue first entry showing as "RUNNING", remaing two short test as " TRansaction Recorded.".means that queue is "RUNNING" status.

if i unlock that queues again it will go messages via PI to legacy system, there is a possibility of duplicating the messages.

because of this reason only i am trying to delete that 3 entries in that particular queue.

pls help me on this..can i directly delete in that queue entries one by one or i need to do any other stuff..?

Regards,

Siva.

[Former Member · Accepted solution]

Hi Siva,

You can delete those queues in smq2 and also cancel those messages from PI system.Otherwsie those messages will reprocess again.

Go to sxmb_moni->Select SCHELUED message and goto EdIt menu and select CANCEL messages with errors.

After that message will not process.

Thanks

Ravi

[Former Member · Accepted solution]

HI,

First u have to delete queue from SMQ2.Then u need to register the queue ,not deregister from SXMB_ADM.

Also change the parameter in SXMB_ADM->Integration engine->Specific Configuaration->Select MONITOR->put Parameter

QRFC_RESTART_ALLOWED ,value is 1.

regards,

ganesh.

[Former Member · Accepted solution]

Hi Ravi,

Thanks for ur inputs.

These messages got stucked in Source system BW. that messages not yet reaches to PI. i dont want that messages.same messages once again re triggered from tidal job.

If i will delete those 3 entries in BW itself ,is there any chance of reprocessing again..? or i need to cancel that messages from BW tcode SXMB_MONI.

Thanks

Ravi

[Former Member · Accepted solution]

HI Ganesh,

Thanks for ur inputs.

i will delete the entries one by one. is it mandatory to register the queues ? if its how ?

can u pls help me on step by step how to register queues so that i will do accordingly.

change the parameter QRFC_RESTART_ALLOWED is also mandatory..?

regards,

siva.

[Former Member · Accepted solution]

Yes siva,u can reprocess those messages from BW also.

Select sceduled messages from sxmb_moni and resend.Those messages will reprocess.

Thanks

Ravi

[Former Member · Accepted solution]

Hi Ravi,

thanks for ur inputs.

i dont want to reprocess those messages from BW also.already that messages reaches to target system.

my question here is how i will delete that messages..thats it..directly i will dlete one by one entry or should i need to do any other stuff ?

Thanks

siva.

[Former Member · Accepted solution]

Siva,

Once messages are successfully delivered to target system,we don't have options to delete those messages. You can delete those records from the target system.

Thanks

Ravi

[Former Member · Accepted solution]

Hi ,

As the messages are in success in the BW system, they cannot be deleted.

And they need not be because these messages will not again be processed to XI.

And answering the other question, you can do a registration and deregistration of queues in trasaction smqr.

Regards,

Manjusha

[Former Member · Accepted solution]

Hi Ravi,

Thanks for ur inputs.

i dont want to resend that messages from BW, sxmb_moni. already that messages are in target system.

just i need to delete that entries in that particular queue. pls suggest how to delete that entries in that particular queue.

Thanks

Siva.

[Former Member · Accepted solution]

Hi Manjusha,

Thanks for ur inputs.

Messages are not success in BW system.Messages failed in BW system itself.

just i want to delete entries in BW system queue.

is it mandatory to delete entries in queue to registration and deregistration of queues in trasaction smqr...?

if its mandatory pls expalin me step by step how to do..?

Thanks,

Siva.

[Former Member · Accepted solution]

Hi Siva,

Please tell me the exact issue and process flow.We will give exact solution.

For queue Deregister or register follow below steps

Go to >SXMB_ADM->DBL Click On Manage Queues->Click on Deregister Queues

then Click on Register Queues and activate queues.

Once do the all steps queues will register.

Thanks

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Many thanks for ur valuable inputs.

This is Client Proxy Interface. BW to Legacy system(File) via PI.

In BW system I have one queue "XBTS0000" with status as "SYSFAIL" ststus text as "XI Error CLIENT_RECEIVE_FAILED.INTERNAL : QUEUE STOPPED". This queue stucked on 9th Dec 2011.

In same Queue on 12th and 13th Dec 2011 two more message got stucked with status text as " Transaction Recorded ". with sam equeue.

Now its showing as "XBTS0000" as status "SYSFAIL" with entries 3.

Just i want to delete that 3 entries in that particular queue..

if i unlock that queues again it will go messages via PI to legacy system, there is a possibility of duplicating the messages.

because of this reason only i am trying to delete that 3 entries in that particular queue.

pls help me on this..can i directly delete in that queue entries one by one or i need to do any other stuff..?

Regards,

Siva.

[Former Member · Accepted solution]

Hi Siva,

As per u r process flow your data is structed in BW .So,you want to delete it.

Please follow below steps

Go to SMQ1 ie.outbound and select those queues and delete it.Then Cancel those messages in BW sxmb_moni.

Your issue will resolve.

Thanks

Ravi

[Former Member · Accepted solution]

HI Siva,

It is not best practice to delete the entries from Queue. Instead cancel the particular messages.

[Former Member · Accepted solution]

Hi Ravi,

Thanks for ur inputs.

Messages stucked in SMQ2 Inbound Queue. i will delete one by one entries in that particular queue.

As you told earlier Go to >SXMB_ADM->DBL Click On Manage Queues->Click on Deregister Queues

then Click on Register Queues and activate queues.

My final question is it mandatory above step, resgister queues those all stuff...?

Thanks

Siva.

[Former Member · Accepted solution]

HI Siva,

When you Deregister and register the queue again then it will start reprocessing the same message that will duplicate at your target system.

Its better to cancel the message at the BW system using the SXI_MONITOR tx.

[Former Member · Accepted solution]

Hi Hareen,

Thanks for ur inpus.

i will cancel that messgae from BW system SXI_MONITOR.

i want to delete that entries in that particular queue also.should i go head with that step also..?

Thanks,

Siva.

[Former Member · Accepted solution]

Yes, you can certainly go ahead with the step.

When the message is cancelled it should automatically delete the entries in the queue and the queue will process the remaining messages.

[Former Member · Accepted solution]

Hi Hareen,

Mant thanks for ur inputs.

First step what i will do ? should i delete the entries in queue one by one first or should i cancel the messages first ?

In BW system Moni, message status is showing as one message "SCHEDULED" and the other one message status as " SYSTEM ERROR - AFTER AUTOMATIC RESTART ", can i cancel this type of messages..?

Thanks,

Siva.

[Former Member · Accepted solution]

Hi Siva,

you can cancel the message in error status and for the message in the schedule status, check this forumn :

Regards,

[Former Member]

Yes, is possible to delete queue.

You have to go to SMQ2 transaction and then place in the queue that you want to delete and select delect queue (first icon on the left).

Fabio

[Former Member]

Hi,

can i delete that queue ..? is it possible.. ? if its how ?

yes we can, but that is not right way. because in development our message sturk in queue you want save the queue.

please go through below blog,

http://www.saptechnical.com/Tutorials/XI/XMLMessageQueues/Monitor.htm

regards,

ganesh.