Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

ppm could not send email

SOLVED
Go to solution
Highlighted
riznad
Regular Collector

ppm could not send email

Hello;
Our system can not sent email notifications.
I run notification history report and in this report all emails are seen as not sent.

As I remember the parameters on Open > administration > Schedule services determines the email natifications.
The parameters on this page:
Notification Cleanup Service
Notification Service
RM Notification Service
Time Sheet Notifications

are set to Y.

Is there any other parameter on server.conf or is there any problem on smtp server connection?

Could you guide me?
Kind Regards

23 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: ppm could not send email

Check these paramters in server.conf and verify that these are correct.

 

com.kintana.core.server.SMTP_SERVER=
com.kintana.core.server.EMAIL_NOTIFICATION_SENDER=

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
AlexSavencu
Honored Contributor

Re: ppm could not send email

Hi,

 

you should also check the server log file for the exact error.

 

cheers

alex


--remember to kudos people who helped solve your problem
Mohit_Agrawal
Frequent Visitor

Re: ppm could not send email

Hi..

 

If you have just configured your PPM and it's not sending the notifications then you need to check the two above parameters (suggested by Utkarsh) in server.conf.

 

If the PPM was sending the notifications properly before, then this issue might be beacuse the associated directory is full to its capacity. You can check and archive the old logs and restart the server. This should work.

 

We also faced this issue sometimes before and as soon as we archived the old logs, all the stcuk notifications got triggered.

 

Thanks!!
--Mohit Agrawal
--Remember to give Kudos, if this solves your query!!

riznad
Regular Collector

Re: ppm could not send email

Hi Motih;

I requested server admin to apply this:

Test smtp server

1. Open a shell or command window.

2. Logon to the SMTP server. Typically, the default SMTP port is 25. However, please check with the SMTP server admin to validate.

$ telnet SMTP_HOST 25

3. If the SMTP server is up, you'll get some SMTP host information and "ready" message.

4. Enter "mail from: email_account" Should get confirmation message like "250 OK - mail from "

5. Enter "rcpt to: rcpt_email_address" Should get confirmation message like "250 OK - Recipient "

6. Enter "data" Should get confirmation message like "354 Send data. End with CRLF.CRLF"

7. Enter "Subject: Testing" No confirmation messages.

8. To exit, enter . Should get confirmation message like "250 OK"

 

The server admin indicated that there is no error on telnet and relay permission.

But the ppm server cannot sent email.

 

The parameter:

Notification Cleanup Service is set to every24 hours.

Shall I shorten the parameter?

Both the two parameters onserver.conf has not changed. And the admin says that it is correct.

 

Any idea?

Kerim KILIC
Frequent Visitor

Re: ppm could not send email

just an idea, can you validate this from application server? may be av blocking smtp connection
riznad
Regular Collector

Re: ppm could not send email

Hi Kerim;

No prolem on communication between app and smpt.

 

When we restart there is the error:

ERROR JSESSIONID=43F03896E323E9DB5A918255FDDE476C.TFKB_PPM_PROD,USERNAME=cc005378:http-0.0.0.0-8080-Processor21:com.mercury.itg.core.notification.NotificationManager:2012/08/09-08:26:18.728 EEST: SAXException: Failed to parse notification manager configuration. Notification manager is now disabled and custom extensions will not execute.

 

I am checking server.log

 

 

Bu arada buralara giricek boş zamanı nereden buluyorsun? Yokmu senin projelerin .)

d4y4n4
Frequent Visitor

Re: ppm could not send email

I have seen the error before, The issue is likely to be caused by TM Approver Evaluation Service failures

Please run these two queries to check problematic records. If there are any, please make a backup and remove them.

select * from tm_pending_approvers_evals where source_id is null;

select * from tm_pending_approvers_evals where source_type='OVR_ID' and OVR_WORK_ITEM_SET_ID is null;

And also delete duplicate records from this table using the following SQL:

DELETE FROM tm_pending_approvers_evals a WHERE ROWID > (SELECT MIN (ROWID) FROM tm_pending_approvers_evals b WHERE b.source_type = a.source_type AND b.source_id = a.source_id);

Then restart the server.

Hope this helps.

Regards,
Dayana Campos
riznad
Regular Collector

Re: ppm could not send email

Hi;

Thanks for your interest.

those 3 queries returned no results.

 

select * from PPMTFKB_USR.tm_pending_approvers_evals where source_id is null;

select * from PPMTFKB_USR.tm_pending_approvers_evals where source_type='OVR_ID' and OVR_WORK_ITEM_SET_ID is null;

select *
FROM PPMTFKB_USR.tm_pending_approvers_evals a WHERE ROWID > (SELECT MIN (ROWID) FROM PPMTFKB_USR.tm_pending_approvers_evals b WHERE b.source_type = a.source_type AND b.source_id = a.source_id);

riznad
Regular Collector

Re: ppm could not send email

Hello;

There is no value on from field on workflows.

Do you think that is the problem?

Jim Esler
Honored Contributor

Re: ppm could not send email

The default sender address is defined by the EMAIL_NOTIFICATION_SENDER configuration value. Check the Server Configuration report to see what it is set to. You can add the following to server.conf to set it or change it:

 

com.kintana.core.server.EMAIL_NOTIFICATION_SENDER=<the desired email address>

sdef
Member

Re: ppm could not send email

make sure you set the smtp host and port correctly on server.conf.

and everytime you make changes in the server.conf file be sure to restart your server.

 

Goodluck!

riznad
Regular Collector

Re: ppm could not send email

Hi;

Our situation is strange.

Time management notification is sent.

For example resource request on staffing profile is sent to the resource pool manager.

 

cotocald
Regular Collector

Re: ppm could not send email

Just to clarify? Is your system able to send emails at all?

Can you describe the current situiation?

 

Regarding with your error:

"Notification manager is now disabled and custom extensions will not execute"


The appearance of this error message is not all that random. We have determined that this error message is related to a timesheet event handling system that tries to notify various pieces of our code about changes in a timesheet's state. So the admin would most likely see an error in the logs for the 1st time when the users try to do something related to timesheets - create, update, save etc.

Having said that, these errors can be ignored, this functionality seems completely obsolete.

 

Please clarify

-- Remember to give Kudos to answers! (click the KUDOS star)
Cords
Occasional Contributor
Solution

Re: ppm could not send email

Hi Riznad,

 

 

Try to restart the notification service in the Open > administration > Schedule services by disable and enable it.

 

It use to sync the time of scheduled notification and the time of the machine.

 

 

 

 

 

Regards,

 

Cris

d4y4n4
Frequent Visitor

Re: ppm could not send email

Hi,
Try to specify the from and reply to, if the issue persist, then let me know. Otherwise please make this as solved!
• Check the EMAIL_NOTIFICATION_CHECK_INTERVAL parameter (determines the interval (in seconds) before the Kintana Server will check if there are notifications waiting to be sent out).
• Check the DATE_NOTIFICATION_INTERVAL parameter (determines the interval (in minutes) that the Kintana Server will check to send date-based notifications).
• Make sure the SMTP Server is correctly entered in the server.conf file and the SMTP Server is accessible from the Kintana server & is up & running.
• Check the table KNTA_NOTIF_TXN_PARENTS which has a column NOTIFICATION_SENT_FLAG having values 'N' and 'Y' . This value is default to 'N' when a notification is generated and once the notification is sent to the SMTP server the value of this flag is set to 'Y'.
• Try changing the value of this flag to 'N' and let the ITG scheduler to send the mails the value will be updated to 'Y' once the notification is sent.
• Try the following steps:
1. Stop PPM server.
2. Delete work & tmp folders from PPM_HOME/server/SERVER_NAME (repeat for all nodes)
3. From the command prompt under PPM_HOME/bin run: sh kJSPCompiler.sh
4. Re-start PPM server
5. From the command prompt under PPM_HOME/bin run: sh kRunCacheManager.sh
6. Clean browser and java cache from the machines.

Regards,
Dayana
riznad
Regular Collector

Re: ppm could not send email

Hi;

I disable and enabled service several times.

Now our system can send email.

thans for your help.

d4y4n4
Frequent Visitor

Re: ppm could not send email

Great! Please remember to mark this as solved!

Regards,
Dayana Camppos
Jerwi
Regular Collector

ppm 9.14 could not send email

Dear All,

 

We faced problem with our PPM 9.14 that the PPM 9.14 could not send email since two weeks ago.

we already did some of workarounds bellow but the problem still exist :

 

1. Restart PPM Notification service by kRunServiceManager.sh command

2. Successfull telnet from PPM server to smtp mail server

3. Successfull testing send email used command from PPM server to smtp mail server.

4. Disable and enable Scheduled notification service from administration console

5. Check server.conf file and no configuration change in server.conf file for smtp configuration

 

anyone can help us ?

 

Many thanks for your replied.

 

Regards,

Jermias

 

 

Jerwi
Regular Collector

Re: ppm 9.14 could not send email

sorry i posted here because no privilege to create a new post.

 

anyone can help ?

many thanks.

 

Regards,

Jermias

Mohit_Agrawal
Frequent Visitor

Re: ppm 9.14 could not send email

Hi Jermias,

 

If you have already tested all the above mentioned scenarios and still unable to send notifications. Then try archiving the logs of the PPM...and restart then..it should work

 

 

Thanks!!

Mohit Agrawal

Vibhor_Dwivedi
Acclaimed Contributor

Try debugging

When any event is triggering from front end.. Is apropriate entry getting created in the Notification table in DB?

 

Are there any other environment using same SMTP server? is it working?

 

Share server.conf entries for email notifications...

Jerwi
Regular Collector

Re: ppm 9.14 could not send email

HI Mohit,

 

could you give the steps to archieve the PPM log ? and any issue will happen if we archieve the PPM log?

for archieving the PPM log, is it not automatically do by PPM system ?

 

many thanks for your answer and help.

 

Regards,

Jermias

mbkishorekumar
Acclaimed Contributor

Re: ppm could not send email and all scheduled Job failed

Hi All,

This is server error log. Could please let me know the root for this issue.

Thx in advnce 

 

Job (PPM_SERVICES._NOTIFICATION_SERVICE threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.RuntimeException: javax.naming.CommunicationException [Root exception is java.rmi.ConnectException: Connection refused to host: 10.21.125.203; nested exception is:
java.net.ConnectException: Connection timed out: connect]]
at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
java.lang.RuntimeException: javax.naming.CommunicationException [Root exception is java.rmi.ConnectException: Connection refused to host: 10.21.125.203; nested exception is:
java.net.ConnectException: Connection timed out: connect]
at com.mercury.itg.core.jms.JmsConnectionFactoryProxy.createConnection(JmsConnectionFactoryProxy.java:28)
at org.springframework.jms.support.JmsAccessor.createConnection(JmsAccessor.java:184)
at org.springframework.jms.core.JmsTemplate.execute(JmsTemplate.java:461)
at org.springframework.jms.core.JmsTemplate.send(JmsTemplate.java:539)
at org.springframework.jms.core.JmsTemplate.convertAndSend(JmsTemplate.java:617)
at org.springframework.jms.core.JmsTemplate.convertAndSend(JmsTemplate.java:609)
at com.mercury.itg.core.jms.service.impl.ServiceMessageSender.sendMessage(ServiceMessageSender.java:99)
at com.mercury.itg.core.jms.service.impl.ServiceMessageSender.sendMessage(ServiceMessageSender.java:81)
at com.mercury.itg.core.scheduler.service.impl.GenericJob.sendMessage(GenericJob.java:136)
at com.mercury.itg.core.scheduler.service.impl.GenericJob.execute(GenericJob.java:63)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: javax.naming.CommunicationException [Root exception is java.rmi.ConnectException: Connection refused to host: 10.21.125.203; nested exception is:
java.net.ConnectException: Connection timed out: connect]
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:155)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:88)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:153)
at com.mercury.itg.core.jms.JmsConnectionFactoryProxy.createConnection(JmsConnectionFactoryProxy.java:23)
... 11 more

  

 

//Add this to "OnDomLoad" event