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 NOVEMBER 10, 2016

Applies to:

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

Symptoms

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://olite-emea.fr.oracle.com:7803/em
Enterprise -> Quality Management -> Create Application data Model -> Create Data Subset Definition

5) Edit Application data Model ADM_V11GR23_SCOTT
add sensitive colums: scott.emp.sal

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

Add Column with Ensure Workload Masking Compatibility checked

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms