I have SAP business object data service client XI 4.0 in Window 7 operating system .The Job server and all other cofigration are install on client side.I can access one repository.
Now, i want to send error log msg via mail.
when I try to send mail through smtp_to() function then it’s give an error-“Function <smtp_to> failed. SMTP Server is not defined. Specify a valid SMTP server using the Server Manager application”
so pls let me know,how to define SMTP server.
second, if I used mail_to function then generate error “There was no default login, and the user failed to log in successfully when the login dialog box was displayed. No message was sent”
I’m not understand what I do, so if any one have some suggestion then pls post it.
To define and enable the smtp_to function - follw the steps below :
In the function editor, click the System Function Category.
Click the smtp_to function name.
Click Next.
Define the input parameters as described in the Where table previously in this function description.
Click Finish.
Open the Data Services Server Manager:
In Windows, click Start > Programs > SAP Business Objects XI 3.2 > SAP BusinessObjects
Data Services > Data Services Server Manager.
In UNIX, run the Server Manager by entering:
$ cd $LINK_DIR/bin/
$ . ./al_env.sh
$ ./svrcfg
The Data Services Server Manager Utility window opens.
Enter the SMTP server settings:
Server name Type the name or IP address of the SMTP server (for example mail.company.com)
Sender Type the e-mail address that will appear in the From field of the e-mail.
I want to use smtp_to function in script, that’s are defined in the End of ETL but System Function should be define in query transform as you have mensioned .
so after configration in function_editor, may I use smtp_to function in script and I haven’t access of Data Services Server Manager.so there is any alternetive way to configure smtp server setting.
You can use smtp function in Scripts in the same way you are using in query transform. The only way to configure it is in server manager giving a from email address.
mail_to() does use the Microsoft propriety MAPI calls (=Outlook)
smtp_to() does use the open SMTP protocol used by anybody else, especially in the internet
For that reason and because you need Outlook installed on the server(!), everybody is using smtp_to().
In the jobserver configuration dialog you define the smtp server settings, then you just call that function.
I have a similar problem.
My scenario is as :
We have one distribution group say ‘Failure_Mail_group’.
And we have script in our catch block as :
mail_to(‘Failure_Mail_group@xxx.com’,‘Review Required’,‘Job Name’,10,10).
All my colleagues are able to receive failure mail whereas i am not able to receive any mails.
Your problem is not similar at all. It likely has something to do with the Outlook settings or Exchange settings, since DS is just using a MAPI call to send the mail and does not break apart the recipients of a group. Since it is being received by 1 person at least in the group, DS did it’s part and has no further actions.
Thanks for the answer.
I agree it is not the similar problem However since the topic was about mail_to function i posted my question here.
Coming back to your answer I agree that if one recipients receive the mail i should also receive and that is the reason i have posted a question.
Did you see the statement in my question ‘I am able to receive mail when sent to group through mailbox’…So that justifies that it has nothing to do with outlook settings.
I am not able to receive mail only through DS.
That is a false equivalency. If you want to truly test you need to log in to the DS Server and send an email from outlook installed on that machine. Even then, it only rules out the mail client, not your Exchange server. Data Services does not parse the email addresses sent to group addresses, so it cannot be the problem. It is only sending an email to one address, the forwarding for the group is handled by your mail server.
(BOB member since 2011-01-19)
(BOB member since 2007-12-26)
(BOB member since 2004-12-17)
(BOB member since 2005-09-16)
(BOB member since 2005-09-16)