I have an error to solve my problem

722 views
Skip to first unread message

Ahmad Abedinpour

unread,
Feb 24, 2019, 1:00:16 PM2/24/19
to sup...@ampl.com, am...@googlegroups.com
my problem didn't solve yet
I have 2 problem:
1. I attached these file to one ODBC.rar file
it shows me :
"
ampl: model 'C:\Users\Ahmad\Desktop\ODBC\OperFin.mod';
ampl: include 'C:\Users\Ahmad\Desktop\ODBC\OperFebCL.run';
Error at _cmdno 2 executing "read_table" command
(file C:\Users\Ahmad\Desktop\ODBC\OperFebCL.run, line 37, offset 1940):

Error reading table DW with table handler odbc:
ODBC is not available."
and 
2. the same file with ".dat" file for data instead of excel file in previous file (code.rar).
and it shows me :
"
ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
144 invalid subscripts discarded:
PN['TA5X6',1]
PN['TA5X5',1]
PN['TA4X5',1]
and 141 more.
Error executing "solve" command:
error processing param PC:
432 invalid subscripts discarded:
PC['TA5X6',1,'CH']
PC['TA5X5',1,'CH']
PC['TA4X5',1,'CH']
and 429 more.
Error executing "solve" command:
error processing param CI:
16 invalid subscripts discarded:
CI['W1','TA5X6']
CI['W1','TA5X5']
CI['W1','TA4X5']
and 13 more.
Error executing "solve" command:
error processing param CID:
16 invalid subscripts discarded:
CID['D1','TA5X6']
CID['D1','TA5X5']
CID['D1','TA4X5']
and 13 more.
Error executing "solve" command:
error processing param CT:
18 invalid subscripts discarded:
CT['CH','P1','TM1']
CT['CD','P1','TM1']
CT['CL','P1','TM1']
and 15 more.
Error executing "solve" command:
error processing param CTW:
18 invalid subscripts discarded:
CTW['CH','W1','TM1']
CTW['CL','W1','TM1']
CTW['CD','W1','TM1']
and 15 more.
Error executing "solve" command:
error processing param CTD:
6 invalid subscripts discarded:
CTD['CH','D1','TM1']
CTD['CD','D1','TM1']
CTD['CL','D1','TM1']
and 3 more.
Error executing "solve" command:
error processing param CTPW:
12 invalid subscripts discarded:
CTPW['W1','P1','TM1']
CTPW['W2','P1','TM1']
CTPW['W1','P2','TM1']
and 9 more.
Error executing "solve" command:
error processing param CTPD:
12 invalid subscripts discarded:
CTPD['D1','P1','TM1']
CTPD['D2','P1','TM1']
CTPD['D1','P2','TM1']
and 9 more.
Error executing "solve" command:
error processing param CTWD:
12 invalid subscripts discarded:
CTWD['D1','W1','TM1']
CTWD['D2','W1','TM1']
CTWD['D1','W2','TM1']
and 9 more.

Bailing out after 10 warnings."
I send sevral email to  am...@googlegroups.com but not responding, I have a tight time, and I'm worried about it, please help me this way.
If my problem solve , I share my experience to http://groups.google.com/group/ampl.
thank you

code.rar
ODBC.rar

AMPL Google Group

unread,
Feb 24, 2019, 7:20:17 PM2/24/19
to Ampl Modeling Language
Your problem 2 was addressed here:

https://groups.google.com/d/msg/ampl/zrHLXvoYlGo/d0gPf5o0BQAJ

A separate reply to your problem 1 will be posted soon to this group.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}

AMPL Google Group

unread,
Feb 25, 2019, 10:17:29 AM2/25/19
to Ampl Modeling Language
Your problem 1 has been addressed here:

https://groups.google.com/d/msg/ampl/zrHLXvoYlGo/TTEFwfzUBAAJ

After installing Microsoft Access Database Engine 2016 (https://www.microsoft.com/en-us/download/details.aspx?id=54920&751be11f-ede8-5a0c-058c-2ee190a24fa6=True) by running the installer "AccessDatabaseEngine_X64.exe" you should see an ACEODBC.DLL driver named "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" under the tab drivers of odbcad32.exe.

In case AMPL does not use this driver right away (happens when there are 32- and 64-bit drivers installed) you should follow tip 3 as shown in OperFebCL_tip3.run. Before following tip 3 it may be worth trying with the "verbose" option as shown in OperFebCL_verbose.run in order to see which driver is being used.

In OperFebCL_verbose.run, every table declaration was changed as follows:

table CROP IN "ODBC" "OperFebCL.xls": CROP <- [CROP], Cfix, Psalv, Charv, Ccrop, LRH, LBH;

->

table CROP IN "ODBC" "OperFebCL.xls" "verbose": CROP <- [CROP], Cfix, Psalv, Charv, Ccrop, LRH, LBH;

In OperFebCL_tip3.run, every table declaration was changed as follows:

table CROP IN "ODBC" "OperFebCL.xls": CROP <- [CROP], Cfix, Psalv, Charv, Ccrop, LRH, LBH;

->

table CROP IN "ODBC" "Driver=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);ReadOnly=0;DBQ=./OperFebCL.xls" "verbose": CROP <- [CROP], Cfix, Psalv, Charv, Ccrop, LRH, LBH;

--
Filipe Brandão
am...@googlegroups.com
{#HS:786751730-37121#}
On Mon, Feb 25, 2019 at 12:19 AM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
Your problem 2 was addressed here:

https://groups.google.com/d/msg/ampl/zrHLXvoYlGo/d0gPf5o0BQAJ

A separate reply to your problem 1 will be posted soon to this group.

--
Robert Fourer
am...@googlegroups.com


On Sun, Feb 24, 2019 at 6:00 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
OperFebCL_tip3.run
OperFebCL_verbose.run

ahmad.abed...@gmail.com

unread,
Feb 27, 2019, 11:26:30 AM2/27/19
to AMPL Modeling Language
I done your tips, but shows me this error:
ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
144 invalid subscripts discarded:
PN[1,'TA5X6']
PN[1,'TA5X5']
PN[1,'TA4X5']
and 141 more.
Error executing "solve" command:
error processing param PC:
432 invalid subscripts discarded:
PC[1,'TA5X6','CH']
PC[1,'TA5X5','CH']
PC[1,'TA4X5','CH']
and 429 more.
Error executing "solve" command:
error processing param ES:
600 invalid subscripts discarded:
ES[1,'T1',1]
ES[1,'T2',1]
ES[1,'T3',1]
and 597 more.
Error executing "solve" command:
error processing param SH:
600 invalid subscripts discarded:
SH[1,'T1',1]
SH[1,'T2',1]
SH[1,'T3',1]
and 597 more.
Error executing "solve" command:
error processing param Freq:
10 invalid subscripts discarded:
Freq[1]
Freq[2]
Freq[3]
and 7 more.
Error executing "solve" command:
error processing param VG:
240 invalid subscripts discarded:
VG[1,'T1','TA5X6']
VG[1,'T2','TA5X6']
VG[1,'T3','TA5X6']
and 237 more.
Error executing "solve" command:
error processing param VQ:
80 invalid subscripts discarded:
VQ[1,'TA','Q2']
VQ[1,'CA','Q2']
VQ[2,'TA','Q2']
and 77 more.
Error executing "solve" command:
error processing param COL:
96 invalid subscripts discarded:
COL[1,'TA','Q2']
COL[1,'CA','Q2']
COL[2,'TA','Q2']
and 93 more.
Error executing "solve" command:
error processing param PROB:
96 invalid subscripts discarded:
PROB[1,'TA','Q2']
PROB[1,'CA','Q2']
PROB[2,'TA','Q2']
and 93 more.
Error executing "solve" command:
error processing param LAH:
12 invalid subscripts discarded:
LAH[1]
LAH[2]
LAH[3]
and 9 more.

Bailing out after 10 warnings.

OperFebCL - Copy.dat
OperFin.mod

ahmad.abed...@gmail.com

unread,
Feb 27, 2019, 11:26:30 AM2/27/19
to AMPL Modeling Language
I done your algorithm, but I can't solve it. I attached screen of this error.
{7DC31F6E-4974-46D3-9E50-6F53216FDE47}.bmp.jpg
{9F2182DA-9CCD-4435-924E-CF27E9C93363}.bmp.jpg

AMPL Google Group

unread,
Feb 27, 2019, 11:53:43 AM2/27/19
to Ampl Modeling Language
In your data file, you cannot write set expressions like this:

set DAYD := 1..18;
set DAYH := 1..12;
set Tm := 1..14;
set SCHE:=1..10;

These lead to unexpected results, as explained in this FAQ entry: https://ampl.com/faqs/why-does-set-s-50-70-give-me-a-set-of-only-3-members/. Instead you should write something like this in your model:

param nDAYD; set DAYD := 1..nDAYD;
param nDAYH; set DAYH := 1..nDAYH;
param nTm; set Tm := 1..nTm;
param nSCHE; set SCHE:=1..nSCHE;

and then in your data file you should remove the entries for DAYD, DAYH, Tm, and SCHE, and replace them by these param settings:

param nDAYD := 18;
param nDAYH := 12;
param nTm := 14;
param nSCHE := 10;

It is not necessary to define DAYD and DAYH as ordered. Instead of first(DAYD) or first(DAYH) you can write 1. Instead of last(DAYD) and last(DAYH) you can write nDAYD and nDAYH.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}
On Wed, Feb 27, 2019 at 4:26 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done your algorithm, but I can't solve it. I attached screen of this error.



On Wed, Feb 27, 2019 at 4:26 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done your tips, but shows me this error:

ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
144 invalid subscripts discarded:
PN[1,'TA5X6']
PN[1,'TA5X5']
PN[1,'TA4X5']
and 141 more.
Error executing "solve" command:
error processing param PC:
432 invalid subscripts discarded:
PC[1,'TA5X6','CH']
PC[1,'TA5X5','CH']
PC[1,'TA4X5','CH']

and 429 more.
Error executing "solve" command:
error processing param ES:
600 invalid subscripts discarded:
ES[1,'T1',1]
ES[1,'T2',1]
ES[1,'T3',1]
and 597 more.
Error executing "solve" command:

error processing param SH:
600 invalid subscripts discarded:
SH[1,'T1',1]
SH[1,'T2',1]
SH[1,'T3',1]
and 597 more.
Error executing "solve" command:

error processing param Freq:
10 invalid subscripts discarded:
Freq[1]
Freq[2]
Freq[3]
and 7 more.
Error executing "solve" command:

error processing param VG:
240 invalid subscripts discarded:
VG[1,'T1','TA5X6']
VG[1,'T2','TA5X6']
VG[1,'T3','TA5X6']
and 237 more.
Error executing "solve" command:

error processing param VQ:
80 invalid subscripts discarded:
VQ[1,'TA','Q2']
VQ[1,'CA','Q2']
VQ[2,'TA','Q2']
and 77 more.
Error executing "solve" command:

error processing param COL:
96 invalid subscripts discarded:
COL[1,'TA','Q2']
COL[1,'CA','Q2']
COL[2,'TA','Q2']
and 93 more.
Error executing "solve" command:

error processing param PROB:
96 invalid subscripts discarded:
PROB[1,'TA','Q2']
PROB[1,'CA','Q2']
PROB[2,'TA','Q2']
and 93 more.
Error executing "solve" command:

error processing param LAH:
12 invalid subscripts discarded:
LAH[1]
LAH[2]
LAH[3]

AMPL Google Group

unread,
Feb 27, 2019, 2:07:37 PM2/27/19
to Ampl Modeling Language
Regarding the messages "The AMPL Process has terminated", please run the commands directly in the AMPL prompt without using the IDE and send us screenshots of the output.

--
Filipe Brandão
am...@googlegroups.com
{#HS:786751730-37121#}
On Wed, Feb 27, 2019 at 4:53 PM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
In your data file, you cannot write set expressions like this:

set DAYD := 1..18;
set DAYH := 1..12;
set Tm := 1..14;
set SCHE:=1..10;

These lead to unexpected results, as explained in this FAQ entry: https://ampl.com/faqs/why-does-set-s-50-70-give-me-a-set-of-only-3-members/. Instead you should write something like this in your model:

param nDAYD; set DAYD := 1..nDAYD;
param nDAYH; set DAYH := 1..nDAYH;
param nTm; set Tm := 1..nTm;
param nSCHE; set SCHE:=1..nSCHE;

and then in your data file you should remove the entries for DAYD, DAYH, Tm, and SCHE, and replace them by these param settings:

param nDAYD := 18;
param nDAYH := 12;
param nTm := 14;
param nSCHE := 10;

It is not necessary to define DAYD and DAYH as ordered. Instead of first(DAYD) or first(DAYH) you can write 1. Instead of last(DAYD) and last(DAYH) you can write nDAYD and nDAYH.

--
Robert Fourer
am...@googlegroups.com


On Wed, Feb 27, 2019 at 4:26 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done your algorithm, but I can't solve it. I attached screen of this error.



On Wed, Feb 27, 2019 at 4:26 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done your tips, but shows me this error:

ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
144 invalid subscripts discarded:
PN[1,'TA5X6']
PN[1,'TA5X5']
PN[1,'TA4X5']
and 141 more.
Error executing "solve" command:
error processing param PC:
432 invalid subscripts discarded:
PC[1,'TA5X6','CH']
PC[1,'TA5X5','CH']
PC[1,'TA4X5','CH']

and 429 more.
Error executing "solve" command:
error processing param ES:
600 invalid subscripts discarded:
ES[1,'T1',1]
ES[1,'T2',1]
ES[1,'T3',1]
and 597 more.
Error executing "solve" command:

error processing param SH:
600 invalid subscripts discarded:
SH[1,'T1',1]
SH[1,'T2',1]
SH[1,'T3',1]
and 597 more.
Error executing "solve" command:

error processing param Freq:
10 invalid subscripts discarded:
Freq[1]
Freq[2]
Freq[3]
and 7 more.
Error executing "solve" command:

error processing param VG:
240 invalid subscripts discarded:
VG[1,'T1','TA5X6']
VG[1,'T2','TA5X6']
VG[1,'T3','TA5X6']
and 237 more.
Error executing "solve" command:

error processing param VQ:
80 invalid subscripts discarded:
VQ[1,'TA','Q2']
VQ[1,'CA','Q2']
VQ[2,'TA','Q2']
and 77 more.
Error executing "solve" command:

error processing param COL:
96 invalid subscripts discarded:
COL[1,'TA','Q2']
COL[1,'CA','Q2']
COL[2,'TA','Q2']
and 93 more.
Error executing "solve" command:

error processing param PROB:
96 invalid subscripts discarded:
PROB[1,'TA','Q2']
PROB[1,'CA','Q2']
PROB[2,'TA','Q2']
and 93 more.
Error executing "solve" command:

error processing param LAH:
12 invalid subscripts discarded:
LAH[1]
LAH[2]
LAH[3]

ahmad.abed...@gmail.com

unread,
Mar 1, 2019, 11:45:58 AM3/1/19
to AMPL Modeling Language
12.jpg

ahmad.abed...@gmail.com

unread,
Mar 1, 2019, 11:45:58 AM3/1/19
to AMPL Modeling Language
How to run the commands directly in the AMPL prompt without using the IDE??

ahmad.abed...@gmail.com

unread,
Mar 1, 2019, 11:45:58 AM3/1/19
to AMPL Modeling Language
I done and showed me:

ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
18 invalid subscripts discarded:
PN[1,'C1LX']
PN[2,'C1LX']
PN[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing param PC:
54 invalid subscripts discarded:
PC[1,'C1LX','CH']
PC[2,'C1LX','CH']
PC[3,'C1LX','CH']
and 51 more.
Error executing "solve" command:
error processing param DW:
54 invalid subscripts discarded:
DW[1,'C1LX','CD']
DW[2,'C1LX','CD']
DW[3,'C1LX','CD']
and 51 more.
Error executing "solve" command:
error processing param DM:
18 invalid subscripts discarded:
DM[1,'C1LX']
DM[2,'C1LX']
DM[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing objective total_revenue:
no value for PC[1,'C1XL','CD']
OperFebCL - Copy.dat
OperFin.mod

AMPL Google Group

unread,
Mar 1, 2019, 12:18:59 PM3/1/19
to Ampl Modeling Language
You need to run cmd.exe and then run "cd complete/path/to/the/folder/containing/the/ampl/executable". Once you are in the folder containing ampl.exe you can run it by typing "ampl.exe".

--
Filipe Brandão
am...@googlegroups.com
{#HS:786751730-37121#}
On Fri, Mar 1, 2019 at 4:46 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
How to run the commands directly in the AMPL prompt without using the IDE??



On Fri, Mar 1, 2019 at 4:46 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:



On Fri, Mar 1, 2019 at 4:45 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done and showed me:


ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
18 invalid subscripts discarded:
PN[1,'C1LX']
PN[2,'C1LX']
PN[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing param PC:
54 invalid subscripts discarded:
PC[1,'C1LX','CH']
PC[2,'C1LX','CH']
PC[3,'C1LX','CH']
and 51 more.
Error executing "solve" command:

error processing param DW:
54 invalid subscripts discarded:
DW[1,'C1LX','CD']
DW[2,'C1LX','CD']
DW[3,'C1LX','CD']
and 51 more.
Error executing "solve" command:

error processing param DM:
18 invalid subscripts discarded:
DM[1,'C1LX']
DM[2,'C1LX']
DM[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing objective total_revenue:
no value for PC[1,'C1XL','CD']



On Wed, Feb 27, 2019 at 7:07 PM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
Regarding the messages "The AMPL Process has terminated", please run the commands directly in the AMPL prompt without using the IDE and send us screenshots of the output.

--
Filipe Brandão
am...@googlegroups.com


AMPL Google Group

unread,
Mar 2, 2019, 8:01:10 PM3/2/19
to Ampl Modeling Language
In your data for set PROD, you have a member C1XL; but in the data for some of your params you call it C1LX. Hence you see many "invalid subscript" messages involving C1LX.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}
On Fri, Mar 1, 2019 at 5:18 PM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
You need to run cmd.exe and then run "cd complete/path/to/the/folder/containing/the/ampl/executable". Once you are in the folder containing ampl.exe you can run it by typing "ampl.exe".

--
Filipe Brandão
am...@googlegroups.com


On Fri, Mar 1, 2019 at 4:46 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
How to run the commands directly in the AMPL prompt without using the IDE??



On Fri, Mar 1, 2019 at 4:46 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:



On Fri, Mar 1, 2019 at 4:45 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I done and showed me:


ampl: model 'C:\Users\Ahmad\Desktop\code\OperFin.mod';
ampl: data 'C:\Users\Ahmad\Desktop\code\OperFebCL - Copy.dat';
ampl: solve;
Error executing "solve" command:
error processing param PN:
18 invalid subscripts discarded:
PN[1,'C1LX']
PN[2,'C1LX']
PN[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing param PC:
54 invalid subscripts discarded:
PC[1,'C1LX','CH']
PC[2,'C1LX','CH']
PC[3,'C1LX','CH']
and 51 more.
Error executing "solve" command:

error processing param DW:
54 invalid subscripts discarded:
DW[1,'C1LX','CD']
DW[2,'C1LX','CD']
DW[3,'C1LX','CD']
and 51 more.
Error executing "solve" command:

error processing param DM:
18 invalid subscripts discarded:
DM[1,'C1LX']
DM[2,'C1LX']
DM[3,'C1LX']
and 15 more.
Error executing "solve" command:
error processing objective total_revenue:
no value for PC[1,'C1XL','CD']



On Wed, Feb 27, 2019 at 7:07 PM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
Regarding the messages "The AMPL Process has terminated", please run the commands directly in the AMPL prompt without using the IDE and send us screenshots of the output.

--
Filipe Brandão
am...@googlegroups.com


ahmad.abed...@gmail.com

unread,
Mar 3, 2019, 12:46:09 AM3/3/19
to AMPL Modeling Language
I don't understand completely, Are you meaning it?
{E6A9C93F-CB8B-4F40-8961-89C2C22C688F}.png.jpg

ahmad.abed...@gmail.com

unread,
Mar 3, 2019, 12:46:09 AM3/3/19
to am...@googlegroups.com
OperFebCL - Copy.dat
OperFin.mod

ahmad.abed...@gmail.com

unread,
Mar 5, 2019, 9:47:31 AM3/5/19
to AMPL Modeling Language
You right about it, when I run solve button, shows me:
"Sorry, a demo licenses for AMPL is limited to 500 variables
and 500 constraints and objectives (after presolve) for linear
problems.  You have 193390 variables, 176235 constraints, and 1 objective."
I upload these files to NEOS and run it, and shows me:
" NEOS Server Version 5.0
   Job#     : 6651309
   Password : WyDoNFcH
   Solver   : lp:CPLEX:AMPL
   Start    : 2019-03-04 23:22:00
   Host     : NEOS HTCondor Pool

   Disclaimer:

   This information is provided without any express or
   implied warranty. In particular, there is no warranty
   of any kind concerning the fitness of this
   information  for any particular purpose.
*************************************************************
No results yet.  Try reloading page later."
what should I do to solve my problem?

AMPL Google Group

unread,
Mar 5, 2019, 3:04:05 PM3/5/19
to Ampl Modeling Language
"No results yet" means that CPLEX is still running and has not yet returned a solution for your problem. Try sending NEOS also a command file that contains these commands:

option cplex_options 'mipdisplay=2 time=3600";
solve;

Then CPLEX will stop after an hour and return a log of its progress so far. Depending on the results, you can re-run with a longer time limit and can add some "display" statements to show the values of some of the variables.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}
On Tue, Mar 5, 2019 at 2:47 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
You right about it, when I run solve button, shows me:
"Sorry, a demo licenses for AMPL is limited to 500 variables
and 500 constraints and objectives (after presolve) for linear
problems. You have 193390 variables, 176235 constraints, and 1 objective."
I upload these files to NEOS and run it, and shows me:
" NEOS Server Version 5.0

Job# : 6651309
Password : WyDoNFcH
Solver : lp:CPLEX:AMPL
Start : 2019-03-04 23:22:00
Host : NEOS HTCondor Pool

Disclaimer:

This information is provided without any express or
implied warranty. In particular, there is no warranty
of any kind concerning the fitness of this
information for any particular purpose.
*************************************************************
No results yet. Try reloading page later."
what should I do to solve my problem?



On Sun, Mar 3, 2019 at 5:46 AM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:



On Sun, Mar 3, 2019 at 5:46 AM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I don't understand completely, Are you meaning it?



On Sun, Mar 3, 2019 at 1:00 AM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
In your data for set PROD, you have a member C1XL; but in the data for some of your params you call it C1LX. Hence you see many "invalid subscript" messages involving C1LX.

--
Robert Fourer
am...@googlegroups.com


ahmad.abed...@gmail.com

unread,
Mar 7, 2019, 10:46:51 AM3/7/19
to AMPL Modeling Language
   Disclaimer:

   This information is provided without any express or
   implied warranty. In particular, there is no warranty
   of any kind concerning the fitness of this
   information  for any particular purpose.
*************************************************************

amplin, line 1360 (offset 39193):
	missing '
context:   >>> option cplex_options 'mipdisplay=2 time=3600"; <<< 
pdisplay=2 time=3600";
solve;
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Checking ampl.mod for cplex_options...
Checking ampl.com for cplex_options...
Executing AMPL.
processing data.
processing commands.
Executing on prod-exec-2.neos-server.org
 Error (2) in /opt/ampl/ampl -R amplin
command.run
OperFebCL - Copy.dat
OperFin.mod

AMPL Google Group

unread,
Mar 7, 2019, 11:04:06 AM3/7/19
to Ampl Modeling Language
Sorry, a string should not start with ' and end with " -- try:

option cplex_options 'mipdisplay=2 time=3600';

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}

ahmad.abed...@gmail.com

unread,
Mar 25, 2019, 9:22:30 AM3/25/19
to AMPL Modeling Language
I wrote "option cplex_options 'mipdisplay=2 time=3600';" in command.run file and upload it but no solved and showed me previous error that send you,
what is your main mean?

AMPL Google Group

unread,
Mar 25, 2019, 11:17:31 AM3/25/19
to Ampl Modeling Language
Please copy the *entire* message from NEOS into your email, even if you think it is the same as before. There may be some small but important differences.

Note that it is very important to copy all of the lines from the NEOS message to your email, not only the lines that appear to be error messages.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}
On Mon, Mar 25, 2019 at 1:22 PM UTC, Ampl Modeling Language <am...@googlegroups.com> wrote:
I wrote "option cplex_options 'mipdisplay=2 time=3600';" in command.run file and upload it but no solved and showed me previous error that send you,what is your main mean?



On Thu, Mar 7, 2019 at 4:02 PM UTC, AMPL Google Group <am...@googlegroups.com> wrote:
Sorry, a string should not start with ' and end with " -- try:

option cplex_options 'mipdisplay=2 time=3600';

--
Robert Fourer
am...@googlegroups.com


ahmad.abed...@gmail.com

unread,
Mar 29, 2019, 8:53:10 AM3/29/19
to AMPL Modeling Language
this is all of text that they sent to me:
File exists
You are using the solver cplexamp.
Checking ampl.mod for cplex_options...
Executing AMPL.
processing data.
processing commands.

Presolve eliminates 397348 constraints and 378552 variables.
Adjusted problem:
187098 variables:
    7160 binary variables
    1608 integer variables
    178330 linear variables
176235 constraints, all linear; 887278 nonzeros
    19005 equality constraints
    157230 inequality constraints
1 linear objective; 66290 nonzeros.

Setting $presolve_fixeps >= 2.79e-10 could change presolve results.

CPLEX 12.7.0.0: threads=4

Error: Your job was terminated because it exceeded the maximum allotted memory for a job.

Please refer to the NEOS Server FAQ (https://neos-guide.org/content/FAQ) for more information regarding job termination conditions.

AMPL Google Group

unread,
Mar 29, 2019, 1:45:55 PM3/29/19
to Ampl Modeling Language
The response from NEOS is clear:


Error: Your job was terminated because it exceeded the maximum allotted memory for a job.

Please refer to the NEOS Server FAQ (https://neos-guide.org/content/FAQ) for more information regarding job termination conditions.


You should consider experimenting on NEOS with a smaller version of your data. If you have a computer with more memory than NEOS provides, then you can write to lice...@ampl.com to ask what your options are for installing AMPL and a solver on it.

--
Robert Fourer
am...@googlegroups.com
{#HS:786751730-37121#}
Reply all
Reply to author
Forward
0 new messages