Scheduling a mail

CloverDX Platform
1

i want to schedule a mail when particular scheduled graph finishes with status FINISHED_OK. i ve created a event listener for sending a mail. But am getting an error saying smtp host localhost not found and port issues.

where do i need to set these values ?

is there anyway i can send reports to people on weekly basis to give the updated value to concerned ppl after i run my incremental load using scheduler.

Thanks,

Swathi

2

Hi Swathi,

Please define server properties with prefix “clover.smtp”. List is available here http://doc.cloveretl.com/documentation/ … rties.html Here is described how to set this properties: http://doc.cloveretl.com/documentation/ … urces.html

Regarding second question: What about store results you want to send into file. Then prepare scheduled task which will read this file and send mail every week.

3

Hi Jaroslav Kubos,

Am not able to find that file CloverServer.properties. I have installed a stand alone tomcat to run cloverETL server. Where can i find it ? Is there any work around for my situation.

Thanks,

Swathi

4

Hi Swathi,

You should change file mentioned in one link I sent you: http://doc.cloveretl.com/documentation/ … urces.html

[tomcat_home]/conf/Catalina/localhost/clover.xml

5

Hi Jaroslav Kubos,

i changed the context.xml to this…but the xml file is not showing any content when opened in IE. is there some format problem ? Pls let me know how to solve this .

<?xml version="1.0" encoding="UTF-8"?><Resource name="mail/MailSession" auth="Container"type="javax.mail.Session" clover.smtp.transport.protocol="smtp" clover.smtp.host="smtp.gmail.com" clover.smtp.port="587"

clover.smtp.authentication=“true” clover.smtp.username=“fcs1337@gmail.com” clover.smtp.password=“pwd” mail.smtp.socketFactory.class=“javax.net.ssl.SSLSocketFactory”
/>

Thanks,

Swathi

6

Hi,

please change *[tomcat_home]/conf/Catalina/localhost/clover.xml* and NOT “context.xml”

Also according to documentation, correct code in clover.xml is:


<?xml version="1.0" encoding="UTF-8"?>
<Context path="/clover" crossContext="true">
  <Parameter name="clover.smtp.transport.protocol" value="smtp" override="false" />
  <Parameter name="clover.smtp.host" value="smtp.gmail.com" override="false" />
  <Parameter name="clover.smtp.port" value="587" override="false" />
  <Parameter name="clover.smtp.authentication" value="true" override="false" />
  <Parameter name="clover.smtp.username" value="fcs1337@gmail.com" override="false" />
  <Parameter name="clover.smtp.password" value="pwd" override="false" />
  <Manager pathname=""/>
</Context>

I hope this helps.

7

Hi Jaroslav Kubos,

Thanks for guidance. I tried the way you suggested am getting the following error. So i changed the context.xml as

But its not helpin me. following is the error:

: 530 5.7.0 Must issue a STARTTLS command first. s8sm921276wif.9 - gsmtp

at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1668)
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1207)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:735)
at com.cloveretl.server.f.f.process(Unknown Source)
at com.cloveretl.server.events.a.e.doProcess(Unknown Source)
at com.cloveretl.server.events.a.e.process(Unknown Source)
at com.cloveretl.server.events.a.g.a(Unknown Source)
at com.cloveretl.server.events.a.g.notifyListener(Unknown Source)
at com.cloveretl.server.events.ServerEventNotificator$NotifyListenerTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

8

Hi,

as documentation says http://doc.cloveretl.com/documentation/ … rties.html , extra SMTP parameters may be passed with “clover.smtp.additional.*” prefix. In your case:


<Parameter name="clover.smtp.additional.starttls" value="true" override="false" />

I hope this helps.

9

Hi,

Its not helping me in anyway. Still getting the same error as previous one. how can i proceed ?

error-----------------------------

com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. k7sm42686208een.8 - gsmtp

at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1668)
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1207)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:735)
at com.cloveretl.server.f.f.process(Unknown Source)
at com.cloveretl.server.events.a.e.doProcess(Unknown Source)
at com.cloveretl.server.events.a.e.process(Unknown Source)
at com.cloveretl.server.events.a.g.a(Unknown Source)
at com.cloveretl.server.events.a.g.notifyListener(Unknown Source)
at com.cloveretl.server.events.ServerEventNotificator$NotifyListenerTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

-------------------------------------------------------------------------------------

thanks,

Swathi

10

What version of Server do you use?

Try to use parameter sets mentioned here: http://stackoverflow.com/questions/3860 … oogle-apps

11

Hi,

I tried the way u suggested its not helpin me out.

We are using tomcat 6 server and endeca server being 7.4.0

Thanks,

Swathi

12

Hi,

Am using apache tomcat 6.0 server to run cloverETL server.

I tried the same parameters but stil getting the same error as

Must issue STARTTLS command first

Can anyone help me regarding this ?

Thanks,

Swathi

13

Hi Swathi,

We tested it and unfortunately gmail access is working since 3.4M1 version. Your Data Integrator Server does contain older release and therefore it is not possible to use gmail.

We are sorry for any inconveniences.