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.
Root Cause: Upgrading Automation Engine from Version 8 to Version 10 and above causes a Database error.
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
Component(s): Automation Engine and Initialdata
Automation Engine 12.0.1 – Available
Automation Engine 11.2.4 - Available
Automation Engine 11.1.5 - Available
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...