Problem

Launching inspection form MAI3808 results in error message ORA-04063: package body "atlas.mai" has errors.
Form used daily to log safety defects in exor  "Maintenance Manager, Inspections, Inspection" . Now it will not allow us to complete/log a defect against an inspection. Same might happen to MAI3660 Budgets form.

Recompiling module MAI gives:

Errors for PACKAGE BODY MAI:
3354/5   PL/SQL: SQL Statement ignored
3354/12  PL/SQL: ORA-01775: looping chain of synonyms

Solution

Cause was a missing table HHINV_LOAD_3 that needed re-creating in highways owner account, without that, package doesn't compile.

The reason why HHINV_LOAD_3 is missing might be the Inventory Loader process that includes a drop and recreate of that table. Sometimes a loading error occurs after the drop and before the recreate, leaving the system without an HHINV_LOAD_3 table at all.

Please contact Bentley Support to discuss. 

Relevant Information 

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!