Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

IICS Snowflake Connector: "Tasks fails with [ERROR] [SnowFlake_WRITER_INIT_FAILED_915] The Integration Service failed to initialize the write operation because of the following error: Invalid XXXX name provided"
Problem Description
The following error occurs in IICS Snowflake Connector:

"[ERROR] The Integration Service failed to initialize the write operation because of the following error: [SnowFlake_WRITER_INIT_FAILED_915] The Integration Service failed to initialize the write operation because of the following error: Invalid Role name provided", sometimes it is "Invalid Database/schema/Warehouse name provided" 

Even though correct details of Database, Role, Schema, Warehouse are provided in the advanced section of the source/target transformation once you select the Snowflake Cloud Data Warehouse v2 connection and object.
Cause
​This issue can be seen when the task using Snowflake connector when the connection is active but the session is inactive for 4 hours across the snowflake end.

Solution
To resolve this issue, do the following:

1. For Snowflake Cloud Data Warehouse V2 or Snowflake Connector
     1.1 Edit the Connection and set CLIENT_SESSION_KEEP_ALIVE​=TRUE in Additional JDBC URL Parameters.
2. For JDBC_IC
     2.1 Append CLIENT_SESSION_KEEP_ALIVE​=TRUE to the JDBC connection string. 
            Example: jdbc:snowflake://abc123.eu-central-1.snowflakecomputing.com/?user=peter&warehouse=mywh&db=mydb&schema=public&CLIENT_SESSION_KEEP_ALIVE​=TRUE

More Information
​CLIENT_SESSION_KEEP_ALIVE​
TRUE: Snowflake keeps the session active indefinitely as long as the connection is active, even if there is no activity from the user.
FALSE: The user must log in again after four hours of inactivity.
Default: FALSE

Applies To
Product: Cloud Data Integration
Problem Type: Connectivity; Configuration
User Type: Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/2/2020 3:06 AMID:617138
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)