Getting An error Occurred Orchestrator Logs

I am getting an error everytime i try to access the logs section in Orchestrator (see attached screenshot)
I have tried the following but the issue remains. Please assist.


stop the UiPath Robot service
Delete the folder “C:\Windows\SysWOW64\config\systemprofile\AppData\Local\UiPath\Logs\execution_log_data folder” and restart the service

1 Like

Kindly have a view on this thread

Cheers @hatakora

1 Like

hi @hatakora ,
is your Orchestrator in enterprise mode ?

Yes it is @Maneesha_de_silva. It is installed on premise.

1 Like

@Palaniyappan i looked thought that and it doesn’t solve my issue. First my orchestrator is an enterprise version installed on premise. Also the thread you provided is referring to a different issue. I am not having issues publishing. I am having the issue when i go to logs

1 Like

ok , so then you logs coming from your database
[your Orchestrator DB NAME ].[DBO].[Logs]
check whether if you have any possibility to access DB or ask your DB admin
if you having any record on this table on reason dates

if your table empty means someone purge entire table , ask not to do
at least you should keep 45 days of data remains

also check your Orchestrator and robot information level
that put in to off

log 2

Fine
The thread is different but the resolution is same
In that thread

Solution Provided by UiPath:
1.First we need to check the below

  • How is the behavior when you perform iisreset in command prompt(Admin mode) in Orchestrator server.
  • Reboot the Orchestrator server and share the outcome.
  • Share 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] ;
  • Share the event viewer logs from the Orchestratorserver
  1. Please use this KB to eliminate the debug logs and then shrunk the database files . The query is also inside the below link :

orchestrator.uipath.com

Maintenance Considerations

It is important to keep your Orchestratordatabase free from clutter. To do this, we recommend: * Using SQL Server Maintenance Solution * [Creating a separate database…

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.

Take the backup of the logs & UserNotification details 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 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

I would suggest to clean up all the logs prior to 45 days / 30 Days, in if the remaining records are lower than 1 million.

Cheers @hatakora

1 Like

I am an admin. I checked this and it is empty. @Maneesha_de_silva. No one has cleared the logs that much i can assure you. The are only two admins with access to the database.
I also checked and made sure . My robot is set to log as Information

ok so the table is empty means , sure its delete by some one
so if you sure about you both
there might be the DB management plans

check your DB running any maintenance plans , related to this
and also any jobs to delete data form logs

I followed those , When i reset iis via iisreset in admin mode. The issue remains
I have rebooted the machine multiple times, the issue remians
When i run these, you can see the results (see attached)

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] ;
@Palaniyappan


The maintenance option doesn’t even work here because i have no logs in the DB. But i can see logs in Elasticsearch/Kibana.
When i run this
Query to Fetch all records older than 45 days
SELECT * from [dbo].[Logs] where
DateDiff(day, TimeStamp, GetDate()) > 45
I get nothing. empty results

@Maneesha_de_silva there aren’t any. I installed and configured this server myself. I don;'t have any maintenance plans or jobs to delete data set on this. 100 % certain.

Also i can see all the logs in Elasticsearch/KLIBANA

1 Like

ohh ok , means its getting Elasticsearch/KLIBANA
when did its occurs , any suspicious situation ?

i think you better race a ticket then, make sure tell them that all what did check here because , they can get rid of these issue otherwise you first respond will be same thing what we talk here

and make sure to update solution on here also , so its may be helpful to others

@Maneesha_de_silva i mean before i hadn’t gotten logs in KIBANA, i wasn;t getting the error but i wasn’t seeing logs either. Since i started getting logs in Elasticsearch, i am getting the error in Orchestrator

1 Like

Kindly check once with the technical team on this pls

Cheers @hatakora

@hatakora
i think you better raise a ticket for technical support

Sounds good i will do that