Skip to main content
Delphix

FAQ: Compliance Engine (KBA1302)

 

Why do I see errors connecting to a database server, with SQL exceptions indicating an unsupported character set? 

There are many character sets available for use with relational databases, and in some cases a character set may not be supported in a default java installation which will throws sql exceptions.
In most cases, this can be resolved by adding the character set (causing the problem) to the java installation.

Masking job failed to mask when I created a table with 2 rows, threw Oracle error (ORA-00936: missing expression). What am I missing?

You most likely don't have a primary key on your table and you are attempting to do In-place masking. In-place masking is essentially batch updates on a table. The product will read the records and when updating, it needs to identify which records need to be updated and fails to do so.

Since you are using oracle:

  1. Go to your Ruleset.
  2. Edit your Ruleset.
  3. Enter ROWID as a logical key.

The Monitor job output status displays incorrect status by showing some tables as Completed (in RED) with warnings. 

Try the following:

  1. Clean the schema of hundreds of tables that are not in use.
  2. Tune the profile set to 5 domains.
  3. Rebuild rule sets to include an optimum number of tables.