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.
Have the response messages between the business operation and the business process any relevant data? Any info about errors?
Are you catching and logging the errors from the business operation?
The Responses from the Stored Procedure calls back to the Operation look correct, and yes if there was an error it should of shown up.