SAP Knowledge Base Article - Preview

3538952 - This session does not have a current database. Call 'USE DATABASE', or use a qualified name. - SAP HANA Smart Data Integration

Symptom

Getting the following error message when performing the 'SELECT' statement on a Virtual Table created using a Remote Source - Snowflake:

  • "CamelJdbcAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT"  Exhausted after delivery attempt: 1 caught: net.snowflake.client.jdbc.SnowflakeSQLException: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name. 

However, the JDBC URL has the database name/warehouse name/role parameters.


Read more...

Environment

SAP HANA smart data integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

Snowflake, use database, SDI, smart data integration, warehouse, role , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

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

Search for additional results

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