Mailing List ArchivesAuthenticated access |
![[Computer Systems Lab]](http://www.cs.wisc.edu/pics/csl_logo.gif){kind=logo}
|
Mailing List ArchivesAuthenticated access |
|
|
Nikos, After checking (again), Excel can run multiple instances, where each instance is accessing the same file, so that doesnât appear to be the problem (dopey me). You will be running multiple concurrent instances of Excel on multiple machines
using HTCondor. What happens if you just submit one job with HTCondor so that you only have one GAMS/Excel application running? Do you get the same error? GAMS may also be injecting a constraint, but I donât recall any issues we had with running GAMS (although
we didnât read in data from Excel either). Have you checked that you have the regular version of Excel installed instead of the Click-to-run as the error indicates? I doubt this is the issue since you can presumably run your GAMS model without condor. steve From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of 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> 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> 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 |