8.9.1.0 - Findings
Ver 8.9.1.0 Notes.
Upon startup sometimes RDM does not see the SQL DB and I would need to restart.
RDM does not count correctly the sessions as I started with a listed 284 and add one session it goes up to 308.
Entry List Report - Saved as Webpage complete produced and empty file.
- Saved as Web Archive, single file (default save as option btw) produced nothing as no file was saved although it went through save process.
- Saved as Webpage HTML only worked! (links dont point back to installed RDM but to http://internal.rdm.com/?connection=session id
- Printing to PDF should carry over name of report (Entry List Report) instead of about_blank
Generate reports should be split into two with top of window running reports on public or default sessions (public) listing. Bottom set of reports should point to sessions in private vault or provide option for user to select private before report is generated as to not to split screen into two showing same reports for public and private sessions.
Created test session in private vault and deleted it. The deleted session does not show in deleted entries option but shows in the Shared connection log as an Entry edited. Entries created in private log should show up in show up with a designation of "pv" under possibly a new column called session. Not sure if you would want to call the original session list public vault or production vault as you now have private vault
Shared connection log should have option to show private vault entries and not pool them in with public. Basically all options within RDM point to public vault and should include private as option which would allow the admin to show "all" or one step further would be to allow admin to deslect public and select private... options, options.
Option to move a sessions, folders, site etc from public to private as only option would be to export to .rdm and import into private.
Filter does not seem to work with private as it does with public session list. Only way to get it to apply the filter is to go to public and then back to private. What I had done was to take an entire site folder and all connections, export to .rdm, and then import to private. while in private use filter and call up a connection that I knew was valid and nothing happened to change the session list in private. Click on the public session list save the filter had worked as expected and then clicked private which then showed the filter working.
Will keep looking and documenting.
Update - Closing the application and re-opening has updated the entries from 308 to 285 from 284.
edited by fvigo1128 on 7/7/2013
All Comments (6)
Hi Felix,
I will verify and fix all your comment tomorrow but you have to know that the private vault is stored in the database but this should not be be visible in any logs.
This feature is really a complex one because of all the link in the core of the application. So for this version, the easiest solution is to use the copy / paste feature
David Hervieux
1. With "Upon startup sometimes RDM does not see the SQL DB and I would need to restart."
I need to know the error message you get because I can't reproduce it
For the http://internal.rdm.com/?connection=session id, it's the normal behavior because those link work inside rdm. RDM has a special handler to redirect the entry.
I will verify to include or not the private vault entry in the report, it's a good idea
For printing pdf, it's a know limitation of the web browser. We generate the content in memory I can't find a way to specify a name.
As reported, if you delete an entry from your private vault, you will no longer be able re recover it. The private vault is a Xml file stored in your account on the database and it does not support the recycle bin. This is not planned for this version.
For the count, I suspect that maybe the intelligent cache is causing the miscount, I will verify this.
David Hervieux
David,
It's been three days and no startup errors with RDM not being able to see the SQL DB. Maybe RDM was starting up too fast and SQL had not completed starting its services.
Totally understand about moving session to private and or back to regular session as I only see that to be a one time move since prior to the private vault my connections were business and personal. Now with the PV then I should be able to move my personal connections to the vault and leave them there.
No worries about the printing to PDF as it's not a big deal to do the rename as I already do that with various print to pdf tasks.
Two things that I have recently noticed with the Private vault... I took my personal connections and moved them to the vault. I kept the original connections in place for a few days and then I deleted the original site folder with all connections. Once completed I went over to the vault and all of my connections which had a custom icon were show up up with an exclamation mark inside of a red circle. Only the connections with the default rdp icon were ok. the connections still worked but it lost the association to the custom icon. Once I restored the site, folders, and connections back to the sessions folder, closed RDM, and re-opened the custom icons came back.
second item was that I noticed that adding an expire date placed an extra icon (clock) in lower right of RDM. The Expired Entry List Report should show all sessions that have the expired date enabled and not just the sessions which have actually expired. Changing the report in this manner I believe will be helpful to print out and have. The report should look at production sessions and also have option for private as setting an expired date would be something an admin would setup for private and business sessions.
Now in setting up a test expired session for tomorrow in one of my private sessions it did something strange by taking the site folder and duplicating that but using the original site name and the creating a sub folder and then finally listing the session which now has the expired date.
So my original MSP folder was imported to private, renamed to MSP-2, then inside of the accounts folder I added an expire date to my FedEx session and saved it. Now I have a new MSP folder, a second accounts folder and then the FedEx session with expire date. So in adding the date it created a new main folder which is a site folder, then a sub folder and it basically moved it from MSP-2\ACCOUNTS to MSP\ACCOUNTS.
Felix
In reviewing the icons in the Help menu I ran across the View Application Log and below are the two instances where I had a problem connecting to my SQL Express DB on my PC:
[7/5/2013 4:07:16 AM]ERROR System.Data.SqlClient.SqlException: Cannot open database "RDM-2013" requested by the login. The login failed.
Login failed for user 'sa'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.GetDataSourceSettings()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadDataSourceSettingsFromDataSource(BaseConnectionDataSource newDataSource)
****************************** SqlError ******************************
Message:Cannot open database "RDM-2013" requested by the login. The login failed.
****************************** SqlError ******************************
Message:Login failed for user 'sa'.
[7/7/2013 12:56:58 PM]ERROR System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.GetDataSourceSettings()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadDataSourceSettingsFromDataSource(BaseConnectionDataSource newDataSource)
****************************** SqlError ******************************
Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
edited by fvigo1128 on 7/12/2013
Hi,
Thank you for the bug report about the image, it's definitively a bug.
For the expiration, what about creating an expiring status with a custom expiration period:
In 30 days, in 60 days...
For the expiration report and the private vault, it's a little more tricky because I only load them when your first access the tab. This is for performance reason.
David Hervieux
Hi David,
An expiring status report will work, can you let me know what triggers the notification clock in the taskbar? Is it an entry that is set to expire in 7, 14, 30 days?
Felix
Hi,
For now the expiring status is hard coded to in less than 30 days
David Hervieux