Redshift Database Connection Issue

Question

question

Hao Zhou asked Apr 16, '19 Hao Zhou commented Apr 17, '19

Redshift Database Connection Issue

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

Software Version:

FlexSim 19.0.2

database connection

Answer 1 · 2019-04-17T15:43:59Z

Phil BoBo answered Apr 17, '19 Hao Zhou commented Apr 17, '19

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.

· 1

Hao Zhou commented · Apr 17, 2019 at 08:55 PM

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.

0 ·

question

Redshift Database Connection Issue

1 Answer

Write an Answer

Things to know…

question details