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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.