Redshift Database Connection Issue

[hao_zhou]

[ FlexSim 19.0.2 ]

I was trying to use database connector to connect with Redshift database. In the "Database Type" drop down list, since there is no option for Redshift, I used "PostgreSQL". I tried "Test Connection", it shows succeed. But there are exceptions as follows. I tried a simple query, it seems work OK, but with the same errors. Is there a way of fixing it and make the connector work properly with Redshift? Thanks.

exception: Exception thrown in database table list update: ??? Unknown error(7) occurred

exception: Exception thrown in database table list update: ??? Unknown error(7) occurred

[philboboADSK · Accepted solution]

We haven't done any testing of the new database features with an Amazon Redshift data warehouse.

The code for the DatabaseConnector is accessible in the tree. For example, MAIN:/project/library/DatabaseConnector>behaviour/cppfunctions/importAll()

That code uses the Database::Connection API (Database.Connection in FlexScript), which is defined in the FlexSim Engine.

If the trouble is in code executed by the DatabaseConnector, such as the queries in MAIN:/project/library/DatabaseConnector>behaviour/cppfunctions/updateInformationSchema(), then you can fix it at a content or module level.

You could also try using the Database.Connection API directly in FlexScript instead of using the Database Connector's import and export features.

[hao_zhou]

Hi Phil, thanks for the reply. I did try to call database connection's APIs in module level. It seems that with the setting "PostgreSQL" I am able to send simple SQL queries and retrieve data without any exceptions. I will do more test in the future.