Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Email notifications not being sent

emails

Hi there-

Email notifications aren't being sent from the Scheduler Service. I've verified that they are accumulating in the gemini_issueAlerts table and are being processed by watching the database in SQL profiler. Every few minutes they are picked up and then deleted. The strange thing is that they seem to be disappearing after that. There is no record in my SMTP logs indicating that they were received and queued up.

If I do a test email from Gemini, everything works correctly and I see it received and sent immediately in the SMTP logs.

I've verified that all check boxes are checked for notifications, that the engine is set to the Scheduler Service and my profile has alerts enabled as well.

Also, when set to MailPlugin for the alert engine I get the same result, no emails and nothing in the SMTP logs.

Here's what I get in the Application log when I have Debug mode set to Yes: 1) 1 issue alerts found. 2) 1 unique issue alerts identified. 3) Total email alerts sent successfully: 0 4) Total email alerts sent unsuccessfully: 0 5) Terminating 6) Terminating

From that it appears that the scheduler is eating them. No errors in either the application or system log. Server is Win 2003, Gemini version is 4.0

Thanks

dmullen
· 1
dmullen
Replies (9)
helpful
0
not helpful

Which version of the scheduler are you running?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I downloaded and installed the latest on Friday before posting this question.


dmullen
· 1
dmullen
helpful
0
not helpful

It seems like the alerts are not being sent because we couldn't find anyone who should receive them. Can you please your personal alerts for the project (Email Alerts link on the top right) and make sure that all boxes are ticked? Also, try and add yourslef as an item watcher and change it (make sure that you are set the receive your own changes in your profile), do you get any alerts?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hi Mark-

Under my profile, both "Receive email alerts" and "Email me my changes" are set to "Yes". Under the Email Alerts link for the project (never noticed that one before) all boxes were unchecked. I checked them all and made changes to the issue (changed description and added a comment) but still no email. I check the App Log events for the scheduler and it was identical to what I described in my original post.

I was already set as a watcher for the issue but went and added myself anyway. I did get a notification that I had been added as a watcher but this was instantaneous so I assume this notification does not go through the scheduler.

Thanks,

Dave


dmullen
· 1
dmullen
helpful
0
not helpful

Is it possible for you to send us a zipped backup of your database to support at countersoft dot com?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi Saar-

It's a little large to email (230 MB zipped). Are there any other options to upload it to you?


dmullen
· 1
dmullen
helpful
0
not helpful

Sure, send us an email to support and we will send you details.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful
ANSWER

Looks like you have upgraded your installation but did run create_procs.sql please do so.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

That was it. Thanks so much for the help!


dmullen
· 1
dmullen