Problem Note 67915: Multiple products report incorrect row counts using the TKTS driver
 |  |  |  |  |
The following TKTS drivers might report incorrect row insert numbers when one or more rows fail to insert:
- Redshift
- Greenplum
- ODBC
- SQLServer
If a warning or error is reported by the driver, the resulting report might indicate that 0 rows were inserted even though that statement might not be true.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install the hot fix, the drivers return an accurate count even if a warning or error occurs.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Amazon Redshift | Linux for x64 | 2020.1.5 | 2021.1.1 | Viya | Viya |
| SAS System | SAS Data Connector to Microsoft SQL Server | Linux for x64 | 2020.1.5 | 2021.1.1 | Viya | Viya |
| SAS System | SAS Data Connector to ODBC | Linux for x64 | 2020.1.5 | 2021.1.1 | Viya | Viya |
| SAS System | SAS Data Connector to Greenplum | Linux for x64 | 2020.1.5 | 2021.1.1 | Viya | Viya |
A fix for this issue for SAS Threaded Kernel Extension for Greenplum 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K3W.html#67915A fix for this issue for SAS Threaded Kernel Extension for Amazon Redshift 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K3Y.html#67915A fix for this issue for SAS Threaded Kernel Extension for ODBC 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K3X.html#67915A fix for this issue for SAS Threaded Kernel Extension for Microsoft SQL Server 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K3Z.html#67915| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-05-19 10:36:59 |
| Date Created: | 2021-05-17 11:31:59 |