Importing Snowflake Metadata In RPD Via Data Gateway In Oracle Analytics Server (OAS) Errors With '[nQSError: 100041] Failed to read data from Java Datasource server.'
(Doc ID 2745883.1)
Last updated on MARCH 31, 2023
Applies to:
Oracle Analytics Server - Version 5.5.0 to 5.5.0 [Release 5]Information in this document applies to any platform.
Symptoms
You are importing Snowflake database metadata via the OAS 5.5 Developer client tool (formerly known as Administration Tool or admintool) and Oracle Data Gateway ( formerly RDG) using the currently available Snowflake JDBC drivers.
- Download, install Oracle Data Gateway 5.5 on the Windows machine where the OAS developer client tool 5.5 is installed.
- Download and copy the latest Snowflake JDBC driver to [install directory]\war\datagateway\WEB-INF\lib folder
- Run data gateway and obtain the port number from the port file.
- Open the developer client tool and an existing RPD in offline mode.
- "Loaded Java Datasources" pointing to localhost and the RDG port number. A success message is received.
- Create a new database in the physical layer and selected "Snowflake" as the database type.
- Create a connection pool
- Call Interface is JDBC (Direct Driver)
- Connection String is jdbc:snowflake://xxxxxx.snowflakecomputing.com?warehouse=XXX&db=XXXX&schema=XXX.
- Driver Class: net.snowflake.client.jdbc.SnowflakeDriver
- Successfully "Import Metadata" and see the new database objects in the physical layer of the RPD.
- During subsequent rounds of "Importing Metadata", the connection fails with the following error message in the user interface (UI).
[nQSError: 100041] Failed to read data from Java Datasource server.
The logs have the following entry:
The issue does not allow you to continue subsequent data model changes and the data model development cycle.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |