Get an error when opening tma1000 or tma3000. Error TMA-0101: A database job is needed to process TMA transactions received.
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_jobswhere broken='Y';
Then this will bring back some results with numbers e.g 226
After run
exec dbms_job. remove (e.g226);
Then run
begintma.submit_transaction_job(2);end;/
Problem 59107
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!