An Error Occurred - When updating Asset or User Orchestrator throw error - Troubleshoot

Help
1

Issue :
image

Solution:

verify the count of records of the below from Sql Server:
select count(*) from [dbo].[Notifications] ;
select count(*) from [dbo].[TenantNotifications] ;
select count (*) from [dbo].[UserNotifications] ;
select count (*) from [dbo].[Logs] ;
select count(*) from [dbo].[AuditLogs];

Solution: Follow the solution if record count is more than 2 million for any of the table
SQL performance issue is maxed out due to logging.
None of the above-mentioned tables should have more than 2 million records

Please use this KB to eliminate the debug logs and then shrunk the database files .
The query is also inside the below link :

Each & every step is detailed in the above link. It’s recommended to have max 1 million records to be on the safer side and maximum to 2 million.

MU7lUhH8wm0XsPBKUq1zF0Z39.png

Take the backup of all the previously mentioned table & clear the information.

It’s also advised to perform a database maintenance biweekly or Monthly, which purely depends on the information getting logged to the database.

Query to Fetch all records older than 15 days
SELECT * from [dbo].[Logs] where
DateDiff(day, TimeStamp, GetDate()) > 15

Query to Delete all records older than 15 days
DELETE FROM [UiPath].[dbo].[Logs] where
DateDiff(day, TimeStamp, GetDate()) > 15

Also, for more information on logs please refer the below link:

Image_2019-02-28_08-26-18.png

Disclaimer: This may solve the issue.

1 Like