Best Implementation Practices with BI Publisher 1. Best Implementation Practices with Oracle Business Intelligence Publisher Mohan Dutt Brent Lowe VeriSign Inc. STR Software.
Hi there,
I have tried to schedule a BI Publisher (XMLP) report using an email server and here is the error.
Before going to the err message here are some details:
I have created a user in the database, named bipuser. Under this schema I installed the scheduler configuration tables from BI Publisher admin. Verified connection. ok.
Created in BIP a user with the same name and asigned all the priviledges.
in instanceconfig.xml added the path to credentialstore.xml
Verified the email settings with my outlook express account, which works fine . Verified the smtp server, the user and pass (smtp server requires authentification).
In the BIP/admin/email setting provided all the needed info and the tasks continue to fail.
err message
System Message oracle.apps.xdo.service.delivery.DeliveryException: oracle.apps.xdo.delivery.DeliveryException: 550 5.7.1 Authentication Required
at oracle.apps.xdo.service.delivery.impl.DeliveryServiceImpl.deliverToEmail(DeliveryServiceImpl.java:227) at oracle.apps.xdo.servlet.scheduler.XDOJob.deliver(XDOJob.java:1106) at oracle.apps.xdo.servlet.scheduler.XDOJob.execute(XDOJob.java:426) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: oracle.apps.xdo.delivery.DeliveryException: 550 5.7.1 Authentication Required
at oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler.submitRequest(Unknown Source) at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source) at oracle.apps.xdo.service.delivery.impl.DeliveryServiceImpl.deliverToEmail(DeliveryServiceImpl.java:221) ... 4 more Caused by: javax.mail.MessagingException: 550 5.7.1 Authentication Required
d at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:1020) at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:716) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:388) ... 7 more end err message