Upgrade from 2.1 to 2.2 Nightmare!
We upgraded from 2.1 - 2.2 and have run into all sorts of problems!
- 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.
- 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
-
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?
-
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?
-
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 |
|
Thursday, July 26, 2007, 6:29:46 PM |
0
|
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 |
||||
|
0
|
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. |
||||
|
0
|
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. |
||||
|
0
|
Is there a firewall issue here? Also, what OS did you install the Scheduler Service on? The installer should create the service! |
||||
|
0
|
Can you successfully telnet to the SMTP port for the SMTP server? "telnet machinename 25"
|
||||
|
0
|
No firewall involved. We could email fine on all previous versions of Gemini, just not this one! |
||||
|
0
|
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. |
||||
|
0
|
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? |
||||
|
0
|
No error is received when hitting the test button, and the test message gets deleivered fine. |
||||
|
0
|
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. ?! |
||||
|
0
|
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. |
||||
|
0
|
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 |
||||
|
0
|
Issue Resolved: |
||||
|