SQL Timeout / OutOfMemory after editing session
Hello,
Whenever I attempt to edit sessions I get alot of random "Out of Memory" errors, after that all the sessions go away and it says it's not connected. I click refresh at the top... it spins around for awhile and all the sessions come back and I'm good to go. Funny part is, most of the time it saved what I had just edited... even though it crashed with the OutOfMemory error.
After some of these crashes I've noticed that there's duplicate ghost sessions for every single session. Close out of RDM and re-open and all the ghosts go away.
The other message I get (also when editing sessions) is a SQL timeout message. I tried to increase the timeouts in the Data source settings but that didn't appear to make any difference... it just locked up for longer. When it locks up anyone else who tries to connect to the data source gets locked out. This error seems to happen consistently on all sessions now. It also happens on multiple workstations.
I'm on RDM 8.0.8.0 right now, but have seen the problems with 8.0.6.0
Thanks!!
edited by kdrude on 12/10/2012
Oh, I wanted to add... We're running on SQL 2008 R2 (latest updates) and restarting SQL server fixed the SQL Timeout message.... I wouldnt be surprised if it happened again though.
edited by kdrude on 12/10/2012
All Comments (6)
Let me know if it come back. I will verify that all our connection are closed after each commands.
David Hervieux
Yeah, unfortunately still get a ton of out of memory errors. Also got an XML crash error... It gives a code number like 9, 16 but those numbers may be wrong.... I'll let you know exactly what it says next time. I haven't seen SQL timeout since restarting the sql service though.
Here's what the log under the local user's profile has....
System.InvalidOperationException: There was an error generating the XML document. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
(the xml error above)
(the outofmemory error below & attached file)
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
After getting the outofmemory error, you can just hit ok, refresh at the top and it appears to remedy itself... for awhile, then the problem comes back.
We have 570 entries, could that be part of the problem?
outofmemoryerror.jpg
Do you save a lot of information in the note or use a custom images? If you export you session in an xml, what size it is?
David Hervieux
In most text sessions? No, there's not a whole lot of information... but in the one that i saw a couple of times in crashes it has 4 pictures attached in the text session.
I'm not entirely sure how to export to an XML... Is that the same as the RDM format? It looked like it when i opened it up in a text editor.... IF so, the size of just that one text session is between 18.6 MB.
Just to make sure you know... I'm not editing this session when I get out of memory / crashes... it usually happens right after editing any other session. (text, rdp, etc. )
Oh, Just to let you know...
I took the text session with the 4 pictures in it and popped them into a word doc instead. That seems to be a good work around
In the next major update, we plan to improve this part of the application.
David Hervieux