AnsweredAssumed Answered

Load datawarehouse job failing load access right job successfully completed

Question asked by Agin on May 3, 2016
Latest reply on May 5, 2016 by Agin

Hi All,

 

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

  DWH_CFG_PRE_CONFIG_SP(

    P_DBLINK => 'PPMDBLINK',

  P_FULL_RELOAD => 'Y'

);

END;

)

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

Thanks,

Agin

Attachments

Outcomes