Originally posted by: JörgK

Hi all,

I recently installed CPLEX Enterprise Server 12.6.1 (and WAS 7) on our ComputeServer. The enterprise server has been properly installed and I can connect to it from other computers to execute models.

However, using the CPLEX-server connection seemingly only works if all data is given directly in the .dat file. If I try to access an Excel file, the optimization stops with the error message: "java.lang.RuntimeException: Exception from IBM ILOG Concert: Problem accessing the Excel file".

Excel has been installed on the ComputeServer. Moreover, if I execute the model locally on the ComputeServer without using the CPLEX-server connection, it works. Only if I try to use the CPLEX-server connection, it crashes.

Has anybody encountered a similar problem?

Cheers,

Jörg.

Hi,

in CPLEX Enterprise Server 12.4, the Excel connection was not supported. Have you read that this has changed ?

As a workaround you may locally generate an external .dat and then call the server with this .dat

regards

Originally posted by: JörgK

Hi Alex,

thanks for the info.

This was the first time I installed the CPLEX Enterprise Server and I was not aware that there have been issues with the Excel connection in previous versions.

I found only the description of version 12.4 on the IBM web pages. There does not seem to be a similar, up-to-date description for 12.6(.1). I also could not find any info about the Excel connection in the Knowledge Center for CPLEX Enterprise Server 12.6.1.

The only info that seems to suggest that the Excel connection is indeed still not supported is: http://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/6/897/ENUS214-426/index.html&lang=en&request_locale=en#softx
Whereas Excel is listed as a connector for the CPLEX Optimization Studio (among others), it is not listed for the CPLEX Enterprise Server.

Cheers,
Jörg.

hi

can you try with an absolute path in SheetConnection ?

regards

Originally posted by: JörgK

Hi,

I already tried this the first time I encountered the problem and it did not help. It also did not help to copy the Excel file to the server and point the SheetConnection to this file.

Cheers,
Jörg

Hi

and have you tried to use resolvePath  on the excel filr name?

regards

Originally posted by: JörgK

Hi,

thanks. No, not yet.

But I am currently facing the problem that the CPLEX-Server does not respond, although the Optimization Server on WAS 7 is running. I'll test your suggestion as soon as I have resolved this issue.

Jörg.