ASG database error

[achakraborty]

We are receiving attached error randomly "An Error occurred on executing an sql statement" attached error screenshot for reference.
Is there any reason for these errors?
           

The databases also have some error,
exec PropertiesGet @ItemId='00000000-0000-0000-0000-000000000000',@UserId='B01AB8CE-AF47-4B5C-88FF-561D096CCE79',@RolePropertyId='00000000-0000-0000-0000-000000000000'  
exec PropertiesGet @ItemId='00000000-0000-0000-0000-000000000000',@UserId='4374F1C8-EE48-4356-95A3-837A0EA72A72',@RolePropertyId='00000000-0000-0000-0000-000000000000
   
Can you please assist what these error are about and how can these be resolved?

[achakraborty]

Can anyone please look into these, this is affecting multiple Users and having impacted to our delivery because ASG is the ONLY tool to use any connection to servers, devices.

[DevOma]

Which version do you use? Have you tried "Tools=>Reset Layout"?

Also can you run Administration=>Data Optimizer to analyze and fix database issues?

[achakraborty]

Which version do you use? Have you tried "Tools=>Reset Layout"?

Also can you run Administration=>Data Optimizer to analyze and fix database issues?

We are running with version 2025 - Patch 7. However, the issue seems not to be related to layout or something. Random Users got the errors, and by reading the log it seems like transaction log grown to a point where it is causing query performance issues" and which is indication purging log table is needed, is that something you can suggest, e.g. procedure or is it recommended?

[DevOma]

If you don't need any history - then it can help to purge the log table - perhaps it's too much data and runs into timeout - in that case "truncate table Logs" could help