While trying to do subset from one environment to another using SQL query, for timestamp field in hexadecimal format, 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
Test Data Manager 4.9.x 4.10.x
Masking
FDM
This is a limitation in the target database being used.
The error 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