Skip to Content

Messages in Delivering Status

Dear all,

We are experiencing a peculiar issue (IDOC to JDBC interface). We are invoking a store procedure at DB side.

Many messages are going into Delivering or To Be Delivered Status.

The JDBC reciever channel logs description says

2014-04-15 05:37:53 Information The message was successfully received by the messaging system. Protocol: XI URL: http://hostname:port/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

2014-04-15 05:37:53 Information Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

2014-04-15 05:37:53 Information Message successfully put into the queue.


Some of the messages have this status as well

ACTION_USER_FAIL_MESSAGE

ACTION_USER_RETRY_MESSAGE

Checks done till now

1. No JDBC adapter locks have been indentified

2. Java stack has been restarted, but the issue still persitis.

3. SM12 - Also does not have any locks

4. Check with DB team and confirmed that everything is working fine at their side.

5. Other interfaces to this DB are working fine.

regards

Younus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 15, 2014 at 12:17 PM

    Hi Mohammed

    This is an issue that occurs quite frequently and I have blogged about it recently here:-

    Handling and preventing messages stuck in To Be Delivered status

    Rgds

    Eng Swee

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2014 at 01:26 PM


    Hello Younus,

    Also check note 831162 FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter -> 28. Effect of setting Maximum Concurrency and poolWaitingTime. These parameters can help avoid the issues you have described above.

    Regards
    Mark

    Add comment
    10|10000 characters needed characters exceeded