After a long time I am back to the forum but with an issue
There is a scenario where a trigger is behaving strangely. Out of all the documents it is subscribing, only 1 or 2 are not processed every day and these 2 threads are being hung up. Concurrence processing is enabled with max. 5 threads. The exact error from the server logs
Do you guys have any idea on this? The environment is WM 6.5. The above subscribed service gets a SQL query from the published doc, queries the source DB, starts transaction, inserts into target table and commits or rollsback based on status of insertion.