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.
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@'
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.