FDM Masking function TRUNCATE throws error.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have an issue when we use the masking function truncate and in the connection setting we are not using the default account for that schema.

We have a service account that has access on multiple schema. FORMATECNRYPT1 function is working but not the TRUNCATE function.

The error we get it's that the table does not exist in the schema.

 

Example : truncate table schema_name.table_name; 

Environment

Release : 4.8.153

Component : CA Test Data Manager

Resolution

FastDataMasker-4.8.159.0.zip patch fixed the issue.