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.
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:
Hope this helps -Nika
After PMM services restart the job start running.