When running the inspection scheduler the following error was seen:Adding inspection against works [AA001?????????????????????????]ORA-00054: resource busy and acquire with NOWAIT specifiedORA-06512: at "HIGHWAYS.TMA_INSPECTIONS", line 2140ORA-06512: at "HIGHWAYS.TMA_INSPECTIONS", line 2151ORA-06512: at "HIGHWAYS.TIRE_BIUD_TAIP", line 42ORA-04088: error during execution of trigger 'HIGHWAYS.TIRE_BIUD_TAIP'
This error can be seen if someone is locking a table or record which the scheduler is trying to update.
The first solution would be to try running the inspection scheduler again and see if the same error is shown. If the problem was caused by a lock on only one record then the scheduler may decide to randomly inspect a different record the second time around.
If the error is seen again, ask a DBA to check for record locks on the TMA_INSP_RESULTS_ALL table. If one exists and has been inactive for some time, then kill the session and try the scheduler again.
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!