Fast Data Masker cannot create Pre/PostStep Scripts on MSSQL 2014

Document ID : KB000008243
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When the DBUPDATES option is set to P on FDM (Fast Data Masker), FDM cannot create Pre/Poststep Scripts.  FDM gives an error "Invalid object name 'SYSFOREIGNKEYS'." 

It appears MSSQL version 2014 changed the reference from sys.foreignkeys to sys.foreign_keys.  Does FDM need to be updated to account for this?

Environment:
TDM - 4.2.0.141 FDM - 4.7.0.14 Microsoft SQL server 2014 - 12.0.2000.8 (x64)
Cause:

To check your instance, modify the following to work with your system:


SELECT DISTINCT (CASE WHEN OBJECTPROPERTY(CONSTID, 'CNSTISDISABLED') = 0 THEN 'ENABLED' 
ELSE 'DISABLED' END) AS [STATUS], OBJECT_NAME(CONSTID) AS CONSTRAINT_NAME, 
OBJECT_NAME(FKEYID) AS FK_TABLE, OBJECT_NAME(RKEYID) AS PK_TABLE, CONSTID FROM SYSFOREIGNKEYS WHERE OBJECT_NAME(RKEYID) = 'YOURTABLENAME' 

Resolution:

A patch has been created to resolve this issue - FastDataMasker-4.7.40.0.zip.  If you need this patch, please contact CA Support by opening a case. If you do not know how to open a case, please review this video and request this version or later.  If you have a GA version after Sept 19, 2017, please verify with CA Support that this fix made it into the GA release. 

Additional Information:

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.