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

Article Id: 129533

Status: Published

Updated On: 14-03-2019 13:05

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.