nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Using SA System Subject area method to deliver emails for Non OBIEE Users in OBIEE 11g

3174977

Hi,

We have a requirement where we need to send emails to non OBIEE users. for this we implemented the SA system subject area. We created SA System table and imported that into rpd and tried to create an agent .but then it's failing as below.

Am I missing anything..

AgentID: /users/weblogic/Test Agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test Agent

...Trying SMTP Delivery loop again... Sleeping for 5 seconds. AgentID: /users/weblogic/Test Agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test Agent

...Trying SMTP Delivery loop again... Sleeping for 2 seconds. AgentID: /users/weblogic/Test Agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test Agent

...Trying SMTP Delivery loop again... Sleeping for 3 seconds. AgentID: /users/weblogic/Test Agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test Agent

Exceeded number of SMTP delivery retries.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

SA System is NOT there for non-OBI users - it's explicitly FOR OBI users as OBI does an implicit login when you retrieve users through an analysis to populate recipients.

Gianni Ceresa

3174977 wrote:

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25).

Do you have some other agents sending out emails? Do they work?

The error message doesn't say anything about OBIEE users or non OBIEE users but just complain about not being able to connect to your SMTP ....

[Deleted User]

Apart from that...yeah;)

3174977

Hi Christian,

I checked the discussions and it says if we wanted to send emails through agents for NON BI users we can do that by setting up SA System Subject area. So now my question is can we implement this to send reports to NON BI users or not.

Please see the below.

[BI Delivers] How to send mail to NOT BI users

Emailing reports to non OBI users using IBots - ClearPeaks Blog ClearPeaks Blog

3174977

Hi GIanni,

I will check on other agents and will get back to you. Thank you !

Gianni Ceresa

These links are about OBIEE 10g ....

In 11g you have a button to add emails addresses directly.

3174977

Hi Gianni,

if that is the case then I added email directly and it's not showing in the recipient . please see the below.

Gianni Ceresa

I also have the same in agents with only email addresses.

The value of Recipients in the Overview is not supposed to list the users / emails receiving the result but the kind of recipients.

If you have OBIEE users it will be "specific recipients", if you choose to get recipients from a column of your condition it will display "Interested parties based on results", if you have only email addresses it display "none selected".

That's it...

3174977

Hi Gianni,

When I tried to run other agents I am getting the below error..

Eventually succeeded, but encountered and resolved errors...

Number of skipped deliveries: 1 of 2

AgentID: /users/weblogic/Test agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test agent

...Trying SMTP Delivery loop again... Sleeping for 3 seconds. AgentID: /users/weblogic/Test agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test agent

...Trying SMTP Delivery loop again... Sleeping for 5 seconds. AgentID: /users/weblogic/Test agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test agent

...Trying SMTP Delivery loop again... Sleeping for 8 seconds. AgentID: /users/weblogic/Test agent

[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). AgentID: /users/weblogic/Test agent

Exceeded number of SMTP delivery retries.

How to over come with this SMTP server issue..

Thanks !

[Deleted User]

Honestly I wouldn't recommend or do it since that's not the point or the purpose of SA System. As I said it's there for system users especially to serve them personalized content - hence the implicit login in order to get content specifically for each user returned from a subquery.