Decision Optimization

Hello,

I have fallowed the tutorial "Solving OPL models on the cloud" and successfully run some basic projects using Watson Machine Learning, from my local computer.

Now I am trying to run a more complex project that uses a .dat file to get some data from an external file (csv or excel). However SheetConnection is not working and I am getting the error message "Failed (Error during generation …. Data parsing error:syntax error, …)"

The model works just fine on CPLEX OPL Studio but now we need a more powerful machine, so we are trying to solve it on cloud. Is there a function like ShettConnection that allows us to connect the data with the project running on the cloud?

Thank you in advance.

Alexandra

Hello,

I have fallowed the tutorial "Solving OPL models on the cloud" and successfully run some basic projects using Watson Machine Learning, from my local computer.

Now I am trying to run a more complex project that uses a .dat file to get some data from an external file (csv or excel). However SheetConnection is not working and I am getting the error message "Failed (Error during generation …. Data parsing error:syntax error, …)"

The model works just fine on CPLEX OPL Studio but now we need a more powerful machine, so we are trying to solve it on cloud. Is there a function like ShettConnection that allows us to connect the data with the project running on the cloud?

Thank you in advance.

Alexandra

Hello,
Thanks for the answer.

Now I can export external data in a model to an output file .dat, but for that I need to run the model, as explained in

https://www.ibm.com/docs/en/icos/20.1.0?topic=files-exporting-external-data

That works just fine when the .csv file has a few data and I can run it using Watson Machine Learning, from my local computer. My problem is that the amount of data of the model that I want to run is very big, so I get an "out of memory error" when I try to create the .dat file, when I run it in ILOG CPLEX Optimization Studio.

Is there another way to do it?
Thanks again.

Alexandra

Hello,

I have fallowed the tutorial "Solving OPL models on the cloud" and successfully run some basic projects using Watson Machine Learning, from my local computer.

Now I am trying to run a more complex project that uses a .dat file to get some data from an external file (csv or excel). However SheetConnection is not working and I am getting the error message "Failed (Error during generation …. Data parsing error:syntax error, …)"

The model works just fine on CPLEX OPL Studio but now we need a more powerful machine, so we are trying to solve it on cloud. Is there a function like ShettConnection that allows us to connect the data with the project running on the cloud?

Thank you in advance.

Alexandra