Hi Sir/Madam,
I have enabled the column encryption option available in the ODBC Data Source Administrator tool (See the option selected in the image below) to meet with the security compliance, later I observed some of the qlik load script tasks were failing, We found that reload task are failing due to column encryption. In the qlik load scripts logs the following 2 errors were found for the failure:
"Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream"
"Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver 13 for SQL Server]Unknown token received from SQL Server"
(The TDS stream protocol error is coming more frequently)
The ODBC Data Source Administrator tool version details are as follows:
- Name- ODBC Driver 13 for SQL Server
- Version- 2015.131.4413.46
When I disabled the column encryption option all task were running successfully without any error. Even the System event logger does not log any error for DSN related issues. My organisation is one of the paying customer of Qlik Sense. Please provide some solution for this issue.
![ColumnEncryption.jpg](/legacyfs/online/197752_ColumnEncryption.jpg)
Thank in Advance.