Skip to main content

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 ?

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”

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

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...

Hi ​@Augustin,

does this maybe help?

 

Cheers

Marc

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

Reply


Terms & ConditionsCookie settings