Error while reading database on Cloud

  • 19 August 2021
  • 1 reply

Badge +2



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.


Thank You,

Vishwesh Patil


Best answer by mohansx 20 August 2021, 00:13

View original

1 reply

Userlevel 5
Badge +5

Hello @vishweshpatil 


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. 


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator