Issue with Autogenerated Subset Scripts for Scrambled Export/Import
Article ID: 103152
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
Trying to use Subset Scrambled Extract option to Mask and Extract data and Import it to a Target. The database is MS SQL Server DB. The masking function used is FORMATENCRYPT.
Here are the issues with the two dataytpes:
Issue with Maskviews.sql execution with datatype ntext:
I am getting below error when maskviews.sql is executed.
Msg 5335, Level 16, State 1, Server WXV-TST-DSQL4, Procedure Adjustment_v, Line 1
The data type ntext cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.
Few tables have a field with datatype ntext. But there is no relationship setup with anytable on this field. The joins are all setup with ID field. So not sure why this error should occur.
Issue with with Autogenerated Prehash.sql as well as Maskviews.sql execution with datatype image:
There are 2 issues observed.
1. Issue with Autogenerated Prehash.sql :
All CREATE statements need to have a corresponding DELETE or ALTER statement with IF THEN logic. This is because incase the script execution fails in between, we need to manually delete all the tables, views, stored procedures, functions created by the script. I have seen that this existed earlier but somehow with recent builds as a part of patchfixes seems it is missed.
2.Issue with Maskviews.sql execution :
I am getting below error when maskviews.sql is executed.
Msg 5335, Level 16, State 1, Server WXV-TST-DSQL3, Procedure Images_v, Line 1
The data type image cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.
One of the tables does have a field with datatype Image. But there is no relationship setup with any table on this field. The joins are all setup with ImageID field. So not sure why this error should occur.
Please let us know if there is a fix or something that we are doing incorrectly when declaring the data types.
Here are the issues with the two dataytpes:
Issue with Maskviews.sql execution with datatype ntext:
I am getting below error when maskviews.sql is executed.
Msg 5335, Level 16, State 1, Server WXV-TST-DSQL4, Procedure Adjustment_v, Line 1
The data type ntext cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.
Few tables have a field with datatype ntext. But there is no relationship setup with anytable on this field. The joins are all setup with ID field. So not sure why this error should occur.
Issue with with Autogenerated Prehash.sql as well as Maskviews.sql execution with datatype image:
There are 2 issues observed.
1. Issue with Autogenerated Prehash.sql :
All CREATE statements need to have a corresponding DELETE or ALTER statement with IF THEN logic. This is because incase the script execution fails in between, we need to manually delete all the tables, views, stored procedures, functions created by the script. I have seen that this existed earlier but somehow with recent builds as a part of patchfixes seems it is missed.
2.Issue with Maskviews.sql execution :
I am getting below error when maskviews.sql is executed.
Msg 5335, Level 16, State 1, Server WXV-TST-DSQL3, Procedure Images_v, Line 1
The data type image cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.
One of the tables does have a field with datatype Image. But there is no relationship setup with any table on this field. The joins are all setup with ImageID field. So not sure why this error should occur.
Please let us know if there is a fix or something that we are doing incorrectly when declaring the data types.
Cause
Code needed to be changed.
Environment
TDM 4.5
Datasubset build Version 4.5.20.0 - Build Date 13 June 2018
Datasubset build Version 4.5.20.0 - Build Date 13 June 2018
Resolution
All the mentioned issues in this article are resolved by SUBSET22JUNE2018.zip Please contact Support for this Subset version. If you are downloading a GA version, please ask CA Support if this version was included.
Additional Information
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.
Feedback
Yes
No
Powered by
