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
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.