Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher - Report Jobs do not seem to work
Summary
BI Publisher - Report Jobs do not seem to work
Content
I am quite new to BI Publisher. I am trying to use the report jobs functionality.
I have successfully created the BI report, which I want to be sent automatically by email.
First I configured the email driver in Administration -> Email
I tested the connection and it says
Connection established successfully.
In order to set the email driver, I used the same information found in the email driver in Enterprise Manager. I did not insert username and password since in EM there is nothing as well. I only set the email driver and the port.
After that, I create a job and in the destination, I select email. I insert into the to field the email that I want the report to be delivered.
Then in the schedule tab I select Run now and then I submit the report. But then it is gone. I cannot seem to find it nor on the report jobs history neither on the report jobs.
The next time I created the same report job, but in the schedule tab instead of run now, I selected start date 5 mins later.
The job is on the report jobs with the correct start time.
Then when the time comes it disappears from the report jobs. It cannot be found anywhere and the email was not sent. In the report jobs history there is nothing.
Can anyone help? Am i doing something wrong?
Answers
-
What is your BIP version?
Try a simple send to test email. View the report, use the action menu to send, choose email. Does it work?
0 -
Check this how to increase logging doc.
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1454360.1
0 -
my BIP version is :
Oracle® Business Intelligence Publisher 11g Release 1 (11.1.1)
I am logged in with user weblogic. I don't know if that helps, but this user has All users and Administrators Role only. Xelsysadm has Role System Administrators and BIPublisher Administrator. But when I log in with xelsysadm, I cannot do anything and the buttons for creating a new report/scheduled job are faded out. Also the Administration tab(that is at the top right of the page) does not appear at all.
So I do all the tasks with the weblogic user.
I opened the report in order to view it. But I could not find in the actions menu the email option, as you mentioned.
The actions menu is as follows:
Thank you,
Ioanna
0 -
I noticed the Interactive Mode Icon is the active one in your screen shot ... your Send action is inactive because:
From the documentation....
Send enables you to schedule the report for immediate delivery to an e-mail address, printer, or other destination.
The Send action launches the Schedule Report Job page where you can select the output, destination, and notification options.
You cannot send a report in Interactive mode. First, select a different output type (such as PDF or HTML) from the View Report list and then click Send.
0 -
Make sure when looking in the job history, you are filtering for the same user you are attempting to send with ... this catches me from time to time ...
ALSO: make sure you've entered an appropriate email user/password in the Bi Publisher - > Administration -> Delivery -> Email settings page.
0 -
thank you ! So I chose the HTML output type. Then the send button appeared. When I clicked on it, it directed me to the schedule report job.
On the output I selected the destination type email and then I inserted the rest of the information.
Then I clicked on Submit.
It said it submitted successfully, but there is nothing in the report jobs history.Also there is nothing in the report jobs. There was nothing sent in the email. There were no logs produced.
I don't know if the following has anything to do with it:
Any help would be appreciated. Do you know any ways to increase the log level?
Thanks,
ioanna
0 -
May be also check the xmlp_sched_job table in the platform schema and see if there is an entry for the job.
0 -
Here's a query I use against these tables ...
SELECT user_job_name,
issuer,
start_date,
end_date,
CASE
WHEN a.status = 'S'
THEN 'Job Success'
WHEN a.status = 'H'
THEN 'Job Held/Waiting'
WHEN a.status = 'R'
THEN 'Job Running'
WHEN a.status = 'D'
THEN 'Job Document Delivery Failed'
WHEN a.status = 'O'
THEN 'Job Document Output Generation Failed'
WHEN a.status = 'F'
THEN 'Job Error Getting Report Data'
WHEN a.status = 'G'
THEN 'Job Cancelling'
WHEN a.status = 'C'
THEN 'Job Cancelled'
WHEN NVL(a.status,'|') = '|'
THEN NULL
ELSE 'Job Failed '
|| a.status
END job_status,
1 COUNT
FROM dlc_biplatform.xmlp_sched_output b
JOIN dlc_biplatform.xmlp_sched_job a
ON (a.job_id = b.job_id)
WHERE TRUNC(start_date) = TRUNC(sysdate) - :days
ORDER BY start_date,
user_job_name
0 -
apologies ... this query was inner joining the output and job (you have no output yet!) ... PS: adjust the where clause to suit your needs ... I use it in BIP report to pull details so I use the Days parameter.
SELECT user_job_name,
issuer,
start_date,
end_date,
CASE
WHEN a.status = 'S'
THEN 'Job Success'
WHEN a.status = 'H'
THEN 'Job Held/Waiting'
WHEN a.status = 'R'
THEN 'Job Running'
WHEN a.status = 'D'
THEN 'Job Document Delivery Failed'
WHEN a.status = 'O'
THEN 'Job Document Output Generation Failed'
WHEN a.status = 'F'
THEN 'Job Error Getting Report Data'
WHEN a.status = 'G'
THEN 'Job Cancelling'
WHEN a.status = 'C'
THEN 'Job Cancelled'
WHEN NVL(a.status,'|') = '|'
THEN NULL
ELSE 'Job Failed '
|| a.status
END job_status,
1 COUNT
FROM dlc_biplatform.xmlp_sched_output b
LEFT JOIN dlc_biplatform.xmlp_sched_job a
ON (a.job_id = b.job_id)
WHERE TRUNC(start_date) = TRUNC(sysdate) - :days
ORDER BY start_date,
user_job_name
0 -