Product(s):	Exor Maintenance Manager
	Version(s):	04.07.00.01
	Environment:	Windows XP 32 bit
	Area:	Work Orders
	Subarea:	N\A

Problem

Since upgrading to 4700, the following error messages appear within work orders:

Unexpected error occurred
ORA-04098: trigger HIGHWAYS.DEFECTS_ALT4 is invalid and failed re-validation
ORA-06512: at HIGHWAYS.MAIWO

Unexpected error occurred
ORA-04098: trigger HIGHWAYS.WORK_ORDERS_ALT1 is invalid and failed re-validation

Solution

There was a change to a package that may affect some existing alert triggers so they need to be dropped and recreated to overcome this.  To do this through the form, navigate to Exor, Reference Data, Mail, Alert Setup and recreate the existing work order triggers by using the drop and recreate buttons.

If this doesn't work, use the following to identify the trigger name for your alert:

select halt_trigger_name, halt_description from hig_alert_types

Then you can try recompiling the trigger in sqlplus as the table owner, log into sqlplus

alter trigger <insert trigger name from query above> compile;

If it displays errors PLS-00306 wrong number or types of arguments in call to CREATE_TRG_ALERT then drop the trigger in SQL*plus:

drop trigger <insert trigger name from query above>;

Once this has completed, recreate the trigger through the application as per the guidance above. 

Managed Service users should contact the Support team if dropping and recreating via the forms does not work. 

.

Original Author:

Clive T