After DWH setup, we have completed jaspersoft installation by running jobs.
1. create and update jaspersoft job - successfully completed
2. time slice job - completed
3. load datawarehouse -failed (in bg-dwh log, am getting the below error)
ERROR 2016-04-28 07:23:12,286 [Thread-14] dwh.event dwh_db_check_ - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
P_DBLINK => 'PPMDBLINK',
P_FULL_RELOAD => 'Y'
4. i tried running load access right job. it also completed sucessfully..
this issue is reporting in test environment. In our dev environment Jaspersoft implementation completed successfully.
Attached bg-dwh log also. Please anyone help me to sort out the
The problem looks like mismatch of CA PPM version and datawarehouse version
Can you execute the below query in PPM & DWH and compare the version
DWH - select * from cmn_dwh_install_history order by installed_date
CA PPM - select * from cmn_install_history order by installed_date
If the version of DWH is different then you should manually upgrade the DWH schema
Enter the following command from the <install_dir>/bin directory command prompt to apply the Data Warehouse patch content:
admin db dwh-upgrade -Dupgrade.phase=maintenance
Let me know how it goes.
I am not in office today. i will update you about this tomorrow.
Thanks Agin, request you to mark the post answered.