UTF-8 Migration Pack fails with FAULT_OTHER - Start Impossible

Products

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

Issue/Introduction

When executing the PCK.AUTOMIC_UTF-8-MIG.START job from the UTF-8 Migration Pack, the job fails to start and ends with the following error:

FAULT_OTHER - Start Impossible. ORA-00942: table or view does not exist

Additionally, the SQL Agent logs display an error related to the v$parameter view:

U02012042 Query ' ': 'SELECT value FROM v$parameter WHERE name = 'max_string_size''

U02012045 The database returned an error for RunID ' '

                   : ORA-00942: table or view does not exist

This issue occurs during the initial validation step, where the upgrade checker attempts to retrieve the max_string_size setting from the target Oracle database.

Environment

UTF-8 Migration Action Pack 1.0.8

Cause

Missing Permissions

Resolution

The missing permissions on v$parameter on the destination database was identified as the root cause. To resolve this, the appropriate privileges was granted on the underlying view v_$parameter to the affected users/roles. This allowed users to successfully query v$parameter and retrieve the necessary parameter information.

Additional Information

https://forums.oracle.com/ords/apexds/post/permissions-on-v-parameter-7701