BI Publisher - Report Jobs do not seem to work

Ioanna Kat-Oracle

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?

Violeta F

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?

Sherry George

Check this how to increase logging doc.

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1454360.1

Ioanna Kat-Oracle

​ There are no logs, neither in bipublisher.log nor in the bipublisher.out.

Do you know in which logger should I increase the log level??

Ioanna Kat-Oracle

@Thomas

Thank you !!!

I tried this query and it returned no results.

So the H means status Held/Waiting.

Any ideas on how to debug this?

The xmlp_sched_output has no records.

Thank you again ,

Ioanna

Sherry George

In addition to what Thomas Dodds has said, check the bipublisher.log file to see any additional error/warning messages

Ioanna Kat-Oracle

@Thomas,

I configured the connection with the correct username and password and when I test it it says success.

Anyway the email is not being sent, even if I looked with a different user.

Ioanna Kat-Oracle

Hello ​,

I checked the xmlp_sched_job and the job seems to be there. I cannot understand what the status H means.

thanks,

Ioanna

Thomas Dodds

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

Thomas Dodds

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

Sherry George

May be also check the xmlp_sched_job table in the platform schema and  see if there is an entry for the job.