Error reading XLS via FWH app running as scheduled task

Post Reply
User avatar
cdmmaui
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong
Contact:

Error reading XLS via FWH app running as scheduled task

Post 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,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
Antonio Linares
Site Admin
Posts: 42599
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Has thanked: 41 times
Been thanked: 88 times
Contact:

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

Post 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 ?
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
cdmmaui
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong
Contact:

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

Post 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
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
Rick Lipkin
Posts: 2675
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Post 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
hmpaquito
Posts: 1482
Joined: Thu Oct 30, 2008 2:37 pm

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

Post by hmpaquito »

Use another schedule task
User avatar
cdmmaui
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong
Contact:

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

Post 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.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
Post Reply