[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [HTCondor-users] Excel issue when using Matlab with Condor.



Is there something I can do to as a workaround maybe?


On Thu, Dec 5, 2013 at 5:09 PM, Stub <spamrefuse@xxxxxxxxx> wrote:
The Condor context does not seem to have a GUI, whereas the CMD environment kind of still has......it could be that the Excel support in Matlab chokes on that.....just a wild guess. -Rob.


On Thursday, December 5, 2013 8:19 PM, Dennis Zheleznyak <dennis@xxxxxxxxxxxxx> wrote:
Hello all,

We are using the following layout:
Latest 8.1.2 Condor
Windows 7 Professional 64Bit
Microsoft Office 2007 Enterprise
MatLab R2013a

We've complied a small program that accepts a parameter, searches for it inside the first column of an Excel sheet and prints the content of the line to a file which the compiled program creates. 

When running the program through CMD it works properly, as intended (a file is being created with the content of the desired line):
program.exe <string parameter>

When sending it through Condor, the following error is received:

{ Error using Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: Microsoft Office Excel cannot access the file
'C:\condor\execute\dir_10592\DataBase22.xlsx'. There are several possible
reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open
workbook.
Help File: C:\Program Files (x86)\Microsoft Office\Office12\1033\XLMAIN11.CHM
Help Context ID: 0

Error in xlsreadCOM (line 13)
Error in xlsread (line 230)
Error in demo22 (line 31)
}  
MATLAB:COM:E2148140012

This is our condor submit file:

executable = readingexcel.exe
arguments = 657
input = DataBase22.xlsx
transfer_input_files = DataBase22.xlsx
universe = vanilla
output = output.$(cluster)
error = error.$(cluster)
log = log.$(cluster)
should_transfer_files = YES
when_to_transfer_output = ON_EXIT
getenv= True
load_profile = True
queue 1

The excel sheet opens properly, it is copied to the temporary condor\execute folder and has valid data inside.

I searched for a solution in Google, tried adding 'basic' to the xlsread and it didn't help either.

I also made sure that all excel processes are closed before starting the job. 

Does anyone have any suggestion ?

Thank you,
Dennis. 

_______________________________________________
HTCondor-users mailing list
To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users

The archives can be found at:
https://lists.cs.wisc.edu/archive/htcondor-users/


_______________________________________________
HTCondor-users mailing list
To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users

The archives can be found at:
https://lists.cs.wisc.edu/archive/htcondor-users/