TDM: ORA-00932: inconsistent datatypes: expected - got CLOB - Oracle Bulk Cop

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

 

 

Environment

TDM
Javelin

Cause

Data type mismatch

Resolution

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.