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

When performing the 'SELECT' statement on a Virtual Table created using a Remote Source - Snowflake, the following error message is displayed.

2025-01-16 15:51:24,579 [ERROR] [9874677a-033b-4140-98da-7785ad0d294e53287] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(441): com.sap.hana.dp.adapter.sdk.AdapterException: Camel execution failed. Reason: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name. Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[033CF82D33664DF-0000000000000000]
                                at org.apache.camel.CamelExecutionException.wrapCamelExecutionException(CamelExecutionException.java:45)
                                at org.apache.camel.support.ExchangeHelper.extractResultBody(ExchangeHelper.java:687)
                                at org.apache.camel.impl.engine.DefaultProducerTemplate.extractResultBody(DefaultProducerTemplate.java:591)
                                at org.apache.camel.impl.engine.DefaultProducerTemplate.lambda$asyncRequestBody$2(DefaultProducerTempla...
2025-01-16 15:52:00,345 [ERROR] [f0687e8e-1c26-459e-b877-aaf5acfae71555466] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: 0F0406C85F45A0A-0000000000000000 on ExchangeId: 0F0406C85F45A0A-0000000000000000). 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.
                                Message History (complete message history is disabled)


Read more...

Environment

  • SAP HANA smart data integration 2.0
  • Snowflake Remote Source

Product

SAP HANA smart data integration 2.0

Keywords

Snowflake, use database, SDI, smart data integration, warehouse, role, remote source, , 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.