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
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.
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: