Message stuck in Queue

[Former Member]

Hi,

We are doing a IDOC to JDBC interface taking data from ECC 6.0 via PI7.1 and inseting into the tables of Avantis(3rd paty system). While doing this we are able to successfully insert data sometimes.

But out of three times one time the XML message is not getting inserted ino the table of Avantis.

I think they are getting stuck in queue and we dont have consistency in the creation of the data in Avantis.

Please check and advice for a solution asap.

Rgds

Kishore

[Former Member]

Hi Modali .

Check in the interface determination if the maintain order at runtime is ticked. If it is then it means that you are using qRFC. This causes message to get stuck in the queues if you had a failed message prior.

Untick the maintain order at runtime if this is not a requirement and it should work

[Former Member]

Hi,

In the receiver JDBC adapter select advanced mode.

Mark Database Auto-Commit-Enabled option.

Regards,

Prakasu.M

[Former Member]

Kishore

>

> I think they are getting stuck in queue

Have you checked the queues with SMQ2 ?

If the messages are stuck, you should find details there. Please post the error messages.

You may also find error messages in the system logs (SM21).

Hope this helps.

PJ