We have done the required setup with PII jobs, etc. as per the GDPR document. The Anonymize Personally Identifable Information (PII) job fails giving the attached error as below. We do not use Data Warehouse.
dwh_etl_pii_anonymize - org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver)
[CA Clarity][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused (Connection refused)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)
at org.pentaho.di.core.database.Database.connect(Database.java:353)
at org.pentaho.di.core.database.Database.connect(Database.java:306)
at org.pentaho.di.core.database.Database.connect(Database.java:294)
at org.pentaho.di.job.Job.beginProcessing(Job.java:966)
at org.pentaho.di.job.Job.execute(Job.java:474)
at org.pentaho.di.job.Job.run(Job.java:407)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver)
[CA Clarity][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused (Connection refused)
Release : Any
Component : CA PPM DATA WAREHOUSE
The PII job requires a working connection to Data Warehouse in the properties.xml, also a working DBLINK.