search cancel

Table fails to mask - "Error processing SQL update"

book

Article ID: 214060

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

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: 

ProcceName-scan1.SOT96:
Error processing sql update SOT96.GRID_W9 set de_ident_ind = 'P' WHERE de_ident_ind = 'U',
 
ORA-25128: No insert/update/delete on table with constraint (SOT96.GRID_W9_PK) disabled and validated , Error resetting restart column for table:GRID_W9

Can you tell us what must be done to ensure the table processes successfully?

 

Cause

 

This is an environment / Database issue

Environment

 

Test Data Manager Portal

Resolution

 
 

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.