Problem

 Get an error when opening tma1000 or tma3000.  Error TMA-0101: A database job is needed to process TMA transactions received.

Solution

N.B. this only applies to 4.2.0.0 and earlier.  The process changes from 4.3.0.0 onwards and is in a separate article.

A DBMS jobs on the database doesn't exist or has broken

Run the following statement in SQL*Plus as the Highways Owner and then try again:

select job, what from user_jobs
where broken='Y';

Then this will bring back some results with numbers e.g 226

After run

exec dbms_job. remove (e.g226);

Then run

begin
tma.submit_transaction_job(2);
end;
/

Problem 59107

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!