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

["Upton, Stephen (Steve) (CIV)" <scupton@xxxxxxx>]

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