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.




Gemini Scheduler Service Error In Application Log (Server was unable to process request)

web-app

I'm getting the following errors in the application log when the alert interval is supposed to be sent out.

Below is the sequence as it happens.

http://xxx/gemini/webservices

Sleeping for 5 minutes.

------------------------

http://xxx/gemini/webservices

114 issue alerts found.

------------------------

http://xxx/gemini/webservices

22 unique issue alerts identified.

------------------------

System.Web.Services - Server was unable to process request. ---> Project IDs are different! - at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at IssueServices.GetIssue(Int32 projectID, Int32 issueID)

at CounterSoft.Gemini.Scheduler.EmailAlertsProcess.ProcessIssueAlerts()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

------------------------

http://xxx/gemini/webservices

Sleeping for 5 minutes.

dnezamfar
· 1
dnezamfar
Replies (10)
helpful
0
not helpful

Two questions:

1. Did you move issues recently?
2. Is the webservices URL in Scheduler ok?

Cheers.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

1. I personally have not moved any issues recently. I'm also relatively certain nobody else has within the few projects we have running, but I have no way of knowing that for sure.

2. I am certain the URL is correct in the config file.


dnezamfar
· 1
dnezamfar
helpful
0
not helpful

Hi,

Can you join two tables on IssueID and see if the project ID's have changed? Tables in question: issues & issuealerts.

We will prepare another release of the Gemini Scheduler and send you link to test.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

Can you provide some step by step guidance on what exactly you want me to do? I'm not much of a SQL user to know how to join two tables or what the implications would be.


dnezamfar
· 1
dnezamfar
helpful
0
not helpful

Please run the following SQL command in query analyzer:

select a.issueid,a.projid,b.projid from issues a join issuealerts b on a.issueid=b.issueid and a.projid!=b.projid

If you get rows back it means that some issues have moved between projects.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I ran the command you specified and did not get anything back. It says query batch completed and no rows were returned.


dnezamfar
· 1
dnezamfar
helpful
0
not helpful

Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful
Happy to report that everything worked as I expected. Although... I was somewhat saddened that it didn't do what I thought it was going to. I thought that the scheduler service would merge all the alerts for the given time interval into just one e-mail. Kind of like a summary of all the alerts that happened in the last 30 minutes, or whatever the internal was. Because right now the scheduler basically sends out (if alerts are configured) dozens of e-mails potentially all at the same time instead of being sent as it happens.

So what would be nice is, if at the given interval, Gemini would send out only one e-mail with a summary of all the alerts, rather than sending a new e-mail out for each particular alert (some of them being redundant.

Thoughts?

I also noticed that the e-mails being sent out no longer show the specific change that was made. Current Version --> New Version or something to that effect. So one can't see immediately what has changed.


dnezamfar
· 1
dnezamfar
helpful
0
not helpful

Hi,

Two points:

1. The sceduler batches up changes for each issue and sends just one email for that issue. Previously, multiple issue changes resulted in multiple alerts.

2. We will be adding "End of Day Summary" report to the Scheduler.

3. What you refer to is a very good enhancement, please log and we will action!


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful
Ah ok... I see what's going on now. When I turned on the service I think I got bombarded with e-mails because it had a bunch of issues queued up to be e-mailed since it wasn't working before, but now that I tested it again I see that I have checked to be notified for every possible change, but I only got one e-mail saying that it has been updated.

I will definitely put in a enhancement request for the e-mail alerts to see what the changes have been made on the issue inside the e-mail.


dnezamfar
· 1
dnezamfar