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 Flood After Installing Scheduler 2.0.1.1972 With Gemini 3.0.1

web-app

I have just installed the Scheduler Service 2.0.1.1972 on my Gemini server, and now all of my developers are getting flooded with emails from Gemini with no subject or body.  I opened Event Viewer, and here is what I see:

System.Xml - There is an error in XML document (1, 6). -    at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Xml.Serialization.XmlSerializer.Deserialize(Stream stream)
   at CounterSoft.Gemini.Commons.GeminiHelper.GetIssueEN(Byte[] abData)
   at CounterSoft.Gemini.Scheduler.EmailAlertsProcess.MakeAlertMessage(IssueEN issue, IssueCommentEN lastComment, ArrayList changeLog, IssueAlertEN alert, IssueWatcherEN recipient, String language)


System.Xml - There is an error in XML document (1, 6). -    at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Xml.Serialization.XmlSerializer.Deserialize(Stream stream)
   at CounterSoft.Gemini.Commons.GeminiHelper.GetIssueEN(Byte[] abData)
   at CounterSoft.Gemini.Scheduler.EmailAlertsProcess.ProcessIssueAlerts()

I had to stop the service and switch back to the other email notifications until this is resolved.

Thanks!

thebizrock
· 1
thebizrock
Replies (6)
helpful
0
not helpful

Please delete all rows from the issuealerts table.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Looks like that solved the issue.  Thanks a lot!


thebizrock
· 1
thebizrock
helpful
0
not helpful

Sorry about cross-posting - I was searching the forum for answers and found this error matches my current error.

I run

SELECT [alertid]

,[issueid]

,[projid]

,[userid]

,[servicecomment]

,[alertdata]

,[created]

FROM [Gemini].[dbo].[issuealerts]

and get 0 rows, yet I get thousands of lines of the error

System.Xml - There is an error in XML document (1, 6). -

 

in my Windows event viewer.  Now where can I turn?  What next?


TCooper
· 1
TCooper
helpful
0
not helpful

truncate the gemini_issuealerts table.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I'm defnitely not a SQL Server guru, but I don't seem to have a table called gemini_issualerts.

 

I do have one called Gemini.dbo.issuealerts, which has 0 rows.

 

I'm running 2.2.6 - might that be the reason I have a different table name?


TCooper
· 1
TCooper
helpful
0
not helpful

Can you use SQL Managment studio / Enterprise manager to check the tables and owners?

Gemini will not attempt to send emails if the table is empty.


Saar Cohen
· 5000
Saar Cohen