Mailing List ArchivesPublic Access |
![[Computer Systems Lab]](https://www-auth.cs.wisc.edu/pics/csl_logo.gif){kind=logo}
|
Mailing List ArchivesPublic Access |
|
|
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>
Sent: Thursday, May 2, 2019 6:27 PM To: HTCondor-Users Mail List; HTCondor-users Subject: Re: [HTCondor-users] Problem reading Excel when running an application on many machines using HTCondor 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
|