search cancel

Unable to subset timestamp in hexadecimal format using TDM portal


Article ID: 240075


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Hi Team,
While trying to do subset from one environment to another using SQL query, for timestamp field in hexadecimal format, we are getting the below error-

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.; nested exception is

Sample value- 0x0000000009E9CB1E

Could you please us here?



This is a limitation in the target database being used.


Test Data Manager 4.9.x 4.10.x



The error you are getting looks like it is a limitation on the SQL server itself as the error is being generated by the SQL server. 

About the error:
Since the timestamp column is automatically generated by the database, this error will be encountered if a value is specified to the timestamp column when a new row is inserted into a table that contains a timestamp column.

Below are some Links you might want to review that have suggestions on how to deal with this issue and the root cause.
SQL Server: Cannot insert an explicit value into a timestamp column - Stack Overflow

SQL Server Helper (