Error Message ORA-00932 during upgrade from version 8.0

Document ID : KB000087684
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

 
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...