Hi!
I’m running GAMS 23.5.2 with a license for CPLEX solver.
However, when (and only when) I run GAMS from an Excel Macro it doesn’t solve the model and a window pops up say there’s a licensing error.
In the lst file appears the following message:
MODEL STATISTICS
BLOCKS OF EQUATIONS 10 SINGLE EQUATIONS 217
BLOCKS OF VARIABLES 8 SINGLE VARIABLES 8,306 9 projected
NON ZERO ELEMENTS 32,254 DISCRETE VARIABLES 32
**** THE MODEL EXCEEDS THE DEMO LIMITS
**** MAX MATRIX ROWS 300
**** MAX MATRIX COLUMNS 300
**** MAX NON ZERO ELEMENTS 2000
**** MAX NON LINEAR N-Z 1000
**** MAX DISCRETE VARIABLES 50
**** Terminated due to a licensing error
Do you know how can I force excel to use the license file (gamslice.txt) that I have in the gams directory so the model can be solved?
Thanks!
On Tuesday, 11 October 2011 07:52:21 UTC+1, Michael Bussieck wrote:
The settings in the GAMS IDE are not necessarily visible to other
programs that use GAMS (e.g. the Excel macros). You could specify the
solver inside your GAMS model:
- Put this line in front of the solve statement
option mip=gurobi, lp=gurobi, rmip=gurobi;
You can also add ‘mip=gurobi lp=gurobi rmip=gurobi’ to the command
line/option statement of your GAMS call inside the Excel macro.
A third variant: In the GAMS IDE you can set solvers for the project,
local, and system. If you set Gurobi as the default in the system
defaults, this should also stick with other programs like Excel.
Hope this helps,
Michael
On Oct 10, 5:31 pm, Mr Cooper wrote:
I currently am running GAMS 23.7 with a full gurobi solver license.
I am running GAMS from an Excel macro and everything seems to be
working according to McCarl’s guide, however, when I run a larger
model using the macro a screen pops up saying I have exceeded my
license for some reason it continues to try to pick Cplex even though
I have gurobi set in the GAMSIDE. I tried changing the gamside.ini
file, but it it doesn’t seem to work. Any suggestions on how to get
around this issue, using the ini file or another method?
–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/Sv2jaLrv0UgJ.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.