Skip to main content
Solved

File : Assign randomly does not find the file

  • March 26, 2025
  • 5 replies
  • 61 views

Forum|alt.badge.img+11

Hi everyone,

 

I am trying to use the Excel Basic package to load configuration data stored in the control room.

To have it clean, I open a File variable, and just before I assign to the File variable Bots/<my project name>/Params_v$@version$.xlsx ; where $@version$ is a global variable, so that I can have the same behaviour across several bots, and have a sort of version management.

Several bots have the same mechanism, I run them in a loop and it works correctly several times, until at some point it raises the error 

Get Resource failed. Error: Could not find the file 'Params_v0.2.xlsx?workspace=PRIVATE' at the Control Room path 'repository:///Automation%20Anywhere/Bots/<my projet name>/'. Check the file path and try again.

The file is quite obviously present, as I have loaded it perhaps one second ago. v0.2 is the correct version of the file, as stated in the global variables.

What can be the cause of the error ?

Best answer by Augustin

I think I found the solution : in a previous bot, the Excel : close action did not happen correctly, thus it was more or less “blocked”

5 replies

Forum|alt.badge.img+11
  • Author
  • Flight Specialist | Tier 4
  • Answer
  • March 26, 2025

I think I found the solution : in a previous bot, the Excel : close action did not happen correctly, thus it was more or less “blocked”


Lu.Hunnicutt
Pathfinder Community Team
Forum|alt.badge.img+19
  • Pathfinder Community Team
  • March 26, 2025

Thanks for circling back and closing the loop on this one, ​@Augustin !


Forum|alt.badge.img+11
  • Author
  • Flight Specialist | Tier 4
  • March 31, 2025

I have checked-in the bot and now I have the same error in public :

Get Resource failed. Error: Could not find the file 'Params_v0.2.xlsx?workspace=PUBLIC' at the Control Room path 'repository:///Automation%20Anywhere/Bots/<my projet name>/'. Check the file path and try again.

But it is the first time I run that bot, it can’t have been opened beforehand in public space.

EDIT : it also fails when I add an “Excel Basic : close” component in a Try/Catch component at the beginning of the bot

 

EDIT : I have checked in a new version of the file with a new parameter (say v0.3) with no difference with the previous file and it started working...


Marc Mueller
Most Valuable Pathfinder
Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • March 31, 2025

Hi ​@Augustin,

does this maybe help?

 

Cheers

Marc


Lu.Hunnicutt
Pathfinder Community Team
Forum|alt.badge.img+19
  • Pathfinder Community Team
  • April 4, 2025

@Augustin did you get this figured out or are you still seeing the error?