You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Bi Publisher - Scheduled Job Failure Details

Accepted answer
839
Views
7
Comments
edited Jun 4, 2021 6:11PM in Reporting and Analytics for HCM 7 comments

Summary

Additional detail to ess_request_history

Content

Hello,

Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_history table but want to get at the actual reason for the failure.

For example:

Waiting Time: 0.5 seconds
Data Fetch Time: 14.9 seconds
Total Execution Time: 28.6 seconds
Job Priority: Normal

Waiting Time: 0.5 seconds
Data Fetch Time: 14.9 seconds
Total Execution Time: 28.6 seconds
Job Priority: Normal

Job processor caused exception
[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=8224087]

DATA_PROCESSING_FAILED
[INSTANCE_ID=bip.bi_server1]
There is no data to process
[INSTANCE_ID=bip.bi_server1] oracle.xdo.servlet.scheduler.ProcessingException:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!