Error reading XLS via FWH app running as scheduled task

Error reading XLS via FWH app running as scheduled task

Postby cdmmaui » Fri Apr 08, 2022 8: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
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

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

Postby Antonio Linares » Sat Apr 09, 2022 6: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
User avatar
Antonio Linares
Site Admin
 
Posts: 42059
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

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

Postby cdmmaui » 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
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

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

Postby Rick Lipkin » Sat Apr 09, 2022 1: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
User avatar
Rick Lipkin
 
Posts: 2663
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby hmpaquito » Sat Apr 09, 2022 1:52 pm

Use another schedule task
hmpaquito
 
Posts: 1482
Joined: Thu Oct 30, 2008 2:37 pm

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

Postby cdmmaui » 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
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Otto and 71 guests