Deleting EO- Delivering Messages in Adapter Engine

[Former Member]

Hi All,

I am facing an usual issue with my production PI BOX. From the subject itself you can come to know, what is my issue is..

Anyway let me explain.

We have so many interfaces which are all using JBDC connectinon to connect to different target applications. As you all know, messages in ADAPTER engine have gone to Delivering status for some reason. I am aware it is a temprory status and it cannot be deleted manually.

And important thing here is, i do not want these message to go to target application anymore. The data was sent already . If i do the restart of JDBC service/Messaging System Service/ J2EE stack some of these message may go through to tha target appication.

My questions are

1) How should i delete these Delivering messages ? Should i delete it directly in PI data base? If yes how should i ?

2) Is there any JOB or configuration change in VA which allows us to hande this?

I have gone through alomost all blogs/Threads/OSS notes.

Please advice.

[Former Member]

> And important thing here is, i do not want these message to go to target application anymore. The data was sent already . If i do the restart of JDBC service/Messaging System Service/ J2EE stack some of these message may go through to tha target appication.

>

Hi Rajesh,

As you said the message has already been sent, so the problem is that status has not been updated to DLVD. correct??

I think since it has already sent the message then it will not again send it, because the system internally checks if message with same mesage-id (guid) has been already delevered or not.

So probabily you need to restart the J2EE server to change the status.

Note: If it is your production issue then do it at your own risk.

Regards,

Sarvesh

[Former Member]

Hi Rajesh

What a coincidence.. We too have the same problem...

1) How should i delete these Delivering messages ? Should i delete it directly in PI data base? If yes how should i ?

You cannot delete a message which are of status delivering in adapter engine...

2) Is there any JOB or configuration change in VA which allows us to hande this?

one thing you can do is increase the thread count of JDBC adapter in VA..

/people/sunil.singh13/blog/2009/03/30/adapter-specific-queues-in-pi

only thing is need to restart the Java stack..even that doesnot guarante that all messages will be canceled..

or you can restart the XI AF Serivce in VA..

try your luck...

All the best and let me know the update

Rajesh