ORA-00932 during Upgrade to V11.2+ from older version with old OVW DDL

book

Article ID: 87382

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
Native error: '932' Msg: 'ORA-00932: inconsistent datatypes: expected CLOB got CHAR'.

When upgrading to version 11.2 or higher from an older version, the DB Load writes the above error message in the log files of the DB Load utility and trace files.

However, there are no adverse effects caused and the error can be ignored.

 

Cause

Cause type:
By design
Root Cause: Datatypes have changed in the DDL causing the error message to be displayed.

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available where the Oracle error message is no longer displayed.
 

Fix Status: Released

Fix Version(s):
Component(s): Utilities

Automation Engine 12.0.0 - Available
Automation Engine 11.2.3 - Available

Additional Information

Workaround :
N/A