DFC Code for sending e mail

Hi All,

I have a DQL query which fetches all the details of the current jobs which are running and active with all the status.

select r_object_id,object_name,a_last_invocation,a_current_status,is_inactive, title,a_last_completion,a_next_invocation,target_server,expiration_date from dm_job where is_inactive='0'

I want to create a job which runs this query every half hour and check for exceptions like Failed, Aborted etc.,

It would be of great help if you people help me in DFC Code for emailing an alert using the attribute a_current_status.

If there are any exceptions then only we should be able to send the email to specific email list.

Thanks in Advance!

Regards,

Raina

Find more posts tagged with

Comments

jeenathreddy.gade

Hello Raina,

Yes, You can write it. Just create one job and schedule it every half hour. Get a_current_status and wrtie down below DFC code for send alert email, if any jobs failure. Write below two utility methods and call from your method execution class.

/**
* Sends mail using the paraments passed
* @param smtpServerHostname
* @param recipientNames
* @param from
* @param subject
* @param emailBodyStr
* @param debug
* @return posted- returns true when the mail is sent successfully
* @throws Exception
*/
public boolean postMail(String smtpServerHostname, String[] recipientNames, String from, String subject, String emailBodyStr, boolean debug)
     throws Exception
{
   final String SMTP_HOST_NAME="mail.smtp.host";
   final String EMAIL_BODY_FORMAT="text/html; charset=UTF-8";
   boolean posted = false;
   Properties props = new Properties();
     props.put(SMTP_HOST_NAME, smtpServerHostname);
     Session session = Session.getInstance(props, null);
     session.setDebug(debug);
     String replyTo = from;
     try
{
      if(isDebugEnabled)
      {
       dflogger.debug("session..."+session);
      }
       MimeMessage msg = createMessage(session, subject, recipientNames, from, replyTo);
       msg.setContent(emailBodyStr, EMAIL_BODY_FORMAT);
       if(isDebugEnabled)
   {
    dflogger.debug("Sending mail....");
   }
       Transport.send(msg);
       if(isDebugEnabled)
    {
     dflogger.debug("Mail sent.....");
    }
        posted =true;
   }catch(MessagingException e)
   {
    if(isErrorEnabled)
   {
    dflogger.error("Failed to send the mail...."+e.getMessage());
   }
       String msg = "MessagingException: " + e.getClass().getName() + " " + e.getMessage();
         throw new Exception(msg);
   }
      catch(RuntimeException e)
   {
       if(isErrorEnabled)
   {
    dflogger.error("Failed to send the mail...."+e.getMessage());
   }
       String msg = "RuntimeException: " + e.getClass().getName() + " " + e.getMessage();
       throw new Exception(msg);
   }

      return posted;
}
/**
   * Sets email id, subject, recipients etc before sending mail
   * @param session
   * @param subject
   * @param recipientNames
   * @param from
   * @param replyTo
   * @return
   * @throws MessagingException
   */
private MimeMessage createMessage(Session session, String subject, String[] recipientNames, String from, String replyTo)
     throws MessagingException
{
   final String UTF = "UTF-8";
   final String MAILER = "X-Mailer";
   final String DOC_EVENT_TEMP="Documentum Event Template Sender Mailer";

      MimeMessage msg = new MimeMessage(session);
      if(subject != null)
          msg.setSubject(subject, UTF);
      InternetAddress toAddress[] = new InternetAddress[recipientNames.length];
         for(int i = 0; i < recipientNames.length; i++)
             toAddress[i] = new InternetAddress(recipientNames[i]);
         msg.addRecipients(javax.mail.Message.RecipientType.TO, toAddress);
      msg.setFrom(new InternetAddress(from));
      if(replyTo != null)
          msg.setReplyTo(new InternetAddress[] {
              new InternetAddress(replyTo)
          });
      msg.setHeader(MAILER,DOC_EVENT_TEMP );
      msg.setSentDate(new Date());
      return msg;
}

Let me know if it works.

Regards,

JeenatH

Raina

Hi Jeenath,

Thanks for your quick reply.

I tried copying the code in the Composer and I have added the necessary JARs.

Eventhough there are errors poping up in the program, here are the areas where I am getting the errors ..

Session session = Session.getInstance(props,null); (Error : The method getInstance(Properties, null) is undefined for the type Session)

session.setDebug(debug);

dflogger.debug("session..."+session); -- all the snippets where dflogger is having error ..

isErrorEnabled

isDebugEnabled

new MimeMessage(session); (Error : The constructor MimeMessage(Session) is undefined)

I would of great help if you could help me get out of these errors and let me know the JAR necessary to be added.

Thanks!

Raina

jeenathreddy.gade

Find my below respective inputs.

1. Session: import this package->import javax.mail.Session;

2. Delete all debug statements which are not required for you. I declared as global varaibles in class level.

3. new MimeMessage(session): import these below all packages.

import java.util.Date;
import java.util.Properties;
import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;

Add mail.jar file which is available in Documentum space.

Regards,

JeenatH

Raina

Hi Jeenath,

The following is the output that I am getting .. but the email is not working ..

We are not getting the emails ...

I have installed Developer Edition of Documentum and I have given the IP address of the machine in which the Documentum Developer Edition is installed.

Do we need to install any SMTP server or does Documentum Developer Edition includes it?

final

should we keep something else .. "mail.smtp.host" here?

String SMTP_HOST_NAME="mail.smtp.host";

Kindly help!!

DEBUG: setDebug: JavaMail version 1.4.2

DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun Microsystems, Inc]

DEBUG SMTP: useEhlo true, useAuth false

DEBUG SMTP: trying to connect to host "Asset ID of the host", port 25, isSSL false

220 Welcome to ESMTP Server

DEBUG SMTP: connected to host "Asset ID if the host", port: 25

EHLO Asset Host ID

250-Hello Asset Host ID

250-AUTH LOGIN

250-ENHANCEDSTATUSCODES

250-SIZE 0

250-STARTTLS

250-CHUNKING

250-8BITMIME

250 BINARYMIME

DEBUG SMTP: Found extension "AUTH", arg "LOGIN"

DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""

DEBUG SMTP: Found extension "SIZE", arg "0"

DEBUG SMTP: Found extension "STARTTLS", arg ""

DEBUG SMTP: Found extension "CHUNKING", arg ""

DEBUG SMTP: Found extension "8BITMIME", arg ""

DEBUG SMTP: Found extension "BINARYMIME", arg ""

DEBUG SMTP: use8bit false

MAIL FROM:<email id>

250 2.1.0 emailid Address Okay

RCPT TO:<email id>

250 2.1.5 emailid Address Okay

RCPT TO:<emailid>

250 2.1.5 emailid Address Okay

DEBUG SMTP: Verified Addresses

DEBUG SMTP: emailid

DATA

354 Please start mail input.

Date: Tue, 1 Jun 2010 16:41:08 +0530 (IST)

From: emailid

Reply-To: emailid

To: email ids list of recepients

Message-ID: <10883428.0.1275390668622.JavaMail.308026@Asst host ID>

Subject: Hi

MIME-Version: 1.0

Content-Type: text/html; charset=UTF-8

Content-Transfer-Encoding: 7bit

X-Mailer: Documentum Event Template Sender Mailer

First Mail

250 Mail queued for delivery.

QUIT

221 Closing connection. Good bye.

jeenathreddy.gade

First thing you need to find out 'smtp_host_name' and it should be pass to postMail() method as first parameter.

I am not sure whether you will get it Documentum Developer Edition or not.

And second thing you need to prepare recipientNames, subject, emailBodyStr...etc.

Try this one and let me know, if it works.

Regards,

JeenatH

Raina

Hi Jeenath,

This is the code that we are executing:

package p1;

import java.util.Date;
import java.util.Properties;

import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;

public class Mail {

/**
* @param args
*/

public boolean postMail(String smtpServerHostname, String[] recipientNames, String from, String subject, String emailBodyStr, boolean debug)
throws Exception
{
final String SMTP_HOST_NAME="mail.smtp.host";
final String EMAIL_BODY_FORMAT="text/html; charset=UTF-8";
boolean posted = false;
Properties props = new Properties();
props.put(SMTP_HOST_NAME, smtpServerHostname);
Session session = Session.getInstance(props, null);
session.setDebug(debug);
String replyTo = from;
try
{

   MimeMessage msg = createMessage(session, subject, recipientNames, from, replyTo);
   msg.setContent(emailBodyStr, EMAIL_BODY_FORMAT);

   Transport.send(msg);

   posted =true;
}catch(MessagingException e)
{
   String msg = "MessagingException: " + e.getClass().getName() + " " + e.getMessage();
   throw new Exception(msg);
}
catch(RuntimeException e)
{
   String msg = "RuntimeException: " + e.getClass().getName() + " " + e.getMessage();
   throw new Exception(msg);
}

return posted;

}

private MimeMessage createMessage(Session session, String subject, String[] recipientNames, String from, String replyTo)
throws MessagingException
{
final String UTF = "UTF-8";
final String MAILER = "X-Mailer";
final String DOC_EVENT_TEMP="Documentum Event Template Sender Mailer";

MimeMessage msg = new MimeMessage(session);
if(subject != null)
   try {
    msg.setSubject(subject, UTF);
   } catch (javax.mail.MessagingException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
InternetAddress toAddress[] = new InternetAddress[recipientNames.length];
for(int i = 0; i < recipientNames.length; i++)
   try {
    toAddress[i] = new InternetAddress(recipientNames[i]);
   } catch (AddressException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
try {
   msg.addRecipients(javax.mail.Message.RecipientType.TO, toAddress);
} catch (javax.mail.MessagingException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
try {
   msg.setFrom(new InternetAddress(from));
} catch (AddressException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
} catch (javax.mail.MessagingException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
if(replyTo != null)
   try {
    msg.setReplyTo(new InternetAddress[] {
      new InternetAddress(replyTo)
    });
   } catch (AddressException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   } catch (javax.mail.MessagingException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
try {
   msg.setHeader(MAILER,DOC_EVENT_TEMP );
} catch (javax.mail.MessagingException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
try {
   msg.setSentDate(new Date());
} catch (javax.mail.MessagingException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
return msg;
}

public static void main(String[] p){
try {
   new Mail().postMail("Ip address of the host on which Documentum is installed", new String[]{"List of Email IDs"}, "myemailid", "Hi", "First Mail", true);
} catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
}
}

}

Text in Red are the ones which we have changed while running the program.

Its not working ... kindly let us know how to proceed with this .. and what was your way of executing the program?

Have you installed any SMTP server for executing the program or anything else ..

please help ..

Thanks!

jeenathreddy.gade

We should give smtp server name, by default all companies/organizations have smtp server. Find out your's smtp server name and pass it.

If you does't have smtp server, then you can download free softwares which you can find out in google. Install it and pass smtp server name.

Try this one and let me know.

~jeenath.

stephanemarcon

Hi there,

My 50 cents here.

I'd personnaly go for using the standard Documentum message queueing mechanism as with SMTP communication, you won't be sure that your mail has effectively reached your target email list. If the smtp server is up, even if it cannot contact the target email address(es), you'll get a green flag, no errors. By queuing the message to a Documentum user or a group of users, you're sure the message is stored somewhere and can be traced. Let then the dm_event_sender script do its job by effectively sending an email message (you may want to declare a custom event for this). Anyways, those may be considered as details.... Do not hardcode any smtp server address as you should have it stored on the dm_server_config object, so the best is to get it from there.

Have a look at the following page which has some stuff that may be useful:

http://www.bluefishgroup.com/library/2005/configuring-and-customizing-documentum-email-facilities/

Regards,

Stephane

jeenathreddy.gade

Hello Raina,

Let me know, if you have still issues. Please don't forget to reward me whether is it Answered/Helpful?

Regards,

JeenatH.