Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Sending email in OBIEE 11g: Failed to open connection to SMTP server

Received Response
81
Views
10
Comments
1503342
1503342 Rank 2 - Community Beginner
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

I am trying to send an email with SSL in OBIEE11g, when running an ibot, but the agent fires an error:

THE AGENT zzzz, has failed. [nQSError: 75027] Failed to open connection to SMTP Server (host mail.xxxxxxx.es; port 465). AgentID: /users/weblogic/zzzz

I checked with network administrator to find if the smtp server name is correct, and it's ok, and the user name and password is required. I looked at the document id 1324893.1 but this has not solved anything.

By the way, when I send an email with OBI Publisher, it's work.

The OBIEE11g version is 11.1.1.5

Thanks.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Knowing the server name is right doesn't mean it works.

    Did you try to open a connection with the SMTP server from the BI Server?

    The name is maybe correct but there is a firewall in between or the BI Server doesn't resolve the name to the IP your mail server really is etc.

  • 1503342
    1503342 Rank 2 - Community Beginner

    Hi,

    I have a test port access to the mail server with Telnet and it's work.

    I have executed this command:

    nc -zv mail.xxxxxxxxxxxxxxxxxxxxxx.es 465

    Connection to mail.xxxxxxxxxxxxxxxxxxxxx.es 465 port [tcp/smtps] succeeded!

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Did you run that from your machine, or from the OBIEE server? Also, OBIEE 11.1.1.5 is *old*. You might want to consider moving to 11.1.1.9 so that you stay within support.

  • 1503342
    1503342 Rank 2 - Community Beginner

    from the OBIEE server

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did it ever work at some point? OBIEE never managed to send a single email?

  • 1503342
    1503342 Rank 2 - Community Beginner

    OBIEE worked ok. The problem occurs when the mail server is switched to SSL.

    If I send the mails to a non-SSL server it works ok.

    Could the problem be the certificate?

  • Joel
    Joel Rank 8 - Analytics Strategist

    Possibly. Have you done the SSL SMTP server configuration?

    https://docs.oracle.com/cd/E23943_01/bi.1111/e10543/ssl.htm

  • 1503342
    1503342 Rank 2 - Community Beginner

    I had followed item 5.3.2 of that document

  • Joel
    Joel Rank 8 - Analytics Strategist

    In which case, I think that you should look at your SSL certificate.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    1503342 wrote:The problem occurs when the mail server is switched to SSL.If I send the mails to a non-SSL server it works ok.Could the problem be the certificate?

    Bingo !

    98.5% of chances you will find your solution if you look into the SSL config you did (certificate etc.).

    Things almost never happen just like that