Stuck on Loading data after updating 2019

[gunnarh]

I did update ASG remote to 2019 and some users cannot use the program because it is stuck on Loading Data when they start it.
The other user say it take more time to Load the data when the start it but after that it works.  If i try 2018 version it is much faster to load the data.

We have 15 users and run the database on SQL

[DevOma]

We found a bug some minutes after releasing Patch1 - we only edited the download link in the Thread to a fixed version with the same version number - you can see it only in the name

ASGRD2019__Patch1_Setup.zip (this version contains the fix you might need)

ASGRD2019_Patch1_Setup.zip (original Patch1 version)

Please try to download again

https://remotedesktop.rocketsoftware.com...?tid=10987

And how much more time do your other user report takes the loading of the data? We have some new logic, perhaps it takes a bit more time on startup, but then it should be faster and consume less memory - but of course we are interested on what users notice

[gunnarh]

I have download the new file and install it but same result.

I did reinstall the new version i did download and same problem
I did uninstall the 2019 version and install it again and same problem.

[DevOma]

Sorry, I think it was a second issue with another solution - I don't know if that helps for you - another customer sends me a database and as I checked it I found a "self-referencing-object" in it - so ID and ParentID was the same and so a call ended in a loop...

You can check that with the following SQL command

SELECT * FROM Items WHERE ItemId = ParentItemId

If you find Items you should delete them with

DELETE FROM Items WHERE ItemId = ParentItemId

The next Patch will also check hat in code - if it will not solve your problem let's go ahead with some questions - I guess that only users that are not in Administrators group are getting this error? Correct?

[gunnarh]

use ASG_2015

SELECT * FROM Items WHERE ItemId = ParentItemId

(0 row(s) affected)

So no change



The only people can use it is Administrators.

[DevOma]

Ok thanks - are you allowed to give me a backup (via SQL Management Studio) of your database for debugging the issue? You could send it to asg.rd@asg.com or put it on any storage location and send me the download link via private message - so I could debug it to find the issue - we have two other issues found and will publish another Patch asap - and I would like also to fix your issue with that version.

[gunnarh]

I did send the database file with one driver.

[DevOma]

Send you a private message

[DevOma]

Thanks for sending again - I removed all "visible entries" in your database and there are 2500 objects still in the database that causes the issue - we will try to implement some new checks in DataOptimizer to find these "lost items" - this will also increase the Performance... I will keep you informed

[gunnarh]

Thanks for sending again - I removed all "visible entries" in your database and there are 2500 objects still in the database that causes the issue - we will try to implement some new checks in DataOptimizer to find these "lost items" - this will also increase the Performance... I will keep you informed

Do you now when you have Fix?

[gunnarh]

Thanks for sending again - I removed all "visible entries" in your database and there are 2500 objects still in the database that causes the issue - we will try to implement some new checks in DataOptimizer to find these "lost items" - this will also increase the Performance... I will keep you informed

Do you now when you have Fix?

[DevOma]

It's already released - version 2019 Patch2

Just run the DataOptimizer - and please run the steps again and again while there are entries found - after that your bad data will be completely removed and everything should work again