DB load fails during upgrade from 10.0 to 12.2

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Upgrade from 10.0 to 12.2 (DB. LOAD) fails with:

20190615/080614.030 - U00038042 declare i integer; begin select char_length into i from user_tab_cols where column_name='EH_MESSAGE'; if i <> 256 then EXECUTE IMMEDIATE 'alter table EH modify EH_MESSAGE VARCHAR2(256 CHAR)'; end if; end;

20190615/080614.030 - declare i integer; begin select char_length into i from user_tab_cols where column_name='EH_MESSAGE'; if i <> 256 then EXECUTE IMMEDIATE 'alter table EH modify EH_MESSAGE VARCHAR2(256 CHAR)'; end if; end;

20190615/080614.031 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 186c0be0 DB-HDBC: 1848cd18

20190615/080614.031 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'

20190615/080614.032 - U00003592 UCUDB - Status: '' Native error: '1422' Msg: 'ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at line 1'

Environment

Release : 12.2

Component : AUTOMATION ENGINE

Resolution

select char_length from user_tab_cols where column_name='EH_MESSAGE'; returned 0 rows

select * from user_tab_cols worked, so there's no permission problem with the Automic database user

select * from user_tab_cols where column_name='EH_MESSAGE' returned EH and EH_20181214