cancel
Showing results for 
Search instead for 
Did you mean: 

IDOC AEX and messages in Delivering and "To Be Delivered"

DG
Active Contributor
0 Kudos

Hi

We are on a dual stack PI 7.3.1 sp6 and we have seen lately that some messages are placed in the status "To Be Delivering" and Delivering.

Currently the only way we have to restart the messages is to restart the J2EE server. Which is not a good way to get messages processed on in a productive system.

Any pointer to how We can get the messages restarted?

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member184789
Active Contributor
0 Kudos

Hi Daniel,

Were u able to resolve this issue? We are also facing issue with messages in 'Delivering' Status.

Former Member
0 Kudos

Hello Daniel,

Its better to cancel the message using SQL query.Also dont think that if you restart the server also message will not get reprocessed.

Only way to handle DELIVERING and TBD status is to set it to CANCELLED at DB Level

Use the below Query to cancel it

UPDATE TABLENAME SET STATUS='FAIL' WHERE STATUS='TBDL' and MSG_ID ='Your Message ID';

Regards,

Shri

Former Member
0 Kudos

Hi,

This can be caused by having not enough resource i.e. threads.

Please try assigning more thread to the affected adapter:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2008/12/05/xipi-file-and-jdbc-receiver-adapt...

Best regards,

Gábor

Former Member
0 Kudos

Unfortunately we experience the same, messages in Delivering status for days, neither resend nor cancel have effect. single stack AEX SP04

former_member194612
Active Participant
0 Kudos

Hello Colleagues,

When ever you see that your message are in status "holding" it means that

there has been an issue with the previous messages. This happens in case

of EOIO scenario. Untill the first message is either successfully

delivered or Canceled, it will not allow to process any other message.

hence all the further messages were in status hold.

So , please check any message went error? try to resend manually once.

Thanks,

Satish

DG
Active Contributor
0 Kudos

Hi

We are not using EOIO on thise. But that is where I normally have seen TO be delivered on the old AF.

former_member194612
Active Participant
0 Kudos

Hi

Are you using IDOC as receiver chaneel ? any packaging selected ?

DG
Active Contributor
0 Kudos

Hi

It is a sender channel.

Yes We have configured packing.

The messages affected are not packaged.

naveen_chichili
Active Contributor
0 Kudos

Hi Daniel,

As per my knowledge "Delivering" status will be depending on the receiver system (ex:if DB PI will be trying to keep on insert into the tables) the status will be in  "Delivering" status and the consequent messages will be in "TO Be Delivering" state.

Thanks and Regards,

Naveen.

former_member194612
Active Participant
0 Kudos

Hi

could you please explain your end-to-end scenario.

What naveen said is valid point, so i want to know your full scenario, its appreciable .