Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  Execution problem

    Posted 10/09/20 07:25 AM
    Hello, 

    I tested a model that I developed with a small data that I entered it manually and I got a results. When I wanted to run it with all the data I have, so I impored  the excel file and the program displayed this error "Please notify IBM" (As it shown in the attached figure) 


    Does anyone know how can I solve it ?

    Thank you in advance.
    Regards,


    ------------------------------
    Khaoula EL MHAMDI
    ------------------------------

    #DecisionOptimization


  • 2.  RE: Execution problem

    Posted 10/09/20 08:57 AM
    Hi,

    do you get the same error if you add

    execute
    {
    cplex.threads=1;
    }

    in your model ?

    can you attach your model and data so that other user could try ?

    regards

    ------------------------------
    ALEX FLEISCHER
    ------------------------------



  • 3.  RE: Execution problem

    Posted 10/09/20 11:20 AM
    Hi,

    Thank Alex for your response. 

    I do not know the usefulness of this instruction but I tested it and I still have the same problem.
    I have attatched the model and the data that I'm using. 


    The problem that I can get a result by using those data (in the figure below) but when each time I try to import the excel file it doesn't work.


    Regards,

    ------------------------------
    Khaoula EL MHAMDI
    ------------------------------



  • 4.  RE: Execution problem

    Posted 10/09/20 11:40 AM
    Edited by System Admin 01/20/23 04:22 PM
    Hi,
    many errors in your model.

    For instance I would write

    {int} I=...; // the SKU i of the program reference i
    {int} J=...; //Different storage area
    {int} J1=...;

    because I and J are no scalar but sets

    in the .dat you wrote

    I from SheetRead(my_sheet,"'data'!B2:B187");

    but the name of the tab in excel is not data but Sheet1

    Let me attach the 3 updated files I managed to run.

    regards
    https://higherlogicdownload.s3.amazonaws.com/IMWUC/UploadedImages/c9cf5bd6-c6fe-4997-ac21-877398af6ab3/stacko2020.zip
    ------------------------------
    ALEX FLEISCHER
    ------------------------------