ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

TDM - Quoted default value NEWID()


Article ID: 227802


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


In the TDM portal, when the default value of the table field is NEWID() (on SQL Server), the insert generated in the SQL file puts the value between quotes. This causes an error when the insert is executed.
There should be no quotes since it is a SQL Server function.

Tested on TDM portal version 4.9.361


Release : 4.9.1

Component : TDM Web Portal

Resolution resolves this issue.