Orchestrator Page Displays "An error has occurred."

News Knowledge Base
1

What steps to perform when Orchestrator page will inexplicably display "An error has occurred." ?

Initial Quick Fix steps:

  1. Perform iisreset in command prompt(Admin mode) on the Orchestrator server.
  2. Reboot the Orchestrator server and share the outcome.
  3. Share the count of records of the below from SQL Server:

select count(1) from [dbo].[Notifications] ;
select count(1) from [dbo].[TenantNotifications] ;
select count(1) from [dbo].[UserNotifications] ;
select count(1) from [dbo].[Logs] ;
select count(1) from [dbo].[AuditLogs] ;

  1. Share the event viewer logs from the Orchestrator server


If issue is still persists, then try eliminating the debug logs and shrinking the database files . See the query for this in the Using SQL Server Maintenance Solution .

As detailed in the above link, it is recommended to have max 1 million records to be on the safer side and maximum to 2 million.

​

  1. Take the backup of the logs and UserNotification details table & clear the information.
  2. It is also advised to perform a database maintenance biweekly or Monthly, which purely depends on the information getting logged to the database.
  3. Query to Fetch all records older than 45 days

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

  • It is suggested to clean up all the logs prior to 45 days / 30 Days, in if the remaining records are lower than 1 million.


Check the Application Event Viewer Log for this exception:
System.ArgumentException: An item with the same key has already been added. Key: [A Number]
Verify a duplicate TenantId row in UiPath.dbo.Licenses.