This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board for collaboration on Qlik Replicate.
Replication task is throwing below message but the task is not errored out.If any one have idea please let me know how to correct this?
Error Code: 1022502Error details: Failed to start bulk apply transaction Failed to execute bulk update statement.RetCode: SQL_ERROR SqlState: 25000 NativeError: 11120 Message: [Snowflake][ODBC] (11120) Outstanding transactions during disconnect.RetCode: SQL_ERROR SqlState: 08001 NativeError: 390114 Message: Authentication token has expired. The user must authenticate again.
Hello @Sashidhar ,
In general this message means the snowflake connection expired due to inactivity. By default, the connection lasts 4 hours. From other support ticket I'd like to suggest:
1- Add the below value to the ODBC connection string for the snowflake target endpoint
2- Add following registry keys on the Replication Server
Values are true, 900 and true respectively
3- And did the following to the user
alter user user_name set CLIENT_SESSION_KEEP_ALIVE = TRUE;
alter user user_name set ABORT_DETACHED_QUERY = TRUE;
alter user user_name set CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY = 900;
Some links for your reference:https://docs.snowflake.net/manuals/sql-reference/parameters.html#client-session-keep-alivehttps://docs.snowflake.net/manuals/user-guide/odbc-parameters.html#connection-parameters
Hope this helps.
View solution in original post
Shouldn't Replicate do this setting at each session level through the ODBC driver?
Recently I have noticed the same issue in Qlik Compose too.
Previously we were told to set: