Re: [HTCondor-users] Problem reading Excel when running an application on many machines using HTCondor

[Nikolaos Tasios <nikolaos.tasios.e3mlab@xxxxxxxxxxx>]

Dear Steve and all,

   Yes the Excel files are on the machine that the GAMS model is running and the excel is installed on that machine.  On the machine that i am trying to run my model using HTCondor is no Excel file opened beforehand.

>From the submit machine i assign a job to run on any machine that is connected but the message when my model tries to read an excel file is the same 

"

Cannot create an instance of Excel: Error = Server execution failed, ProgID: "Excel.Application"

Check that Excel is installed correctly.

In case you use the "Click-to-Run" version of Excel, uninstall

this version and install the regular version.

**** Problem opening Excel: Cannot create an instance of Excel: Error = Server execution failed, ProgID: "Excel.Application"

"

Do you have any clue about the issue?

Thank you a lot in advance for your help.

Best ,

Nikos

---

From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of Upton, Stephen (Steve) (CIV) <scupton@xxxxxxx>
Sent: Thursday, May 2, 2019 3:05 PM
To: HTCondor-Users Mail List; HTCondor-users
Subject: Re: [HTCondor-users] Problem reading Excel when running an application on many machines using HTCondor

 

Nikos,

 

Are your Excel files that you are trying to open on the same machine have the same file name? Excel will have issues with opening 2 workbooks of the same name. You might want to try a small test on one machine, without HTCondor, using the command prompt.

 

steve

 

From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of Nikolaos Tasios <nikolaos.tasios.e3mlab@xxxxxxxxxxx>
Reply-To: "htcondor-users@xxxxxxxxxxx" <htcondor-users@xxxxxxxxxxx>
Date: Thursday, May 2, 2019 at 5:26 AM
To: "htcondor-users@xxxxxxxxxxx" <htcondor-users@xxxxxxxxxxx>, HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx>
Subject: [HTCondor-users] Problem reading Excel when running an application on many machines using HTCondor

 

Dear,

 

 I have the following issue concerning the use of excel through condor.

 We use General Algebraic Modelling System (GAMS) and we run it in many machines. In GAMS we write mathematical models reading input data from excel and generating output again in excel format. From inside GAMS model we read several excel files containing input data. When we try to run our GAMS models using HTCondor on many machines we get the following error when trying to read the excel files

"

Cannot create an instance of Excel: Error = Server execution failed, ProgID: "Excel.Application"

Check that Excel is installed correctly.

In case you use the "Click-to-Run" version of Excel, uninstall

this version and install the regular version.

**** Problem opening Excel: Cannot create an instance of Excel: Error = Server execution failed, ProgID: "Excel.Application"

"

The Excel application is installed, in every machine that we use, as standalone application

 

Do you have any clue about the issue?

 

Thank you a lot in advance for your help.

 

Best ,

Nikos