Forum Stats

  • 3,853,528 Users
  • 2,264,231 Discussions
  • 7,905,381 Comments

Discussions

Email notification in Hyperion FDMEE blocked by firewall

Muhammad Jahanzeb
Muhammad Jahanzeb Member Posts: 51 Red Ribbon
edited Sep 20, 2018 3:44AM in Planning and Budgeting

I have set an email notification in Fdmee (EPM 11.1.2.4) when the data load rule export completes. I have tested on Test environment Linux (Firewall OFF) and on Production environment Linux (Firewall ON). It is working on test environment but unable to work on Production environment due to Firewall ON and gives an error of Smtp Failed.

Please anyone help me how can i able send email on production environment. Please find below the error and custom script.

Error:

2018-08-17 19:18:26,998 DEBUG [AIF]: CommData.updateWorkflow - END

2018-08-17 19:18:26,998 DEBUG [AIF]: Comm.executeScript - START

2018-08-17 19:18:26,999 INFO  [AIF]: Executing the following script: /u01/Oracle/FDMEE/HypLive/data/scripts/event/AftExportToDat.py

2018-08-17 19:18:27,012 INFO  [AIF]: ---------Execution Block Begin---------

2018-08-17 19:18:27,013 INFO  [AIF]: ---------Checking If LOC is GL---------

2018-08-17 19:18:27,013 INFO  [AIF]: Location Passed    = GL_LOC

2018-08-17 19:18:27,023 INFO  [AIF]: ERROR: SMTP process failed: (-1, 'SSL handshake exception')

2018-08-17 19:18:27,023 INFO  [AIF]: Mail Not Sent

AftExportToDat Script:

import smtplib

strLoc = fdmContext["LOCNAME"]

strCat = fdmContext["CATNAME"]

strPer = fdmContext["PERIODNAME"]

strFromAddress = "[email protected]"

strToAddress = "[email protected]"

strSubjectPV = "FDMEE RULE - Location: " + strLoc

strSubjectFV = "FDMEE RULE - Location: " + strLoc

strEmailMSGLinePV = "FDMEE Data Export was successful for Location:" + strLoc + ',' + "Category:" + strCat + ',' + "Period:" + strPer

strEmailMSGLineFV = "FDMEE Data Export was not processed or Failed for Location:" + strLoc + ',' + "Category:" + strCat + ',' + "Period:" + strPer + "."

strMessagePV = """\From: %s\nTo: %s\nSubject: %s\n\n%s

""" % (strFromAddress, "," .join(strToAddress), strSubjectPV, strEmailMSGLinePV)

strMessageFV = """\From: %s\nTo: %s\nSubject: %s\n\n%s

""" % (strFromAddress, "," .join(strToAddress), strSubjectFV, strEmailMSGLineFV)

fdmAPI.logInfo("---------Execution Block Begin---------")

fdmAPI.logInfo("---------Checking If LOC is GL---------")

fdmAPI.logInfo("Location Passed    = " + strLoc)

if strLoc =="GL_LOC":

try:

   smtpServer = smtplib.SMTP("10.xxx.xxx.xxx",25)

   smtpServer.ehlo()

   smtpServer.starttls()

   stat = fdmAPI.getProcessStates(fdmContext["LOADID"])

   fdmAPI.logInfo("Smtp server successful")

   if str(stat["EXPSTATUS"]) == "0":

    smtpServer.sendmail(strFromAddress, strToAddress, strMessagePV)

    fdmAPI.logInfo("Mail Sent, Export Successful")

   else:

    smtpServer.sendmail(strFromAddress, strToAddress, strMessageFV)

    smtpServer.quit()

    fdmAPI.logInfo("Mail Sent, Export Not Successful")

except Exception, e:

   fdmAPI.logInfo('ERROR: SMTP process failed: ' + str(e))

   fdmAPI.logInfo("Mail Not Sent")

else:

fdmAPI.logInfo("======================================================================")

fdmAPI.logInfo("GL Location Not Selected")

fdmAPI.logInfo("======================================================================")

fdmAPI.logInfo("Mail Not Sent")

fdmAPI.logInfo("======================================================================")

fdmAPI.logInfo("Process: End")

fdmAPI.logInfo("======================================================================")

Cord234Muhammad Jahanzeb

Best Answer

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Aug 30, 2018 6:34AM Answer ✓

    Calc Mgr and OHS  is installed on same box (FDMEE box) ?

    Do that "To" mail ID have rules to receive mail from any one from MSAD side??

    Can you test by keeping same mail ID which is used in your biz rules ?

    Cheers!

    Sh!va

    Muhammad JahanzebMuhammad Jahanzeb

Answers

  • Madhusudhan. M
    Madhusudhan. M Principal Consultant Member Posts: 1,908 Silver Trophy
    edited Aug 29, 2018 7:00AM

    You can write firewall rule to allow this from Production. Contact with Network or Firewall Team they will understand about this.

    Thanks,

    Mady

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Aug 29, 2018 7:13AM

    Ask your team to open Firewall for SMTP server and port 25 from your FDMEE box.

    Cheers!

    Sh!va

    Cord234Muhammad Jahanzeb
  • Muhammad Jahanzeb
    Muhammad Jahanzeb Member Posts: 51 Red Ribbon
    edited Aug 30, 2018 3:50AM

    I have opened the Smtp server port 25 in Firewall, but the issue is same. Please tell me how to open port 25 from fdmee box..

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Aug 30, 2018 4:05AM

    Are you able to telnet to smtp server with port 25 ?

    Run below command on FDMEE box:

    telnet smtp_server(10.xxx) 25

    if you get "_" as response then ports are open and you need to dig further ..else ask your network team to open the ports.

    Cheers!

    Sh!va

    Muhammad JahanzebMuhammad Jahanzeb
  • Muhammad Jahanzeb
    Muhammad Jahanzeb Member Posts: 51 Red Ribbon
    edited Aug 30, 2018 6:27AM

    Yes, i am able to telnet smtp server with port 25 with response is:  Connected. Secondly i am able to receive emails of business rules successfully, only the problem is in fdmee notification.

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Aug 30, 2018 6:34AM Answer ✓

    Calc Mgr and OHS  is installed on same box (FDMEE box) ?

    Do that "To" mail ID have rules to receive mail from any one from MSAD side??

    Can you test by keeping same mail ID which is used in your biz rules ?

    Cheers!

    Sh!va

    Muhammad JahanzebMuhammad Jahanzeb
  • Muhammad Jahanzeb
    Muhammad Jahanzeb Member Posts: 51 Red Ribbon
    edited Aug 31, 2018 8:44AM

    Yes ohs and calc mgr is on same server. Yes i have tested by keeping same email id. Is there any settings to do in fdmee for smtp or email notification?

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Aug 31, 2018 8:49AM

    If FDMEE is diff box , then i doubt about SMTP server/port open from that box.

    There are no special setting for email in FDMEE, you can run SMTP test from your FDMEE box.

    Google "smtp command to send mail from cmd" and you will get n number of links. if you receive mail by this test and not from FDMEE better to raise SR with oracle to look into it.

    Cheers!

    Sh!va

This discussion has been closed.