Transformation Map for in flight data masking sub setting throwing insufficient privilege error

book

Article ID: 129549

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

       We are using Transformation map to extract transform, subset and load data into target environment. We are using Oracle source as target schema. While running the export script, getting below error and export has failed.

ERROR at line 1: 
ORA-01432: public synonym to be dropped does not exist. 

DROP SEQUENCE GSD_DTM_OWNER.PUMPW_68039_822335 

ERROR at line 1: 
ORA-01031: insufficient privileges 

Cause

Export script has thrown with an error "ORA-01031: insufficient privileges" and "ORA-01432: public synonym to be dropped does not exist. "
       The first time was during a "create or replace directory" call, and the second was during a "DROP SEQUENCE" call. This appears to be a legitimate permissions issue with the account you are using.
        Please have your Oracle DBA verify the account you are using has sufficient privileges and rolls set complete these tasks from a database perspective.

Environment

CA TDM 4.7 (Datamaker, GT Subset and Transformation map) 
Source and Target database is: Oracle

Resolution

After granting DROP privileges to user account and providing read/write access to the directory where dump files are created, we are able to run both import and script scripts.

Additional Information

https://docops.ca.com/ca-test-data-manager/4-7/en/installing/install-ca-test-data-manager/install-the-repository