SAP Knowledge Base Article - Preview

2966246 - Unable to create a universe or Web Intelligence document based on the Snowflake database

Symptom

  • Various problems creating a universe or Web Intelligence document based on the Snowflake database

  • The problems appear for both JDBC and ODBC relational connections

  • For JDBC connections, creating a Web Intelligence document and refreshing it or creating a new universe connection in Information Design Tool and testing it returns errors. Looking in the logs, the following error appears: 

            EXCEPTION [JDBC|Snowflake|ID:1340434329]com.sap.connectivity.cs.java.OpenJob{com.businessobjects.connectionserver.Job}.Execute: [com.sap.connectivity.cs.java.drivers.DBDError:

            JDBC driver internal error: Max retry reached for the download of #chunk0 (Total chunks: 9) retry=10, error=net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Error encountered when downloading a result chunk: HTTP status=403.

  • For ODBC connections, in Information Design Tool, creating a universe connection tests ok, however when creating a Data Foundation, no tables appear when expanding the database list. Tracing the workflow shows a general error: 

            java.lang.RuntimeException: com.sap.connectivity.cs.remoting.DBDError: [Snowflake][Snowflake] (25) 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.2
  • Support Pack 08
  • Web Intelligence
  • Information Design Tool

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BI42 BI 4.2 BI4.2 Web Intelligence webintelligence webi information design tool IDT snowflake database db odbc jdbc error problems create linux windows , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.