+2Hello,
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
Best answer by mohansx
Hello
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.
+5Hello
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.
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
