Column named ROW_ID causes error
TimothyO
Posts: 1 New member
Some of my tables have a column named "ROW_ID". When attempting to run Data Masker for SQL Server (version 7.1.45.8811 64bit), I get an error like this:
Column names in each table must be unique. Column name 'ROW_ID' in table '#TempDM_7buO2P7ZKk6Qf/fur8S5VA' is specified more than once.
If I change the name of my column to something like "TEST_ROW_ID" for example, it works fine. Is there a workaround for this which would not require changing column names?
Column names in each table must be unique. Column name 'ROW_ID' in table '#TempDM_7buO2P7ZKk6Qf/fur8S5VA' is specified more than once.
If I change the name of my column to something like "TEST_ROW_ID" for example, it works fine. Is there a workaround for this which would not require changing column names?
Tagged:
Best Answer
-
Eddie D
Posts: 1,802 Rose Gold 5
Data Masker for SQL Server V7.1.46.8858 is now available that fixes this problem. The temporary table created by the shuffle rule, the column that the tool adds has been renamed and hopefully will not match any column name in the table to be masked.
Many Thanks
Eddie
Answers
I suspect that I have an open support ticket open with you, where we are waiting on a bug fix version of Data Masker.
For other readers of this forum post. The problem is caused by Data Masker for certain rules, the shuffle rule is one example, a temporary table is created by SQL Data Masker. This temporary table is created with a column name ROW_ID, so SQL correctly errors as a table cannot have two columns with the same name.
The good news is that a bug fix version is due to be made available. I will update this forum thread when the bug fix version becomes available.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com