[7.4] JDBC receiver: Message stuck in status Delviering

[former_member296836]

Dear all,

I created a file-to-jdbc scenario which worked fine.

But after changing something in JDBC target struktur I tried to send a new message that stucked due

a duplicate message in DB. I deleted all DB entries for new testing, but the message stucks

in status Delivering in Adapter Engine.

I try to start and stop the channel and change something in configuration and reactivate it, but

no change. Restarting or stopping the message is not possible due the status Delivering.

Is there anything else I can do but restart the AE?

We have a 7.4 Java-only system.

Regards

Chris

[engswee]

Hi Christian

Looks like a worker thread in your system might have hanged.

Since you are on single stack and using ICO, the messages are processed by the worker thread at the sender. Try stopping the sender file channel to see if the thread can be released.

You can check out my blog below on troubleshooting such issues - how to search for hanged worker threads, and also how to prevent it from occurring again.

Rgds

Eng Swee

[iaki_vila]

HI Christian,

Try to copy your receiver channel and to link this to your configuration.

You can activate the trace logs in your receiver channel with ( 801367 - XI 3.0 JDBC Adapter: Additional Parameters 😞

logSQLStatement

value: true

Regards.