Upgrading the DB (DbLoad) from an old version (< 11.2) with a recent DB version (i.e Oracle 19c) does not work properly

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation
• CA Automic Operations Manager
• CA Automic Oracle

Issue/Introduction

When upgrading the DB to a recent version (e.g Oracle 19c) using an old AE release (lower than 11.2) the error below may appear :

20200720/111750.526 - U00038071 The version of the database system could not be clearly assigned. Version: '19.0.0.0.0' in UPGRADE file not found.
Application return code = 1

Cause

On the oldest releases of the AE/DbLoad scripts, every DB versions were set in the configuration files (UC_UPD.TXT, UC_UPD_STEP.TXT, ...).
From AE 11.2, all Oracle versions could be found using the "*" character (e.g Oracle* instead of Oracle 11.2/Oracle 12.1/Oracle 12.2, ...)

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Get the "defined path *" lines from the TXT files in the db/11.2 folder and past it in the 10.0/11.0/11.2 files.