Applies To
	Product(s):	Exor Noticing Manager
	Version(s):	04.05.10.02
	Environment:	N\A
	Area:	Other
	Subarea:	N\A
	Original Author:	Lee Jackson, Bentley Technical Support Group

 

Problem Description

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. 

Steps to Resolve

1. Open the HIG2520 Process Monitor form
2. Select the TMA Receive Transactions process which is still running
3. 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 Owner
2. 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:

1. Stop the Process Framework Administration.  During this process, you may receive an error indicating that the process 'TMA Receive Transactions' is running.  If so, kill this job using the procedure shown in Step 3 above.
2. Once the Process Framework has stopped successfully, access the 'Process Monitor' form and query back the process TMA Receive Transactions'.  Once the result is returned, press the 'Disable' button to disable the process.
3. Start up Process Framework Administration.
4. Go to 'Submit a Process' and submit the TMA Receive Transaction process, with a chosen interval
5. Check the Process Monitor form and ensure transactions are being loaded into the database.