U00038111 ERROR when analyzing database version while upgrading from old (< 11.2) AE version
Article ID: 195455
Updated On:
Products
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
With SQL Server 2022, the following error would appear:
20250413/164732.899 - U00038111 ERROR when analyzing database version
20250413/164737.422 - U00038071 The version of the database system could not be clearly assigned. Version: '16.00.4165' in UPGRADE file not found.
Environment
Release : 12.x and 21.x
Component : AUTOMATION ENGINE
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 database versions could be found using the "*" character (e.g Oracle* instead of Oracle 11.2/Oracle 12.1/Oracle 12.2, ...).
Resolution
Get the "defined path *" lines from the TXT files in the db/11.2 folder and paste them in the 10.0/11.0/11.2 files.
Additional Information
If the aforementioned procedure does not resolve the problem.
Upgrade to v12.3 as a step by running the DBLoad from 12.3 utilities. Later run the DBLoad from 21 and load the 21 UC_UPD.TXT file.
Feedback
