10:25:30,244 WARN - Connection refused to host: 127.0.0.1 nested exception is: 10:25:29,550 INFO - nSession$CountedThreadExecutor - DbSrcWriter stopped 10:25:24,247 INFO - Process finished with exit code -1 I can't see anything suspect in the logs, apart from the following error on initial connection (fyi I'm connecting to a external server not localhost) - i'm guessing its not related but just incase: With "All Schemas" selected, they are just unchecked:Īnd the schema selector in Connection Properties, they aren't shown at all: Next time I open it, they are unselected: I've also just tried selecting all schemas and they still do not appear. I can only see them in the schema selector accessed by using the inline text on the Database Explorer (not in the connection properties schema selector), and when I select them in the aforementioned schema selector nothing happens and they are unselected when I next open it. Jdbc:redshift://example_cluster123.some_ upgrading to 2019.2 I can't seem to view any Redshift external tables. JDBC-Client-Error: Connecting to 'jdbc:redshift://example_cluster123.some_:5439/dev' as user='awsuser' failed: SSL error: PKIX path validation failed: : validity check failed SolutionĪdd ssl=false to the connection string, for example: (Session: 1622834984232180908) SolutionĮnsure a DNS server is configured for the database. JDBC-Client-Error: Connecting to 'jdbc:redshift://example_cluster123.some_:5439/dev' as user='awsuser' failed: (500150) Error setting/closing connection: UnknownHostException. (Session: 1622834984232180908) SolutionĬheck Security Groups on Redshift side to allow your VM / Cluster to connect to Redshift. JDBC-Client-Error: Connecting to 'jdbc:redshift://example_cluster123.some_:5439/dev' as user='awsuser' failed: (500150) Error setting/closing connection: Connection timed out. (Session: 1622834984232180908) SolutionĮnsure that the settings.cfg file contains NOSECURITY=YES. JDBC-Client-Error: Connecting to 'jdbc:redshift://example_cluster123.some_:5439/dev' as user='awsuser' failed: (500150) Error setting/closing connection: Error loading the keystore. Possible Errors and Solutions Error Message 1 IMPORT supports loading data from a table or a SQL statement. You can use the IMPORT statement to load data using the connection you created above. Import from jdbc at jdbc_connection_1 statement 'select 42' Load Data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |