1 out of 4 bot is not consistent

Help Robot
,
1

Hi, we have 4 PROD bots running off Orchestrator.

Process:
. bot scheduled every 10 minutes
. automation opens and runs Excel macro
. macro gets data from the database
. macro updates specific cells with data
. macro captures any error from data and adds to the log (e.g. unable to place because the time slot couldn’t be found in the workbook)
. the log then gets emailed to the business

Issue:
. the log has the same error message on 3 bots except for one
. the one bot has an extra error which isn’t an error because the data is already placed

What I’ve done
. I have cleared the cache and packages in the problem bot server
. I have run the UiPath Assistant via the bot server, the issue exists
. I have manually run the macro in the bot server, the issue exists
. I have run macro via local, issue does not exists

Have you come across this before where one bot is inconsistent with the rest of the bots?
Is the issue with the database, Excel, UiPath or server? TIA

2

What is the actual error?

3

The Error log is not consistent on one bot while the other 3 are.

The Error log is generated by the macro, not UiPath.

4

For anyone who has the same issue. The issue was with Excel. This solved it for me

  • Cleared Excel Cache on all bot servers
  • File > Options > Save > Cache Settings
  • Days to keep files in the Office Document Cache = 1
  • Ticked Delete files from the Office Document Cache when they are closed
  • Delete cached files (button)
  • Closed Excel
  • Renamed folder OfficeFileCache in C:\Users<ROBOT>\AppData\Local\Microsoft\Office\16.0 (could be deleted)
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.