The TMA Receive Transactions process has been running for a very long time and all received transactions shown in TMA3000 Monitor Web Service transactions are stuck at Web Service Complete status.
1. Open the HIG2520 Process Monitor form2. Select the TMA Receive Transactions process which is still running3. If it has been running for more than an hour, click the Stop Execution button
The process should stop and almost immediately start a new execution, however if you receive an error message stating 'ORA-27365: job has been notified to stop but failed to do so immediately', please close the form and recheck the status after a few minutes. Please note the next new execution of this process may take a few minutes to complete while it catches up.
If the Stop Execution feature did not stop the stale execution, please try the following:
1. Log in to SQLPlus as the Highways Table Owner2. Run the following statement: select hp_job_name from hig_processes where hp_process_type_id = (select hpt_process_type_id from hig_process_types where hpt_name = 'TMA Receive Transactions');3. Next update the following SQL with the name of the process identified above, then run it in SQLPlus. For example replace 'JOB_NAME_FROM_ABOVE' with 'PROCESS_1'. exec DBMS_SCHEDULER.stop_JOB (job_name => 'JOB_NAME_FROM_ABOVE',force=>true);4. After a few minutes, open a new instance of the HIG2520 Process Monitor form and recheck the status of the TMA Receive Transactions process.
If the steps above fail, a new process will have to be created. Steps to recreate the job are shown below: