Not able to create DB link for Japsersoft if ipV6 is Configured

book

Article ID: 185927

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

  • We recently installed Jasper. All the data warehouse jobs seem to fail and the reason is the DB Link is not created in NSA.
  • I tried to create the DB Link in NSA, but the system does not allow me to do so. 

Cause

Caused by DE38981 where a problem with DBLINK does not allow you to save a data warehouse link when IPv6 is configured, resulting in a Load Data Warehouse job failure.

Environment

Release : 15.4.1, 15.5, 15.5.1, 15.6, 15.6.1

Component : CA PPM DATA WAREHOUSE - IPv6 Configured environments

Resolution

Solution 1:

  1. Connect to DWH-Database 
  2. Run following command:

CREATE DATABASE LINK PPMDBLINK 
CONNECT TO <schema> IDENTIFIED BY <password> USING '<user>';

  • Make sure that the Clarity User has the following right:
  • User name and password is for the Clarity user


Solution 2:

1. Set up custom DB Link by checking the "Custom Database Link" in the CSA->Data Warehouse section
2. Provide the name of the custom link in CSA