Skip to main content
Solved

File : Assign randomly does not find the file

A
Forum|alt.badge.img+10

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”

View original
Did this topic help answer your question?

4 replies

A
Forum|alt.badge.img+10
  • Augustin
  • Author
  • Navigator | Tier 3
  • 73 replies
  • 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”

Marc Mueller
Vatsy
A
5 people like this
  • Marc Mueller
    Marc Mueller
  • Vatsy
    Vatsy
  • A
    Augustin
  • Aaron.Gleason
    Aaron.Gleason
  • Lu.Hunnicutt
    Lu.Hunnicutt
Lu.Hunnicutt
Pathfinder Community Team
Forum|alt.badge.img+11
  • Lu.Hunnicutt
  • Pathfinder Community Team
  • 66 replies
  • March 26, 2025

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

Let's Connect! www.linkedin.com/in/lu-hunnicutt-1290jan
Vatsy
1 person likes this
  • Vatsy
    Vatsy
A
Forum|alt.badge.img+10
  • Augustin
  • Author
  • Navigator | Tier 3
  • 73 replies
  • 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
Vatsy
A
3 people like this
  • Marc Mueller
    Marc Mueller
  • Vatsy
    Vatsy
  • A
    Augustin
Marc Mueller
Pathfinder Advocate | Tier 6
Forum|alt.badge.img+14
  • Marc Mueller
  • Pathfinder Advocate | Tier 6
  • 198 replies
  • March 31, 2025

Hi ​@Augustin,

does this maybe help?

 

Cheers

Marc

🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
Vatsy
1 person likes this
  • Vatsy
    Vatsy

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings