Mailing List ArchivesAuthenticated access |
![[Computer Systems Lab]](http://www.cs.wisc.edu/pics/csl_logo.gif){kind=logo}
|
Mailing List ArchivesAuthenticated access |
|
|
Nikos, The only other thing I can think of now is what permissions you have set for your c:\condor_test folder (and sub folders).
Good luck! steve From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of Nikolaos Tasios <nikolaos.tasios.e3mlab@xxxxxxxxxxx> This time, i added the "load_profile = true" in the submit file of my job, but again the job does not run correctly with the following message.
The message now is different from the previous times " GDXXRW ....(version of GAMS) Input file : C:\condor_test\in_files\md....xlsx Output file: C:\condor_test\in_files\md....gdx **** Exception = Microsoft Excel cannot access the file 'C:\condor_test\in_files\md.....xlsx'. There are several possible reasons: â The file name or path does not exist. â The file name and the path does exist. â The file is being used by another program. âThe file is not used by another program as seen from the task manager â The workbook you are trying to save has the same name as a currently open workbook âI am not trying to save an excel file and none EXCEL file is open in the machine. Only a job run using HTCondor is trying to read
ONE excel file. Total time = 3110 Ms " In red, you may see some comments based on the error message. Thank you again for your support, any advice is very much appreciated. Best, Nikos Dr. â Eng. Nikolaos Tasios Researcher in Energy Economics National Technical University of Athens From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of John M Knoeller <johnkn@xxxxxxxxxxx> Excel needs access to the registry in order to work correctly. But HTCondor does not initialize the registry for the HTCondor user that is running a job unless the job specifically requests that it do so.
You need to submit your job with one (and only one) of these in order to have a registry available when the job runs. load_profile = true or run_as_owner = true run_as_owner will also require that you have use condor_store_cred to store the username/password of the user submitting the job.
so load_profile is preferred unless for some reason you want the job to have access to the userâs registry settings. -tj From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx>
On Behalf Of Nikolaos Tasios Dear Steve, The above issue with excel appears even if i run only one job with HTCondor . The machine has the "standard" excel 2013 installed and the
same job if i run it on the same machine myself and not using HTCondor runs perfectly. Nikos Dr. â Eng. Nikolaos Tasios Researcher in Energy Economics National Technical University of Athens From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> on behalf of Upton, Stephen (Steve) (CIV) <scupton@xxxxxxx> 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 |