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

book

Article ID: 185524

calendar_today

Updated On:

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

 

 

Cause

Data type mismatch

Environment

Release : 4.8

Component : CA Test Data Manager - Javelin

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.