Products | Versions |
---|---|
Spotfire Analyst | All supported versions |
Information links created using snowflake JDBC connection may throw the following error while trying to open them in Spotfire.
===============
InformationModelServiceException at Spotfire.Dxp.Services:
Failed to execute query: No active warehouse selected in the current session. Select an active warehouse with the 'USE WAREHOUSE' command.
===============
To resolve this error, specify the required warehouse in the 'Open Session Commands' with in Datasource Edit screen.
====================================
USE WAREHOUSE <warehouse_identifier>
====================================
Here, the warehouse_identifier value is the name of the warehouse.
Example: USE WAREHOUSE mywarehouse
This command specifies the current warehouse for the current user session.
A warehouse must be specified for a session and the warehouse must be running before DML statements and queries can be executed in the session.
If the data source is already created without specifying this value, the following steps should be performed.
=> Select the data source from Information Designer
=> Right click and select "Edit"
=> Enter the value in "open session commands" field in the format mentioned above
=> Save the data source