We are getting the below error while running Javelin bulk copy for Oracle table. Can you please advise on the resolution.
2020-02-19 11:26:29 - Error executing Read data from KPD_REPOS.CUSTOMER_CALCULATIONS: ORA-00932: inconsistent datatypes: expected - got CLOB
2020-02-19 11:26:30 - Running Test Case: Bulk Copy
2020-02-19 11:26:30 - Test Case: Bulk Copy Execution Complete
2020-02-19 11:26:30 - Running Test Case: Flowchart
2020-02-19 11:26:30 - Test Case: Flowchart Execution Complete
Execution complete with error:ORA-00932: inconsistent datatypes: expected - got CLOB
Test Data Manager
It was recommended to compare the source and target table definition (DDL) and check order of the column and data type mismatch.
You can use Datamaker Reconcile functionality to quickly check.
From Datamaker choose Projects --> Reconcile tables
Able to determine mismatch.