Error on Anonymize Personally Identifable Information (PII) job - Connection refused

book

Article ID: 206333

calendar_today

Updated On:

Products

Clarity PPM On Premise STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

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)

Environment

Release : Any

Component : CA PPM DATA WAREHOUSE

Resolution

The PII job requires a working connection to Data Warehouse in the properties.xml, also a working DBLINK.

Enter the Data Warehouse database and the connection details in the properties.xml

Restart

Now ensure you have recreated the DBLINK correctly. 

This should resolve the problem