Failed to create a PII Scan job - ORA-00942

Products

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

Issue/Introduction

Repository - Oracle DB

Have been using CA TDM portal for PII analysis till last week. But now when trying to submit PII job I am getting below error.

Environment

Release : 4.9.1

Component : Web Portal - PII Audit/Scan

 

Cause

The repository schema is being used as the Data source with multiple other extra tables created in it. It is like you are trying to do a PII scan for repository schema itself. This would have rendered repository schema in an unreliable state. 

Such usage may cause unknown issues including the one seen in this case with PII scan.

Resolution

To overcome this issue first ensure the right setup and state of repository. For that, follow below steps.

- Get a new schema/user(preferably GTREP but first DROP the existing GTREP user/schema) created for your Oracle instance with admin privileges.

- Stop CATDMPortal and OrientDB services.

- From Control Panel->Uninstall program option uninstall the CATDMPortal software.

- Make sure that the folder C:\Program Files\CA\CA Test Data Manager Portal is removed.

- Also make sure that both CATDMPortal and OrientDB services do not exist.

- Now, run the last used CATDMPortal installer "as administrator" and follow the installation steps. For repository details give the newly created GTREP user details and continue. Make the schema/user that you are going to use is empty.

- After the installation completes, start TDMPortalService and check with creating a new connection profile and doing the scan.