ASG-RD Crashes (executing SQL statement PropertiesGet)

[gregk]

Hi,

After update to the latest available version (12.0.6504.1) ASG-RD crashes randomly. Everything was OK with the old version we were using (2018).
We followed the "upgrade" process (and data source has been updated as well). Unfortunately, it crashes randomly. Some users reported that it is OK when they uninstall old version, for other users it doesn't help.
The main error we can see is: An error occurred on executing SQL statement PropertiesGet, and then: Connection could not be established.

As we found on the forum - we've run Data Optimizer, and we shrunk the database, but no luck.

Is there anything else we can do - other than uninstalling it and going back to the old version?

Thank you,
Gregory

[DevOma]

When do the users get the error message? On Startup? Connecting to a server? Anything else?

There seems to be a problem in the data structure - would like to look into the database - are you allowed to send me a backup of your database? We can reset all passwords if you want with an SQL statement...

[gregk]

To be honest - it is random.
I can send you the database - please let me know the script to reset/clear stored passwords.

Thank you,
Gregory

[DevOma]

Ok great - here is the SQL command to reset all credential data

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

You should backup your database, restore it for modification - there execute SQL and backup again - and please execute also "TRUNCATE Logs" to avoid unnecessary log information

Then you can send it to asg.rd@asg.com - please give at least the name of one user who get the error so I can check better which data is loaded… (and version of SQL Server you are running)

[DevOma]

Hi,

I can reproduce the error - and it is occuring in "Refresh Cache" - please try to set Refresh cache to 0 in Settings=>Application

We will try to find out what exactly is causing the issue

[gregk]

Thank you Oliver. We will try that.

Thank you,
Gregory

[DevOma]

Ok meanwhile we know what caused it and fixed it for the next version - thanks for supporting us with your data source...

[gregk]

Ok meanwhile we know what caused it and fixed it for the next version - thanks for supporting us with your data source...

Hi,

Unfortunately, the solution above didn't fix the problem for some users. Can I ask when you are planning to release a new version?

Thank you,
Gregory

[DevOma]

Planned for "mid of february"...

So for some users the solution helped and for others not? Same error? Could you give names of users for whom the problem still exists? Perhaps I can try to login with their UserID and see the problem myself again?!? You can send via PM (Private Message)

[interlan_aw]

Planned for "mid of february"...

So for some users the solution helped and for others not? Same error? Could you give names of users for whom the problem still exists? Perhaps I can try to login with their UserID and see the problem myself again?!? You can send via PM (Private Message)

We are noticing the same error occasionaly, mostly we do not crash though, just get an annoying dialog that we can click OK on and then resume. If possible, could you post a manual workaround for now? Any SQL query we can run to fix it atleast temporary for all users?

[DevOma]

Did you check if you have enabled "Automatic refresh" in Settings=>Application - please set to 0 (turn off) and check if the error occurs again (after restart app)