| Product(s): | Exor Maintenance Manager | ||
| Version(s): | 04.07.00.01 | ||
| Environment: | N\A | ||
| Area: | Inspections | ||
| Subarea: | N\A |
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
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.
communities.bentley.com/.../ORA_2D00_04063-MAI-package-body-error-script.docx
Bentley Technical Support KnowledgeBase
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!
| Original Author: | Bentley Technical Support Group |