My Oracle Support Banner

Create Masking Definition To Ensure Workload Masking Compatibility Fails with: Workload masking is not supported by the target database chosen (Doc ID 1582157.1)

Last updated on MARCH 03, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

On : 12.1.0.2.0 version, EM Data Masking Pack

When attempting to create a Data masking definition with EM 12CR2 and Ensure Workload masking Compatibility "checked"
the following error occurs.

ERROR
-----------------------
Workload masking is not supported by the target database chosen. You may need to apply a patch or move to a newer version of the database for workload masking.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Install EM 12.1.2.0.2

2) Install RDBMS 11.2.0.3.0

3) Install Agent on the Database Host

4) log in the EM console: https://<HOSTNAME>:<PORT>/em
Enterprise -> Quality Management -> Create Application data Model -> Create Data Subset Definition

5) Edit Application data Model ADM_V11GR23_TESTUSER
add sensitive colums: TESTUSER.emp.sal

6) Enterprise -> Quality Management -> Data Masking Definitions ->
Name: Masking_DEF_1
Application Data Model ADM_V11GR23_TESTUSER
Reference Database V11GR23

Add Column with Ensure Workload Masking Compatibility checked

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.