Red Gate forums :: View topic - sql response - can it cause a system to halt?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

sql response - can it cause a system to halt?

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
randyv



Joined: 28 Feb 2007
Posts: 113

PostPosted: Tue Mar 30, 2010 1:17 pm    Post subject: sql response - can it cause a system to halt? Reply with quote

We started having a problem on 3/19 - our production server was halting.
Initially this appeared in the Event log as a series of cascading MSMQ failures caused by a login failure from a remote server. The strange thing about this login failure what the login name, it was ''. (Blank).
Further analysis shows the cascade was a symptom of TCP/IP halting, apparently due to the cascading errors raised when '' failed to login.

After eliminating any job making a remote call to the production server from the remote server, I ascertained that the only other thing that could possibly be wanting to login to the production server from the remote server was SQL Response, as the remote server hosts the repository Shocked .

I halted the service on the remote server yesterday and we ran fine.
This morning I came in and started the service and in short order the production server halted again.

Making this more problematic - the production server is running a software package that is on its last legs, and we are not supported by the vendor. We are starting a migration to a new system next month, but for now, I cannot do much meddling with updates and such to the production server.

I hate to not use SQL Response as it has been invaluable to us here for the past year plus - but I cannot keep having everyone log off to restart this server 2 or 3 times a day.

Any suggestions?
_________________
What we do in life echoes in eternity <><
Randy Volters
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Wed Mar 31, 2010 4:36 pm    Post subject: Reply with quote

Thank you for your post and sorry that you have encountered a problem.

A support call has been created for you, the call reference is F0033075

Can you please locate the SQL Response Alert Repository Log Files and send a copy of them to us. There maybe an entry in the log files that will help us. To locate the Alert Repository Log Files, open the SQL Response Client -> Click on the SQL Response icon immediately above the file menu in the very top left hand corner -> In the menu that occurs, select Copy Alert Repository Log Files.

Send an e-mail with a copy of the log file attached and include the call reference number in the subject field of the e-mail. Also please include the name of the server experiencing this issue in your e-mail.

Hopefully the log files will contain entries as to why the Alert Repository cannot connect to the server.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
randyv



Joined: 28 Feb 2007
Posts: 113

PostPosted: Wed Mar 31, 2010 5:14 pm    Post subject: cannot do that right now Reply with quote

In order to do that, I would have to turn the service back on, otherwise the application closes when I click on the icon.

Turning the service back on, even momentarily virtually assures a system halt, and this has become so problematic for us that I cannot turn it back on.

However, the vendor has owned up to being the core problem, so you can close this.
_________________
What we do in life echoes in eternity <><
Randy Volters
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group