· Jan 19

Custom Business Operating - SQL Outbound Adapter Troubleshooting

Ran into an issue this morning, that I am having a hard time trying to track down what might have caused the issue. We have a Business Rule that sends HL7 ADT to a Business Process that inserts the data into a MS SQL Server using a Custom Business Operation (SQL Outbound Adapter).

Early yesterday morning the Custom Business Operation reset its connection through the Java Gateway Server to the MS SQL Database, when it reconnected to the Java Gateway/MS SQL Database it stopped processing. So, the Business Rule had over 40,000 queued up to process. There was no indication of an issue by looking at the Namespace, all Rules, Processes, and Operations associated with this workflow were Green.

When I look at the visual trace for the message in question, I see that all the responses were sent back to the Business Proces, and the Business Process showed it sent a Response to the Business Rule. However, after that nothing was processing through the Rule, Process, or Operation.

While I will be setting alerting on the Rule process to notify if there is a significant queue backup or inactivity alert, I would like to still know why the workflow hung. Currently the Rule does not have a "Response From" value set which I will be updating next week, any idea on why it would cause it to hang?

No other connections to that same Java Gateway had the issue. 

Product version: IRIS 2022.1
$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1.4 (Build 812_0_22913U) Thu Dec 7 2023 17:06:30 EST
Discussion (2)2
Log in or sign up to continue