One of the tables in our Masking job had primary key made up of Composite columns of which one of the columns is to be masked.
There is a non-Unique Index set on the table.
The primary key is being looked up by another table which is already masked.
Before starting the masking job I had disabled the primary key and even tried executing the job after dropping the Index.
However, when I run the job, it errors out with this message:
Can you tell us what must be done to ensure the table processes successfully?
Test Data Manager Portal
This is an environment / Database issue
The error you are getting is being returned from the Oracle database.
ORA-25128: No insert/update/delete on table with constraint (SEMA.GRID_W9_PK) disabled and validated , Error resetting restart column for table:GRID_W9
this is not a TDM error.
To look into this further and help you understand what is causing this error, more information is required.
This error alone is not enough to move forward and provide you with any type of solution from the application side.
below are some external links dealing with this oracle error you are seeing:
oracle - ORA-25128: No insert/update/delete on table with constraint (...CK_AM_DATA) disabled and validated - Stack Overflow
constraint state - Ask TOM (oracle.com)
Disable Validate | Oracle4newbies's Blog (wordpress.com)
I am not sure if the above will help you or not.
You could also engage your DBA to help explain this error.