Obiee – How to configure the Mail server of Oracle BI Scheduler/Delivers

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 :
* the sender address
* the smtp server
* the smtp port

To be able to save an Ibot, you must have performed the [[dat:obiee:bi_scheduler:obiee_scheduler_configuration|initial configuration]].

===== The smtp parameters =====

==== Secure or no secure stmp ====

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, :
* the smtp of your internet home supplier if you are at home
* the smtp of your internet company supplier if you are in your company

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 :
* http://www.xs4all.nl/helpdesk/email/instellingen/

Search on google :
* [[http://www.google.nl/search?q=smtp+ssl+aol+port|Smtp Ssl Aol]]
* [[http://www.google.nl/search?q=smtp+ssl+orange+port|Smtp Ssl Orange]]

==== Verify your smtp parameters ====

We will use this parameters for this article :
* smtp server : smtp.xs4all.nl
* port TLS : 587
* Login : login
* Password : password
* Sender : nicolas.gerard@newfrontiers.com
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 : [[:smtp_telnet]]

===== The mail scheduler configuration windows =====
The smtp parameters must be fill in the Mail tab of the scheduler configuration windows :
* open the [[dat:obiee:bi_server:oracle_bi_administration_tool|administration tool]]
* in the menu : Manage / Job
* the job Manager open
* then Menu / file configuration option / Mail

{{:dat:obiee:bi_scheduler:obiee_scheduler_configuration_mail.jpg|}}

Enter your parameters. Save them and restart the Oracle BI Scheduler Service.

{{:dat:obiee:bi_scheduler:obiee_presentation_service.jpg|}}

===== Setting you email in your account =====
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.

{{:dat:obiee:bi_scheduler:obiee_device_mail.jpg|}}

===== The result =====

Create then an Ibot :
* choose minimum “Me” as recipient (recipients tab)
* select in the destination tab “Email”.

I have scheduled the [[dat/obiee/presentation_service/obiee_period_to_period_lag_lead_function|period to period comparison lag report]] with an excel attachment.

{{:dat:obiee:bi_scheduler:obiee_delivers_smtp_result.jpg|}}

===== Support =====
If you have a problem, you can find the log in the directory :
OracleBI_HomeserverLogiBots

You have two types of files :
* the log file with a log extension
* the error file with a err extension

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

Tags: , ,

8 Responses to “Obiee – How to configure the Mail server of Oracle BI Scheduler/Delivers”

  1. Dean White says:

    I am getting the error message above when trying to set up the BI Scheduler to send email alerts.

    [nQSError: 75005] Failed to send AUTH command. 5.7.0 authentication failed

    Can anyone tell me what is causing this?

    Thanks

  2. gerardnico says:

    Just read the last part of the message : authentication failed.
    You may have a bad id and password. Verify them.
    http://gerardnico.com/wiki/smtp_telnet

    Success
    Nico

  3. rakesh says:

    iam trying to configure schedular but i have a doubt wht email i have to specify since as you mentioned in one of the mail set up link use GMX to get the smtp server details what i have to type in senders address since am using for practice purpose

  4. rakesh says:

    i have specified
    ibots
    senders address rockstar.rakesh@gmail.com
    smtpserver:mail.gmx.com
    smtp port: 25
    no of retries upon failures:1
    —–
    username :rockstarrakesh@gmax.com
    pswd:xxxxxxxxxxx

    but when i created the ibot and generated it it didnot work
    http://debaatobiee.wordpress.com/category/obiee/bi-delivers-and-schedulers/

    +++ ThreadID: 10a8 : 2010-03-06 11:54:45.817
    Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Unable to resolve the address for rakesh.
    Error Codes: AXSBMN8D:

    The operation completed successfully.

    +++ ThreadID: 10a8 : 2010-03-06 11:54:45.817
    …Trying main loop again.

    +++ ThreadID: 10a8 : 2010-03-06 11:54:45.817
    … Sleeping for 9 seconds.

    +++ ThreadID: 10a8 : 2010-03-06 11:54:57.120
    Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Unable to resolve the address for rakesh.
    Error Codes: AXSBMN8D:

    The operation completed successfully.

    +++ ThreadID: 10a8 : 2010-03-06 11:54:57.120
    Terminal Error: Exceeded number of retries.

  5. gerardnico says:

    May be you can’t send an email with an other domain (ie you may have to use rockstarrakesh@gmax.com instead of rockstar.rakesh@gmail.com).

  6. Thank you for some other magnificent post. Where else could anyone get that type of information in such a perfect approach of writing? I’ve a presentation next week, and I’m at the look for such info.

Leave a Reply