Load Data Warehouse fails. DBLink possible not properly configured.

[Legacy User]

Hi,

 

It's our first time implementation of CA PPM 15.2, and we have encountered issues on Load Data Warehouse job:

 

It seems that Data Warehouse DB Link it's not properly configured. This is how it is now: 

 

 

We've put the hostname, port, service id, service name, login name and passoword of the DWH oracle database. Is that correct? If not, can you please guide me what is the correct configuration.

 

Thanks,

Liviu

[Nika Hadzhikidi]

Hi Liviu

 

Looks like the SID for the Data Warehouse is clardwhi for you in CSA, have you just recently changed it? If yes, please restart PPM services and retry.

 

If not, then yes, probably your DWH db link is not correct. Please run the query:

select * from user_db_links

 

and examine your link. Compare the connection to what you see in CSA - Database page. Ensure the link returns results when you query from it.

 

More details on how to set it up and query it can be found here:

 

 https://docops.ca.com/ca-ppm/15-1/en/installing-and-upgrading/set-up-the-data-warehouse#SetUptheDataWarehouse-SetUpaDatabaseLinkfortheDataWarehouse

 

 

Hope this helps -Nika

[Legacy User]

Hi Nika,

 

After PMM services restart the job start running.

 

Many Thanks,

Liviu