Error Message ORA-00932 during upgrade from version 8.0

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
'ORA-00932: inconsistent datatypes: expected CLOB got CHAR'.

Upgrading Automation Engine (AE) from Version 8.0 to AE Version 10 and above causes the above ORA-00932 error message to be displayed in the log and trace files.

 

Environment

Release: AOATAM99000-8.0-Automic-One Automation Tools-Application Manager
Component:

Cause

Cause type:
Defect
Root Cause: Upgrading Automation Engine from Version 8 to Version 10 and above causes a Database error.

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Component(s): Automation Engine and Initialdata
Automation Engine 12.0.1 – Available
Automation Engine 11.2.4 - Available
Automation Engine 11.1.5 - Available

Additional Information

Workaround :
Workaround is to do the upgrade version by version with the DB-load for next version.DB-load V9 to bring V8 to V9DB-Load V10 to bring V9 to V10...