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.