Upgrade from version 11 to version 12 fails: Could not find file '../db/oracle/12.1/set_privileges_access_to_messages.sql'.

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Upgrading from 11.2.5 to 12.3.3 is not working ( AIX / Oracle ).
During upgrade of the db with dbload utility i get following error message.

20200707/121657.642 - U00038042 ../db/oracle/12.1/set_privileges_access_to_messages.sql
20200707/121657.642 - U00038252 Could not find file '../db/oracle/12.1/set_privileges_access_to_messages.sql'.
20200707/121657.642 - U00038006 Processing was aborted by the user.

This file doesn't exist in 12.1 but ../db/oracle/12.0/set_privileges_access_to_messages.sql' exists!

Environment

Release : 11.2

Component : AUTOMATION ENGINE

Resolution

This is a known issue when upgrading from Automic 11.2 to 12.3.3.

The workaround's are:

• upgrade to 12.3.2 or lower and than to 12.3.3.
• upgrade to 12.1.x, 12.2.x and than to 12.3.3

This has been resolved with:

Automation Engine 12.3.4
Automation Engine 12.2.7

 

Additional Information

The same problem can be encountered during an upgrade of 12.0 to 12.3.3