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.




Upgrade from 2.1 to 2.2 Nightmare!

web-app

We upgraded from 2.1 - 2.2 and have run into all sorts of problems!

  1. After the upgrade, the installation did not set the aspnetdb database correctly.  We fixed this by going into the web.config and setting the name from gemini to aspnetdb. 
  2. After the upgrade, all of our issue assignments were gone.  Apparently a new table was added called issueresource, but the upgrade process does not fill in the table, so we had to restore the old database and fill in this table manually with data from

    select issueid,assignedto, created from issues

  3. After filling in the assignment data, and clicking on "My Work" in Gemini, we get an error that says: No row with the given identifier exists: 0, of class: CounterSoft.Gemini.Commons.UserEN.  We have not yet figured this one out.  Any ideas?

  4. Email alerts do not work anymore.  If we test on the SMTP tab, the test message goes through fine, but when we comment or create and issue, no email is sent.  This happens using both the MailPlugin and the SchedulerService.  Still no fix for this one.  Any ideas?

  5. After installing the scheduler service, the service does not show up in services.  We had to manually run installutil.exe and pass the path of the service exe.  Now the service is started, but we still don't get emails!

 

This is by far the WORST upgrade installation yet for Gemini.  I understand that this release has a lot of changes in it, but seriously.  The upgrade should be as simple as running the upgrade utility.  There should be no manual process. 

I noticed that the price of the commercial license has now been doubled, and the users on the free license have now been cut in half!  It definately seems like there is a push to get people on the commercial licence (with good reason, it is a great product and countersoft deserves to make some money off it), but if they expect people to shell out almost $900 for the product and pay yearly for upgrade rights, the upgrades need to be a lot more solid. 

kprestage
· 1
kprestage
Replies (13)
helpful
0
not helpful

Issue 3 is now fixed.  Apparently for some reason we had rows in our 2.1 issue table with 0 as a userid.  running this fixed the problem  (Note 2 is the id of a valid user)

update issueresource set userid = 2 where userid = 0


kprestage
· 1
kprestage
helpful
0
not helpful

Do you have any errors in the log regarding the emails not being sent?

As for the upgrade process, how did you upgrade? Was it the EXE or did you run the scripts manually?

The upgrade script does move all resource assignment to the new table, I just wonder what could have gone wrong. Did you get any errors?

I fully understand your frustration and we will be working to make future upgrades robust so it will go smoothly.

Thanks for the good feedback,

CounterSoft.



Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

We usually do the manula upgrade but this time decided to try the exe!  Bad choice I guesss.  We checked all the right options (unchecked create blank database and selected to upgrade the database from 2.1).  All of our issues and projects, etc transferred fine.  It was only the issurresource table that did not get populated.  No errors on the install. 

As for the email.  It still isn't woring.  The log shows this:

Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it

SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)


kprestage
· 1
kprestage
helpful
0
not helpful

Is there a firewall issue here?

Also, what OS did you install the Scheduler Service on?  The installer should create the service!


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

Can you successfully telnet to the SMTP port for the SMTP server?

"telnet machinename 25"

 


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

No firewall involved.  We could email fine on all previous versions of Gemini, just not this one!

Scheduler (and Gemini) are on a Windows Server 2003 machine.


kprestage
· 1
kprestage
helpful
0
not helpful

Yes...the mail server works fine.  I have many other apps on the same machine that can communicate and send mail through the mail server fine.  In fact, in Gemini, on the SMTP settings tab, when I hit test, it sends the test message with no problem.  We just don't get any notifications from creating or updating issues.


kprestage
· 1
kprestage
helpful
0
not helpful

Understood, thanks.

Just to clarify: you receive an error is when sending alerts but not from the Test button?

Also, silly question, but are email alerts setup OK and are there any entries in the Event Viewer?


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

No error is received when hitting the test button, and the test message gets deleivered fine. 

All notifications are configured correctly

Below is what we see in the system log
Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 27/07/2007 12:10:53 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 27/07/2007 12:10:53 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 27/07/2007 12:09:58 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 27/07/2007 12:09:58 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 27/07/2007 12:07:52 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 27/07/2007 12:07:52 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 27/07/2007 12:06:16 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 27/07/2007 12:06:16 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 26/07/2007 16:37:45 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 26/07/2007 16:37:45 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 26/07/2007 14:43:04 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 26/07/2007 14:43:04 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 26/07/2007 14:43:04 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 26/07/2007 14:43:04 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A_0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 26/07/2007 14:16:18 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)


kprestage
· 1
kprestage
helpful
0
not helpful

The only thing I can think of is that the Gemini Scheduler Service is running under an account that cannot "see" the SMTP server (network privs?). Remember ASPNET will run under a different Windows Account and hence works.

?!


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

We now have email working using the scheduler service.  Still not working on the plugin though.  For the scheduler service, we reinstalled using the new install that was posted over the weekend and that corrected the issue.


kprestage
· 1
kprestage
helpful
0
not helpful

I'm having a very similar if not identical problem on version 2.2.2 using the MailerPlugin.. here is my error log:

 

Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 18:20:07 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 09/01/2008 18:20:07 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception No connection could be made because the target machine actively refused it 09/01/2008 18:15:51 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 18:15:51 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 18:10:12 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 09/01/2008 18:10:12 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 18:06:34 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 09/01/2008 18:06:34 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 17:30:27 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 09/01/2008 17:30:27 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 17:14:09 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)   No connection could be made because the target machine actively refused it 09/01/2008 17:14:09 SOURCE: System TARGETSITE: Void DoConnect(System.Net.EndPoint, System.Net.SocketAddress) STACKTRACE: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at q.a(IPEndPoint A0) Inner Exception Socket connection has been refused by remote host. InnerException message follows: No connection could be made because the target machine actively refused it 09/01/2008 16:58:55 SOURCE: CounterSoft.Gemini.Commons TARGETSITE: Boolean SendEmail(CounterSoft.Gemini.Commons.GeminiConfigurationEN, CounterSoft.Gemini.Commons.EmailAlert, CounterSoft.Gemini.Commons.IssueWatcherEN) STACKTRACE: at CounterSoft.Gemini.Commons.Emailer.SendEmail(GeminiConfigurationEN config, EmailAlert alertMessage, IssueWatcherEN recipient) at CounterSoft.Gemini.Business.MailPlugin.SendMail(String subject, ArrayList emailList, String body, Boolean bHTML)

etc..........

 

How do i resolve this issue?

 

Thanks


Dean
· 1
Dean
helpful
0
not helpful

Issue Resolved:

The FAQ indicated that i should switch the smtp server from smtp.x.com to pop.x.com which i did and it worked!!! But i'd just like an indication of why this is the case? Perhaps the FAQ could be updated to explain why this occurs.


Dean
· 1
Dean