SQL errors when connecting to the database

[frans.snijders@cegeka.com]

Hello ASG team,

When connecting to the vRD2020 _O database, we get the following SQL errors for five users:

An error occured on excecuting an sql stastement LogsAdd
An error occured on excecuting an sql stastement BaseItemGet

See attachment for more information.

Hope you can help us with solving this errors?

Thank you in advance!

[DevOma]

You should try to shrink your logs - if that doesn't help, try to run the DataOptimizer to see if there are invalid data in your data source

[frans.snijders@cegeka.com]

You should try to shrink your logs - if that doesn't help, try to run the DataOptimizer to see if there are invalid data in your data source

Shrink the log files and run the DataOptimizer but without success.
Also try the settings "Set connection timeout" 30 seconds but that has also no effect.
Added the BaseItemGet error.

[DevOma]

Which version so you use? We always try to optimize / fix issues - so perhaps you should first try to use the latest version - if the error still occur we need to analyze the database in detail

[frans.snijders@cegeka.com]

Hello Oliver

The version that we use is:

ASG-Remotedesktop 2020
Version: 13.0.6985.1

We still have SQL errors.
BaseItemGet in the error log of the application.

[DevOma]

If you have a valid subscription - please try to upgrade to newer version - there were a lot of fixes meanwhile - I know the issue and most of these issues are gone through fixes in software or new extensions in DataOptimizer