kkpatel
(Kamal)
January 18, 2022, 11:54am
1
Hi All
We have an excel file in a D drive folder which is a status file containing all the records processed.
Suddenly Bot is not able to read the file and creating multiple copies of the same file without any records.
File is blank without any column itself.
HI @kkpatel
Check if file exist return true when you check whether the file is in the location or not
Regards
Sudharsan
kkpatel
(Kamal)
January 18, 2022, 12:01pm
4
Yes file is in location. Looks like bot is not able to read the file.
But how come it is creating new files ?
Hi @kkpatel ,
Can you show a glimpse of code so that we can check.
Cheers
Could you please share a screenshot of the error message?
Thanks!
kkpatel
(Kamal)
January 18, 2022, 12:16pm
7
Its just using Excel Application Scope and reading the file and writing the file.
kkpatel
(Kamal)
January 18, 2022, 12:17pm
8
Actually that’s where we did a mistake. Instead of exception.message we just printed some custom message in the Catch section.
May be Bot is finding any Temp file so it starts creating another file. In that case you can check in a control of no Temp file availability.
lakshman
(Ganta lakshman)
January 18, 2022, 1:46pm
10
@kkpatel
Can you print the Exception.Message in catch section and share it here. So that we can check and help you to resolve the issue.
kkpatel
(Kamal)
January 18, 2022, 4:49pm
11
In the server the folder and files were made read only. Hence Bot was not able to read the file.
Thanks All…
system
(system)
Closed
January 21, 2022, 4:50pm
12
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.