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.

Unable to subset timestamp in hexadecimal format using TDM portal

book

Article ID: 240075

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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 com.microsoft.sqlserver.jdbc.SQLServerException:

Sample value- 0x0000000009E9CB1E

Could you please us here?

 

Cause

This is a limitation in the target database being used.

Environment

Test Data Manager 4.9.x 4.10.x
Masking 
FDM

 

Resolution

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 (sql-server-helper.com)