Page 1 of 1

Error reading XLS via FWH app running as scheduled task

PostPosted: Fri Apr 08, 2022 8:56 pm
by cdmmaui
Hello,

I am getting the following error on FWH app running as scheduled task on Windows Server 2019.

Error Reading XLS: F:\web\webfrt\xxx\inbox\ACE-AES-XLS-ORDER 485885.xlsx - [DISP_E_EXCEPTION]

What can I do to resolve the problem?

Thank you,

Re: Error reading XLS via FWH app running as scheduled task

PostPosted: Sat Apr 09, 2022 6:05 am
by Antonio Linares
Dear Darrell,

Have you checked that F:\web\webfrt\xxx\inbox\ACE-AES-XLS-ORDER 485885.xlsx exists and that it is a valid file also ?

Re: Error reading XLS via FWH app running as scheduled task

PostPosted: Sat Apr 09, 2022 10:43 am
by cdmmaui
Hi Antonio,

The file is there. If I run application from command line it works fine. There is something about the scheduled task that is stopping it from running

Re: Error reading XLS via FWH app running as scheduled task

PostPosted: Sat Apr 09, 2022 1:48 pm
by Rick Lipkin
Darrell

Searching your problem .. I noticed that [DISP_E_EXCEPTION] seemed to occur after a Server 2019 update .. check if your server has received any Microsoft updates recently ( past week or so ) .. If yes, you might consider uninstalling each ( recent ) update one by one and see if you find your answer ..

Rick Lipkin

Re: Error reading XLS via FWH app running as scheduled task

PostPosted: Sat Apr 09, 2022 1:52 pm
by hmpaquito
Use another schedule task

Re: Error reading XLS via FWH app running as scheduled task

PostPosted: Mon Apr 11, 2022 11:45 am
by cdmmaui
Hello Everyone,

Thank you for your responses. I have been investigating further and found the Windows Server 2019 does not allow for "unattended" access to open XLS through scheduled task. I will ask customer to change format to CSV and read as text.