Very slow loading via VPN

[AlexBE]

Hello,

We migrated from Visionapp Remote Desktop 2012 (7.1.3830.0) to the brand new last version of ASGRD 2020 (13.0.6667.1) with databases hosted on the same SQL server.

By VPN, when we start 2012 version, it takes only 40 seconds in total until all objects are loaded. With 2020 version, it takes 4 minutes ! Both DB have exactly same number of objects.

I already modified "recovery mode" on "simple" on new database and made a shrink. Now the new DB files are 48 MB (2012 = 71 MB).
In client, I did "Administration", "Data Optimizer" and every thing is correct.

Thanks for helping.

[DevOma]

After upgrading from 2012 you should run the DataOptimizer - perhaps more than once :-) The data structure was changed by version 2015 and old data is imported one by one - but new versions allow more inheritance of each data category and it should be used to optimize the data structure - so until you find entries that could be optimized run the step again in DataOptimizer.

Afterwards it should be much better...

[DevOma]

Ups, so you already have run DataOptimier? Sorry for that...

Could you also check the log size? And perhaps delete the logs in new version?

[AlexBE]

First of all, loading time for my colleague is a little more efficient (1 minute 25 seconds). He run Win 7 on a different VPN location and I'm on Win 10. Maybe there is something with layout ???

I wasn't in the Administrator group of ASGRD, so I re-ran many times (+/- 25 I guess) Data Optimizer and it found properties to fix each time. Now, it takes 2 minutes for me (rather 4 minutes before). Thanks for this first solution

But still too long regarding 2012 version, I think.

I have to say that sometimes I have "Error PropertiesGet" happen when loading. Not each time.

Which logs file do you talk ? SQL log file or client ?

Thanks for you help

[DevOma]

Administration=>Logs=>...

Check if there are a large amount of logs - if not needed delete it or set in Settings=>Logs a maximum log entry size...

No difference between Win7 and Win10 - the data structure changed from 2012 to 2015 and the data to transfer is more than before - but has for internal use much more advantages - I think we had only 2 database updates in the last 4 years...

[AlexBE]

Hello Oliver,

Sorry for my late answer, I was off.

I checked logs, there are very small (because starting after migration which was done a few days ago).

The first issue about a very long time of loading for all of us was fixed by Data Optimizer (but it created some incoherences about "Connections" on many Items by the way).

About the second, I understood there were some changes in data exchange when application loading between 2012 & 2020 and that's why this last version is a little longer to load. But I don't understand why this time of loading is so different depending user. 1st colleague need to wait 35s (very fast !), a second one 50s and I need to wait 1m30 ?!

[AlexBE]

Hello,

I always have random error "PropertiesGet" when loading. I saw this post https://remotedesktop.rocketsoftware.com...pertiesget but setting for Caching is already on 0.

Thanks for helping,
Alexis

[DevOma]

Ok - the last question about differences in start up time - of course it could be the bandwidth that differs - and perhaps one user has some more "private data" than another one - but 1m30 is slow and perhaps it something to do with your second issue?

We try always to find data inconsistencies by Data Optimizer - but after migration the chance to have some data that is not ok is higher than in a new environment - and if you read in the linked thread we always offer a data analysis by development - you can delete all cred settings by the sql command given in the linked thread - so if you like send a backup, tell me the used MSSQL version and your username (so we can load the data for your user and try to reproduce the issue)

One more question - can you post the details of the error log entry for your "PropertiesGet" error? I want to see if it is a timeout or a already closed connection?

[AlexBE]

Because I don't have private data, I think it's more related with the second issue.

I will send you a backup of the DB with all needed infos.

Here is the stacktrace :
An error occured on executing an sql statement
PropertiesGet
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

---------------------------

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
  at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
  at System.Data.SqlClient.SqlDataReader.Read()
  at CloudAdminDataAccess.SqlDataAccessor._PropertiesGet(Guid userId, Guid itemId, Guid rolePropertyId)

[DevOma]

I'm still waiting for your backup :-) If you want that I analyze the startup of your environment please send it to me (asg.rd@asg.com)...

[AlexBE]

I'm still waiting for your backup :-) If you want that I analyze the startup of your environment please send it to me (asg.rd@asg.com)...

I sent the email this 14/4 at 16h (with backup in attachment 12MB). I just sent it again.
Please keep me informed if you don't receive it

[DevOma]

Got it now

[DevOma]

And I can reproduce - so it is an data issue and we will start analyzing what's going on...

[DevOma]

But now some strange things happened - first license check failed?!? And now it is telling me that the data source needs to be upgraded?!? Are you really working with latest version? And send me the correct data backup?

I will Restore the initial database again - and also have a look at these strange things...

[DevOma]

Seems to be that there is more data deleted/reset than only passwords - so I can't use this environment

Could you please check that you only perform the following sql statement for removing passwords from database

UPDATE ItemProperties SET Data = '' WHERE RolePropertyId = '5B5AA970-E8EA-4162-BECE-6A366E150C92'

If you change the WHERE Clause (or remove it) ALL necessary information will also be reset and nothing works anymore - in database I can see the it was removed and then executed - so all data is empty!


Please try again! Thanks

[AlexBE]

Oh, very strange, I'm pretty sure that I've executed the right SQL command.

I checked the DB, is it normal that there is only 11 tables (old version have 33 tables) ?

By the way, I just sent you a new backup file. If it doesn't work, I can't drop the file on our public cloud (maybe Outlook corrupt file...)

[DevOma]

Ok - now the backup was ok :-)

And yes the structure of the database was simplified...

First run in my dev environment - takes 2 seconds for starting the app - but I will have a deeper look (hopefully on Monday)

[AlexBE]

Sorry for the first corrupted DB (didn't know what's happen, maybe something I did wrong...).

Ok, cool, let's see next week. Have a nice week-end

[DevOma]

Are you working always via VPN? Or sometimes directly in the network? Because I tried a lot of times and the environment is loaded really quickly - but I know if your bandwidth is very low it might take too long for a single SQL statement - then you should set a higher timeout value for your database environment (Advanced settings)...

[AlexBE]

Because the situation, I always tried by VPN excepted a few days ago when I was on premise and I confirm that I need only a few seconds to load.

I don't know why but I suspect now that VPN seems to be very slow sometimes and caused this "PropertiesGet" issue. Your suggestion about increase timeout in Database environment is a good way. How many seconds do you think ?