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

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 a transformation map to extract transform, subset, and load data into a target environment.
We are using Oracle source as the 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 

Environment

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

Cause

Permissions issue on the database

Resolution

The 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.

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