data services sp6 mail problem

[Former Member]

Hi

Our new system is dataservices 4.2 sp6.(windows server 2012)

Our old system is data services 4.1 sp3(windows server 2008)

I open data service designer and crete new job to send mail.I use smtp_to('a@a.com', 'test', 'test', 0, 0) function;

when I run it, it says that "Failed to communicate with SMTP server on <QUIT> command"

the old and new system mail configuration are same.Old system works and new system doesnt work.What is thre problem.We cannot solve it.We need

urgent help.

Best Regards

[former_member187605]

Are you sure the smtp settings in the DS Server Manager are correctly set? And the server restarted?

[Former Member]

Hello

Yes we are sure the smtp settings in the DS Server Manager are correctly and we restarted services.Our old system works with no problem.

Our new system is dataservices 4.2 sp6.(windows server 2012)

Our old system is data services 4.1 sp3(windows server 2008)

We havent find solution for 1 week.You can see the difference above.

[former_member198401]

Ismail,

Can you check if the SMTP port usually 25 is blocked or not?

It has to do with Security settings

As your Administrator to compare the security settings.

Refer

Regards

Arun Sasi

[Former Member]

Hi Arun

I checked it.25 is not blocked.On this server,Business object sends mail but data serviseces sp6 cant.

Dataservice designer give the error:

"Failed to communicate with SMTP server on <QUIT> command. Please try to run it manually to see the actual error."

İn addition: there is a location (\\SAP\SAP BusinessObjects\Data Services\bin\smtp_mailer.exe) On command line ds sends mail successfully but I cant send mail on designer.

Our new ds 4.2 sp6 is installed on windows server 2012.Is there a problem related to windows server 2012?

[former_member198401]

Ismail,

I guess your assumption is correct.

Features Removed or Deprecated in Windows Server 2012

SMTP

SMTP and the associated management tools are deprecated. Though the functionality is still available in Windows Server 2012, you should begin using System.Net.Smtp. With this API, you will not be able to insert a message into a file for pickup; instead configure Web applications to connect on port 25 to another server using SMTP.

FYI

Below link might be useful..

HyperFive Hosting Blog: How to Setup and Configure the SMTP Service for Windows Server 2012

Regards

Arun Sasi

[former_member198401]

Any update Ismail..Is the SMTP issue resolved

[Former Member]

Hi Arun

1-I installed smtp service on our dataservice server.

2-I changed mail setting to dataservice server ip.I mean, I used dataservice server ip instead of smtp ip.

3-As your document,I configured the SMTP Service for Windows Server 2012

4-I run smtp_to function.There is no error but it doesnt send mail because  I couldnt route email messages from our dataservice server to smtp server.

I found workaround solution.I installed smtp program.I call this program from dataservice designer by using function.

smtp_to function doesnt work.I create  fn_smtp_to function.

Thanks for your support

[former_member198401]

So you used custom function to achieve email functionality.

Please share it if its possible. It will be really useful for other users who might face the issue

Regards

Arun Sasi

[Former Member]

Hi Arun

Yes, I used custom function to achieve email functionality.İt is easy.

1-First you should install smtp mailer program which has command prompt functionality.

2-Create a function that call your smtp mailer program and write necessary parameters.