FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Error reading XLS via FWH app running as scheduled task
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Error reading XLS via FWH app running as scheduled task
Posted: Fri Apr 08, 2022 08:56 PM

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
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Error reading XLS via FWH app running as scheduled task
Posted: Sat Apr 09, 2022 06:05 AM

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
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Re: Error reading XLS via FWH app running as scheduled task
Posted: Sat Apr 09, 2022 10:43 AM

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
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: Error reading XLS via FWH app running as scheduled task
Posted: Sat Apr 09, 2022 01:48 PM

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

Posts: 1515
Joined: Thu Oct 30, 2008 02:37 PM
Re: Error reading XLS via FWH app running as scheduled task
Posted: Sat Apr 09, 2022 01:52 PM

Use another schedule task

Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Re: Error reading XLS via FWH app running as scheduled task
Posted: Mon Apr 11, 2022 11:45 AM

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

Continue the discussion