Solved

Error while reading database on Cloud

  • 19 August 2021
  • 1 reply
  • 19 views

Badge

Hello,

 

I am trying to read a db file on Cloud but it is showing the error attached herewith.

Description:

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

icon

Best answer by mohansx 20 August 2021, 00:13

View original

1 reply

Userlevel 5
Badge +2

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. 

Reply


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

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