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 ignored3354/12 PL/SQL: ORA-01775: looping chain of synonyms
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.
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!