Originally posted by: Mintch Zulitch

Hi,

I want to run this sample code designed for reading data from a spreadsheet file (Excel); but I get the following error:

internal error (Please notify IBM)

My System:

IBM Ilog Cplex Optimization Studio 12.6 (32 bit)

Microsoft Office 2013 professional Plus (32 bit)

Hi,

can you try with an empty Excel spreadsheet with the same name but that you create with your 32 bits Excel version ?

do you get the error both with oplrun and within the IDE ?

what about the oil example that is in \opl\examples\opl\oil ?

regards

Originally posted by: Mintch Zulitch

Thanks for your answer,

1. I created an excel file from my 32-bit Excel, renamed it to the same name, replaced it with the old one and ran it. Again, I have the same problem.

2. I only ran the model form the IDE and I don't know how to run it on oplrun.

3. I ran the "oil example" (spreadsheet connection) and the problem is the same, again.

(please note that I sent these files to a friend of mine and he has also the same system, but he SUCCESSFULLY RAN the model!)

Hi,

Maybe you may open a PMR : http://www-01.ibm.com/support/docview.wss?uid=swg21507639

To try with oplrun : just use the command line and in the right folder you type oplrun model.mod data.dat

regards

Originally posted by: Mintch Zulitch

Hi,

I ran the model with "oplrun.exe". I captured the screen and attached the image file.

it says:

UNEXPECTED ERROR

-----------------------------

and a window pops out saying:

oplrun has stopped working!

-----------------------------

I dont know what the PMR is.

I googled my problem and that led me to some links; Some users have continuously reported this problem, but it seems there is no solution.

Hi,

what do you get if you do

int ab=maxint;
execute
{
writeln(ab);
}

?

regards

Originally posted by: Mintch Zulitch

2147483647

Originally posted by: bp325

Hi,
Did you solve this? I had the same problem and found that CPLEX would create the error if the excel files to be read were open when running the optimisation. Additionally, the only way I found to fix it (e.g. if I accidentally left it open on one run) was to restart the PC. Might suggest that it stores something weird in a tmp folder but I haven't gone looking for the solution as restarting does the trick.

Hope it helps if you haven't already solved it!

Bryn

Originally posted by: Mintch Zulitch

Hi,

To your surprise, I followed the same procedure as before on another PC with Cplex 32bit and Excel 32bit. It worked (Simply I ran the "oil" problem with spreadsheet). But I still get the same error on my own PC!