I am trying to read a db file on Cloud but it is showing the error attached herewith.
I have created a parameter that reads value from the database Output.db with procedure ReadTable. Also, I have created a procedure AddRecord to add record to the database.
I exported the aimms file to aimmspack file and uploaded it on Cloud. But it is not performing the as expected.
Could you please help me with this problem? I have attached the model as well.
Best answer by mohansxView original
This won’t work as you need the underlying database engine along with the .db to be able to read/write data. Databases are provided as a separate instance on AIMMS Cloud (with MySQL engine). SQLite3 is not available, and in general - including database files in the aimmspack file will not work.
You should include a csv or xlsx file and use the DataExchange or AXLL library to read in the data. You could also store the input data as a case file and load that on startup.