Support encryption key size 256
Closed this issue · 4 comments
After we have updated CLIENT_ENCRYPTION_KEY_SIZE to 256 (from 128 default) users were not able to decrypt data from stage when using Excelerator. All other tools work well. According to documentation change could have affected only JDBC drivers, not ODBC.
the actual error message from SF logs is: "Failed to decrypt. Check file key and master key."
Excelerator can still connect and read data, but not write/update.
Could you please look at that? I tried searching through the VBA but could not find anything which would help.
Thank you
Miro
Miro,
Do the other tools that work use the ODBC driver?
Can you test with the ODBC driver another way?
Steve
Miro,
I was told that you should open a support case for this. While the Excelerator is not a Snowflake supported product, the ODBC driver is. So make sure you open it for that.
Please let me know the case number and I'll follow it and answer any questions as needed.
Steve
@miro-licek Did you open a support ticket and was it resolved?
Thanks.
Thx for following up. It was connected with encryption key size . When we extended it to 256 it affected loading into stage with ODBC which it shouldn't. We are following up with SF support. You can close this issue on your side. Thx