MIS Systems Thread, SQL memory issues and Reason 0 in Technical; Dear All,
We're having a bit of a nightmare with sims.net and the March update. Although I'm not convinced the ...
31st March 2009, 12:19 PM #1
- Rep Power
SQL memory issues and Reason 0
We're having a bit of a nightmare with sims.net and the March update. Although I'm not convinced the march update has anything to do with it as our problems starting happening about 3 weeks ago.
Basically we're getting the Reason 0 when people try to login. At first it was random people, which turned into the whole school. After speaking to capita, they suggested that we do admin work directly on the server as this with use SQL named pipes and should there be a problem, it will not lock the whole database in maintenance mode.
We tried this and it seemed to work for a little bit.
Roll forward to today. I performed the March 2009 update last night and all worked ok. I logged into a number of machines and the update run fine. We already had some users who still were getting the Reason 0 problem before the update. They still had the problem after the update, along with some new staff. Capita suggested resetting their passwords in system manager. This actually worked. However, those same people are now getting the same problem. Only this time when we try and reset their password, it doesn't seem to make any difference. Still Reason 0.
Our sims.net server is running under Virtual Server 2005r2 but here is the spec.
Hosting Server: Dell PowerEdge 2950, 2 x Quad Xeon E5320, 16GB Ram, 1TB SAN
Virtual Server (for sims.net): Windows 2003r2, 3.7GB Ram
One thing I have notice is that SQL doesn't use any more then 1.7GB. Yet I've assigned 3.7GB to the server. Is there a way I can allocate another 1GB of ram to SQL with it making the machine too slow. Surely that's got to help?
Still waiting for capita to get back about the reason 0 issues. I know the detaching the database and reattaching will fix it but it's not ideal. Finance are doing their year end at the moment so they won't be too happy.
any help greatly received.
IDG Tech News
31st March 2009, 01:18 PM #2
What version of SQL are you using Express or full?
31st March 2009, 01:32 PM #3
- Rep Power
We're running the SQL 2005 Full version
31st March 2009, 01:38 PM #4
Reason 0 normally points to an error with the connect.ini
Have you changed any shares or links on the network that point to a connect.ini
31st March 2009, 01:53 PM #5
- Rep Power
No we haven't changed anything. We have a user who cannot log into sims on their PC but if they use someone elses sims.net login, it works ok. Leaves me to believe it's a database issue rather then a PC issue.
The person who then tries another PC still cannot login. So people who cannot login, the problems followes them around the site.
31st March 2009, 02:24 PM #6
Capita advise for this would be to dettach the database and re attach.
Have you checked the event logs on the machines at the time that users try to login and also take a look at the server at the same time.
31st March 2009, 02:51 PM #7
We have experienced this same problem only three weeks ago.
We have yet to have the March upgrade rolled out to us so that was not a factor for us.
The KB article on the Capita site lists 7 possible fixes, none of which were applicable to us.
Capita finally said to detach - re-attach the database, by which time our problem had mysteriously disappeared on its own.
We still do not know the cause of the problem, which randomly affected both existing and new users, teaching and non-teaching. Resetting their passwords worked in some cases, not in others.
31st March 2009, 03:02 PM #8
- Rep Power
I figured that was going to be their standard answer. How easy is it to detached and reattach the database. Capita have remote controlled our server before and said they would prefer to do it. I've had a look at the DBAttach. Is there anything I should do before hand. I think Capita moved the database into another folder and allowed it to be copied back? Does that sound right. I would imagine that's why it took so long. Surely just detaching and re attaching would be ok?
In terms of my server event log, I'm getting plenty of these
Login failed for user 'SIMSRedirectService'. [CLIENT: 10.82.23.2]
Login failed for user 'sims_sheilab'. [CLIENT: 10.82.23.2]
31st March 2009, 03:18 PM #9
We've had a few reason 0's recently. Usually fixed by recreating connect.ini as someone else mentioned, but this wasn't making a difference this time.
The only thing we found that seemed to be a common issue, was that SIMS stopped working as soon as the schools internet went down. As soon as the internet came back up, so did SIMS.
I know what you're thinking, there is absolutely no link and you're right. We first thought that perhaps the DNS settings were wrong, but they all checked out. We could fully ping the SIMS servers from the workstations and vice-versa.
Happens to be a very strange and frequent co-incidence of late though.
31st March 2009, 04:34 PM #10
Just a stab in the dark really. How is dns accessed? We once had a similar problem (not SIMS though) when dns was actually being served by the internet router and we had to install dns internally, because if the router died so did all our thin clients. Of course if you are using an external dns server and internet goes down then.....
Originally Posted by Ayatollah Pies
Thanks to garrysaddington from:
AyatollahPies (31st March 2009)
31st March 2009, 04:47 PM #11
We had the same issue with Reason 0 here, seems to point to a general connection error. Connect.ini all fine, seemed to go away on its own here as well. It seemed to appear for us during periods of high network traffic and when the server was under extreme load. It was especially common when we had the antivirus scan scheduled over lunch with people logging onto it around that time it tended to have a hissy fit!
31st March 2009, 05:57 PM #12
Admin server which hosts SIMS is also the DNS server. We wondered if the clients might have somehow been going out of the LAN and then back in, but this wasn't the case.
Originally Posted by garrysaddington
It's a strange one that's for sure.
2nd April 2009, 12:37 PM #13
- Rep Power
I fix reason 0's in the following order,
-Check services (you'd be surprised)
-Connect.ini's - check local redirects - check the server's one is correct.
-Add time out (don't ask me why but it sometimes works
-Change server name to IP
-Don't redirect the local connect.ini replace it with the server's one
-Reinstall - always reluctant to do this but sometimes your left with no choice
If it become a consistent problem more related to usernames you could map the Sims usernames via AD?
All of the above work it just depends what the scenario is.
Thanks to Steve_T from:
Oops_my_bad (29th November 2009)
7th April 2009, 12:15 AM #14
- Rep Power
Think we might have found the cause of the problem but don't really know how to fix it.
It seems that the when you use Sims System Manager to create users or reset passwords etc that is when the reason 0 problem starts.
We were told not to use system manager on a workstation as if there is a timeout, it leaves the SQL database in maintenance mode and you have to detach and re attach it. Capita suggestion was to do it on the server as this uses named pipes and not TCPIP for connection.
We did this and initially we thought it seemed to fix the problem. However, it started going wrong again. We're about 95% sure that it's system manager that is causing problems with peoples accounts and not necesssary the account your editing.
Can anyone confirm if they are having the same problem. You might find that when you have the problem, it's always after system manager has been used.
I've told our person who uses it to do all the changes at the end of the day. Only people who use sims.net so infrequently are likely to forget their passwords. Why upset our power users because we have to reset someone's password during the day. They can wait until the end of the day and if it goes wrong, it doesn't upset too many people.
7th April 2009, 09:25 AM #15
We have had the same problem and it is fixed by detaching and then re attaching the database.
By zag in forum MIS Systems
Last Post: 16th January 2011, 04:15 PM
By Gibbo in forum Bad Experiences
Last Post: 26th February 2009, 08:12 PM
By amvc in forum MIS Systems
Last Post: 9th June 2008, 10:50 AM
By tom_newton in forum Windows
Last Post: 23rd January 2008, 06:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)