We are having problems publishing data from a CSV file into a SQL Server table when publishing from the TDM Portal.
After publish execution by TDM Portal, the result displays the following error: “Inconsistent table definitions. Please check the log file. ”.
We analyzed the data structure of the CSV file in DataMaker and identified that all fields are loaded as “varchar type”. We then used the option “Publish Data Pool” in the DataPool, within Data Maker, and identified that the field “Comments”, presented the following message “inconsistent table definitions”.
For resolve this in DataMaker, we used the “Include All” option available on the right mouse button, and the Table Name field changed by “checked OK” icon, and the publication in the SQL Server table occurred successfully.
However, in TDM Portal, we did not find the “Include All” option, so we can't successfully load the CSV file in the SQL Server table, using Portal.
Release : 4.9
Component : CA Test Data Manager
The error indicates that a column, or columns, in the Source Table are a different type than that of the Target Table.
All columns in registered from a CSV file are treated as VARCHAR(2000) in TDM Portal, so that's why the error is thrown. The source type is “varchar" and the target type is "varchar(2000)".
Currently, TDM Portal still doesn't have all the functionality as DataMaker. Our recommendation is using target tables with compatible column data types, if you would like to use only Portal.
However, as a workaround:
After saving the changes, the publishing from Portal should work without problems.