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 the Target database (Oracle) a row with a null value it won't 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.
Environment
TDM Version
Test Data Manager
Portal
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.
Resolution
Make sure the INSERT Query Insert rows the same number as that columns that you are inserting into.
Feedback
thumb_up
Yes
thumb_down
No