"An unexpected error occurred when solving the model." when Gurobi solver is called through VBA
My model solves ok in about 35 minutes with the Gurobi solver in Premium Solver Platform, both version 10.5 in Excel 2010 (64 bits) on Windows 7. But when I call this solver through VBA, the problem seems to be solved but in the end I get the message:
An unexpected error occurred when solving the model.
It is recommended you save your workbook, and restart Excel.
It takes about 1 hour and 24 minutes before the model is released. Is this a bug in Solver in version 10.5? How can this problem be solved?
---- Start Solve ----
No uncertain input cells.
Using: Full Reparse.
Releasing Memory...
Releasing Memory...
Analyzing Solver Model...
Parsing started...
Diagnosis started...
Model diagnosed as "LP Convex".
User engine selection: Gurobi LP/MIP Solver
Model: [dairyplan14.xlsm]LP
Using: Psi Interpreter
Parse time: 22 Minutes, 56 Seconds.
Engine: Gurobi LP/MIP Solver
Setup time: 10 Minutes, 47 Seconds.
Optimize a model with 114660 rows, 10452 columns and 264222 nonzeros
Presolve removed 9932 rows and 114140 columns
Presolve time: 0.22s
Presolved: 520 rows, 520 columns, 28025 nonzeros
Iteration Objective Primal Inf. Dual Inf. Time
0 0.0000000e+00 2.841914e+04 1.120239e+12 0s
312 4.9829854e+03 0.000000e+00 0.000000e+00 0s
Solved in 312 iterations and 0.45 seconds
Optimal objective 4.982985434e+03
Engine Solve time: 0.45 Seconds.
An unexpected error occurred when solving the model.
It is recommended you save your workbook, and restart Excel.
Releasing Memory...
Releasing Memory...
Solve time: 1 Hours, 24 Minutes, 0 Seconds.
Please sign in to leave a comment.
Comments
0 comments