Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What are the tables that host Report Job Error History?

Received Response
1
Views
1
Comments
Lucien Fuertes
Lucien Fuertes Rank 1 - Community Starter

Hello community;

We are running report jobs with bursting to email addresses(invoice files sent to customers via email). We're getting Status of Problem (See attached) and when I click on the Report Job Name, I see the Output & Delivery section with the Output name and  I filter by Error to find the ones with the problem. See attached. The problem has to do with invalid email addresses. Sample error below. We would like to now what table hosts these error in order to pull them all at once instead of having to open each output to see the error.

Thank you in advance.

Lucien

Document delivery failed
[INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]Exception happened when delivery document to email
deliver API call throw ProcessingException

Email delivery failed with Exception
Email delivery failed with DeliveryException
oracle.xdo.delivery.DeliveryException: javax.mail.internet.AddressException: Missing domain in string ``bernadette.ibanez@'
oracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: javax.mail.internet.AddressException: Missing domain in string ``bernadette.ibanez@'
at oracle.xdo.service.delivery.impl.DeliveryServiceImpl.deliverToEmailUtil(DeliveryServiceImpl.java:417)
at oracle.xdo.service.delivery.impl.DeliveryServiceImpl.deliverFileToEmail(DeliveryServiceImpl.java:200)
at oracle.xdo.enterpriseScheduler

Answers

  • Hi,

    Try to have a look into the XMLP_* tables and there are also the QRTZ_* tables which are related to BI Publisher.

    All those are into the BIPLATFORM schema created by the RCU.

    Doc ID 1618405.1 has a list of tables related to Publisher.