We are upgrading our non-production instance from ca ppm 14.2 sp11 to ca ppm 15.2 sp5. During pre-grade, we get to know that Data ware house setup is required to perform the upgrade for next level.
In our current production and all non-production system we are not using DWH and Jasper Soft with CA PPM 14.2 SP11 version. In order to full fill the requirement of pre-upgrade check, we started the setup of DWH in our non production instance with help of DBA. We followed the document suggested by CA and we were succeeded to create the DWH Schema on same CA PPM Database and created the DB Link as ppmdblink and tested the below query from ppm_dwh scream. Everything was working fine.
select count(1) from [dblink].[cappm database server schema].niku.srm_resources
Later in CA PPM Admin side we configured the system option and CSA as mentioned in install and upgrade guide document and everything was looking fine.
We ran the time slice job and noticed the new DWH time slices in system and job ran successfully. Now, when we are executing Load data ware house job and getting the below error. The same error is appearing in bg_dwh log. There is no error in any other logs .
1/12/18 10:14 AM
It has been resolved.
I missed the below command before running the "Load Dataware House" job.
admin db dwh-upgrade -Dupgrade.phase=maintenance
I found the similar thread. It maybe helpful for your investigation.
Load DWH job fails