TDM Portal Masking job missing, or ignoring a table.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

There have been instances of masking jobs running, in which the logs show completed the masking of data for all tables but the QA team reports that one table is not at all masked. 

Could this be associated with "PARALLEL=" error that is getting reported?

Environment

Release : 4.9

Component : TDM Web Portal

Cause

The Masking jobs logs show that the masking is performing very slow, and taking much longer than expected to complete. This could be due to the configuration, or perhaps background job for other applications that are being run on the database.

Resolution

The job is performing much faster now...

We have made several changes...

• We killed inactive sessions from the DB
• Shutdown background application weblogic UI that is used by the testers, which is something that normally would not be running when they do the production data. 
• Masking option
  • logging level - shutdown
  • oracle row ID = Y
  • fetch size - reduced
  • commit size - reduced

Provided FastDataMasker-4.9.208.0, which contains a fix where Portal masking was failing with the error message: Numeric value required for PARALLEL=