An error has occurred while opening Logs under Jobs in UiPath Orchestrator

News Knowledge Base
1

An error has occurred while opening Logs under Jobs in UiPath Orchestrator.

Probable Cause : This error usually occurs because of huge data in database. We strongly recommend not to have more 1 million records. You can run below query to find out the number of logs in database :
      Select count(id) from dbo.logs

Solution :
1. We recommended to perform database maintenance on regular basis. You can refer to our guide https://orchestrator.uipath.com/docs/maintenance-considerations for the maintenance steps. 

2. MS-SQL database being a Relational database gets slowed down with huge data and to overcome that we would recommend :
   A. You can use Elastic-search to store all the logs.
   B. Can use Orchestrator Database to store only errors and fatals. 
You can make these settings in web.config file of Orchestrator. For more insight, you can refer to Logging Configuration. 

You can also refer to below link for steps to install Kibana and Elastic search:

https://orchestrator.uipath.com/docs/prerequisites-for-installation