Project and Portfolio Management Practitioners Forum
cancel

PPM 9.14 - Timesheet notifications are not going out

Highlighted
KarTSK
Frequent Contributor.

PPM 9.14 - Timesheet notifications are not going out

The timesheet notification service is up and running fine.  But the email notification is not going out.  It was set up correctly in the Timesheet policy too.  Until last month it was going smoothly.  Nothing went into PRODUCTION after that.  It didn't go this month as expected.  The next run is set for 1st day of the moth.  I need to correct it before.

 

Can someone please suggest me.  I cleared all the caches and restarted the nodes.  Still same.  

10 REPLIES
Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

I don't know if this will work in your case but when I had an issue with notifications not going out I had to stop the service and restart it and it solved the problem.

 

Just a thought

Mig

KarTSK
Frequent Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Thanks for your reply.  Actually i tried that option, restarted the services, nodes, cleared the caches and everything.  Still the same.  The only thing I could think of between the last notification period and this notification period is, in between there was Linux server patching.  Would that caseu any issue on this ?

Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

That would be outside of my expertise since I haven't ran into that issue yet, my Unix team did upgrade JAVA without letting me know and I had an issue bringing nodes up because of that but that's an entireley different matter.

 

If someone else knows please feel free to pitch in.

 

Are you able to make a new policy that would send notifications weekly so you can test and see if the new notification would work?

 

Thanks!

Mig

KarTSK
Frequent Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Hi - Yes, exactly.  That is what my final option is.  I am going to try that.  I will let you know.  Thanks for your reply.

Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Hello Kar,

I just wanted to see if you managed to get your issue resolved.

 

Thanks!

 

KarTSK
Frequent Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Thanks for the follow up.  Unfortunately, my problem is not yet resolved.  I am working with HP on this and we are currently doing mulitple testings in our DEV server.  No luck :(.  We are reaching our next set of notification day in another 9 days.  Hoping to resolve by then.  Fingers crossed :)

Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Well it's good to know that you are getting help on the issue, hopefully it will be resolved in time before the new emails have to go out.

 

Were you able to create a new notification that should go out weekly for testing purposes?

 

I would like to know the solution that comes out of this in case for some reason I end up facing this same issue, currently our notifications go out weekly even though the time period is twice a month.

 

Thanks!

Mig

Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Hello KarTSK,

Where you able to find a solution to the notification issue? it seems that after the upgrade I am facing the same problem and I'm about to start troubleshooting it.

 

Thanks!

Mig

KarTSK
Frequent Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out


Scorpex wrote:

Hello KarTSK,

Where you able to find a solution to the notification issue? it seems that after the upgrade I am facing the same problem and I'm about to start troubleshooting it.

 

Thanks!

Mig


Hi Everyone !! Thanks a lot for all your support.  Finally, the issue with the timesheet notification was resolved.  It took couple of months to resolve.  But glad that we were able to get into the solution.

The cause was, due to the time period stamp was missing in a table.  It was suppose to be '2015-07-31 23:59:00" instead of '2015-07-31 00:00:00".  Because of which the timesheet notification query is not picking up the row to send it.  As soon as we updated the timestamp the notification successfully sent.    Attached the sample.

 

The table name was : ktmg_periods

Scorpex
Super Contributor.

Re: PPM 9.14 - Timesheet notifications are not going out

Well I'm glad to hear that your issue was resolved, I had a similar issue but it was due to the BCC field, I ended up creating a trigger that would change BCC to TO and it resolved my issue, I know this is temporary but as soon as HP sends me the Hotfix I might implement that.

 

Thanks!

Mig