Error: ORA-04098 trigger is invalid and failed re-validation during UTF-8 migration

Products

• CA Automic Workload Automation - Automation Engine
• Automic Automation
• Automic SaaS
• CA Automic One Automation

Issue/Introduction

Symptoms

When performing a database migration to UTF-8 using the Automic Migration Action Pack, the process fails during the SQL script execution. The following errors appear in the logs:

PLS-00049: Invalid bind variable 'NEW.'or PLS-00049: bad bind variable 'NEW.'
ORA-04098: trigger 'TR_AH_TIMESTAMP2_4' is invalid and failed re-validation
U00003592 UCUDB - Status: ''NativeError: '4098'

The Automation Engine (AE) fails to start following the migration attempt.

Environment

• Automic Automation v21
• Oracle Database
• UTF-8 Migration Action Pack

Cause

This issue occurs when residual metadata or invalid triggers remain in the destination database from a previous or canceled migration attempt. The migration scripts attempt to validate triggers like TR_AH_TIMESTAMP2_4 or TR_EH_STATUS_BLOCKED, but they fail due to invalid bind variables or mismatched table structures in the destination schema.

Resolution

To resolve this issue, perform a clean reset of the destination environment:

1. Coordinate with the Database Administrator (DBA) to manually drop all triggers in the destination database schema.
2. Verify that the destination database is completely cleared of any temporary tables or residual metadata from previous attempts.
3. Ensure the source database temporary tables (e.g., those created in Step 1 of the migration) are dropped.
4. Reset the state in the migration VARA objects.
5. Restart the migration process from Step 1.