This article talk about the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as :
To be able to save an Ibot, you must have performed the initial configuration.
When you want to set up the smtp server for a computer which move from one network to a another, the smtp server must be a secure SMTP.
Why ?
Because to fight against SPAM, you are often only permitted to send a mail against a non secure SMTP from your network.
For instance, :
If you don’t know your secure smtp port, a simple search on Google will give you all this details or best, you can go on your provider website.
Example on my provider web site :
Search on google :
We will use this parameters for this article :
It is the smtp parameters of my company but my laptop is at home.
Before we continue, you must verify your smtp parameters with telnet for instance : Email - How to verify your SMTP connection and parameters (TSL/SSL) with TELNET ?
The smtp parameters must be fill in the Mail tab of the scheduler configuration windows :
Enter your parameters. Save them and restart the Oracle BI Scheduler Service.
In Oracle BI Presentation Service, click on the link Setting and select my account In the device part, click on the link “Add Email Device” and enter your email.
Create then an Ibot :
I have scheduled the period to period comparison lag report with an excel attachment.
If you have a problem, you can find the log in the directory :
OracleBI_Home/server/Log/iBots
You have two types of files :
You can find the reason of a failure as :
+++ ThreadID: c80 : 2009-04-26 14:34:04.125
iBotID: /users/administrator/_iBots/lag
[nQSError: 75005] Failed to send AUTH command. 5.7.0 authentication failed