ORA-00947: not enough values- when trying to Publish to Target

book

Article ID: 129533

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When we try to publish to Target database (Oracle)   a row  with a null value it wont show the column. We are getting - 

Publish Error
ORA-00947: not enough values
 It will upload an image and sql text file created by publishing.   But  not when you try to publish to a target database. 

Cause

This error can occur when you are performing an INSERT and the values entered are less in number than the columns that you are inserting into.

Environment

TDM Version 4.6, 4.7

Resolution

Make sure the INSERT  Query Insert rows the same number  as that columns that you are inserting into.