Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using SA System Subject area method to deliver emails for Non OBIEE Users in OBIEE 11g
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.
Answers
-
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.
0 -
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 ....
0 -
Apart from that...yeah;)
0 -
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
0 -
Hi GIanni,
I will check on other agents and will get back to you. Thank you !
0 -
These links are about OBIEE 10g ....
In 11g you have a button to add emails addresses directly.
0 -
Hi Gianni,
if that is the case then I added email directly and it's not showing in the recipient . please see the below.
0 -
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...
0 -
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 !
0 -
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.
0
