cancel
Showing results for 
Search instead for 
Did you mean: 

Messages in Delivering Status

former_member216353
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

marksmyth
Product and Topic Expert
Product and Topic Expert
0 Kudos


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

engswee
Active Contributor
0 Kudos

Hi Mohammed

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

Rgds

Eng Swee