Tibco process instance is getting hung/Stuck at particular JDBC query activity every now and then, After restart of Tibco interface from admin,it works fine. This is an intermittent issue. anyone has idea, what could be the problem?
==> Tried connecting DB directly from SQL developer while the process was stuck in Tibco, it worked fine from SQL developer. So assuming it should not be a connection issue.
==> The process is not even getting timeout, sometime it gets stuck till few days before we realize.
Please let me know if you need more details on this issue Thanks in advance