message stuck in SMQ2 when jdbc down, and continue to stuck even jdbc up

[Former Member]

Hi All,

I have a Rfc-XI-Jdbc scenario.

It’s working fine. Problem is whenever Jdbc is down, at that time messages fails and hangs into SMQ2 and then all messages fails and got stuck into SMQ2 for same scenario even if Jdbc is up.

Is there is any way to get to know that message ques are getting failing.

Regards

[Former Member]

closed

[Former Member]

Hi,

see this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20bb9649-e86e-2910-7aa9-88ed4972...

Regards

Chilla

[Former Member]

try using

Disconnect from Database After Processing Each Message

of the JDBC adapter. this will at lease ensure that connectivity is reestablished after your DB is up

[Former Member]

Hi Rohan,

Pls try to activate the queue manually in SMQ2.

Regards,

Will