Hi,
We have a problem with RDM with an SQL Azure database. We were able to work with it without any problems for a few weeks, but since last Friday upon start up and RDM connecting to the datasource, it crashes.
Faulting application name: RemoteDesktopManager.exe, version: 9.2.10.0, time stamp: 0x537e00a8
Faulting module name: KERNELBASE.dll, version: 6.3.9600.17055, time stamp: 0x532943a3
Exception code: 0xe053534f
Fault offset: 0x00011d4d
Faulting process id: 0x%9
Faulting application start time: 0x%10
Faulting application path: %11
Faulting module path: %12
Report Id: %13
Faulting package full name: %14
Faulting package-relative application ID: %15
The odd thing is that we also have another SQL Azure datasource which does not have the problem, so it must be related specifically to just this one. Trying to recreate the datasource does not help, nor does a fresh install on an entirely different computer.
Does anyone have any thoughts on how to trace the issue? Thank you in advance.
Best regards,
Jelle Hillen
Best regards,
Jelle Hillen
This is a Window crash with no error handled by RDM. Could you verify if you open RDM on the local data source and switch to your azure data source if it does the same thing?
David Hervieux
I have two SQL azure datasources, but only one of them causes the error. The database that works is the default when RDM is started. When I switch to the other one, RDM crashes.
On another computer, I've tested by only adding the datasource that does not work and it immediately crashes on startup. It seems to me that it's something related to this particular database, but I can't really pinpoint the problem. I see no difference in configuration between the two SQL Azure databases, other than the fact that they are different SQL instances on different Azure accounts.
I've also tried using the DB owner to log in (normally I use an SQL user with limited permissions), but this results in the same crash.
Best regards,
Jelle Hillen
Could you access the database from the same machine with SQL Management Studio?
David Hervieux
Yes, that works without any trouble. I can access the database, tables and all.
Best regards,
Jelle Hillen
Could you take a look at the application log in Help->View Application Log.
Have you tried a reboot?
David Hervieux
Unfortunately, the Application log does not log the problem. It seems RDM crashes before it can write anything in it. The only thing I find is in the Application Eventlog (see first post).
Yes. And tried it on other machines as well (Windows 8.1 and Windows 7, both x64).
Best regards,
Jelle Hillen
This is really strange. Could you try to import your connection in another Azure data source?
David Hervieux
I have created a new database on the other SQL Azure instance and have imported the data (using Management Studio and the export/import BACPAC function). The database is succesfully restored, and I can add it as another data store. Unfortunately, when trying to connect, RDM crashes again.
This makes me wonder whether there is something in the database itself that is causing the crash? Meanwhile, I also tried disabling all offline caching but to no effect.
Best regards,
Jelle Hillen
Could you try the latest beta release?
David Hervieux
Installed beta 9.4.6.0. It asks to upgrade the database which it does succesfully, but when loading the sessions, it crashes again.
Faulting application name: RemoteDesktopManager.exe, version: 9.4.6.0, time stamp: 0x5395b21a
Faulting module name: KERNEL32.dll, version: 6.3.9600.17056, time stamp: 0x532a2e6c
Exception code: 0xc00000fd
Fault offset: 0x00010482
Faulting process id: 0xde4
Faulting application start time: 0x01cf84bce233ae2b
Faulting application path: C:\Program Files (x86)\Devolutions\Remote Desktop Manager\RemoteDesktopManager.exe
Faulting module path: C:\Windows\SYSTEM32\KERNEL32.dll
Report Id: 28636f2c-f0b0-11e3-8271-d89d679753dc
Faulting package full name:
Faulting package-relative application ID:
Restarting RDM, it does not ask for the database upgrade (so that went well) but still crashing like before.
I could try importing the database (BACPAC) into a local SQL Server instance to see if that changes anything?
Best regards,
Jelle Hillen
Do you know if you could give me access to this data source just for a test?
David Hervieux
Sure, I'll create a user for you. What's the best way to provide you with the datasource (PM, e-mail, ...)?
Best regards,
Jelle Hillen
Private message is the best
David Hervieux
I've sent you the RDD through PM. Thanks for looking into this.
Best regards,
Jelle Hillen
Hi,
I'm working on it right now. It's not related to Azure. It's an infinite loop in the variable resolving.
David Hervieux
Could you try the latest beta and give it a try? You have one entry that the host and name are exactly the same and this cause the infinite loop. I don't remember the name of the entry but I think it contains SP01
David Hervieux
Hi,
Latest beta resolves the issue. Thank you for all the help.
Best regards,
Jelle Hillen