Publish to Snowflake table fails with "No active warehouse" error.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While attempting to use TDM Portal 4.10.208.0 to publish generated data to a Snowflake table, we are seeing the job fail with the following error:

ERROR: Publish failed for job xxxx, Insert into <TARGET_TABLE> failed: DataAccessResourceFailureException: PreparedStatementCallback; SQL [INSERT INTO "<DATABASE>"."<TARGET_TABLE>" ("XXX","XXX_OBFUSCATED","ROWNUMBER") VALUES (?,?,?)]; No active warehouse selected in the current session.  Select an active warehouse with the 'use warehouse' command.
; nested exception is net.snowflake.client.jdbc.SnowflakeSQLException: No active warehouse selected in the current session.  Select an active warehouse with the 'use warehouse' command.

Environment

TDM Portal 4.10.208.0

Cause

This is a known defect. It was fixed in TDM Portal 4.10.218.0 (released 09/21/2023).

Resolution

Go to the Test Data Manager (TDM) Support Patches page and downloading the latest TDM 4.10 Portal patch, that way you have all the latest fixes and enhancements. 

Please upgrade your TDM Portal to TDM 4.10.218.0 or greater. For steps on upgrading, see "How to apply TDM Patches".