Problem Note 69781: SQL server queries might fail when there are more than 2100 parameters in SAS® Visual Investigator
 |  |  |  |  |
When you use the Investigation user interface, it can result in database queries having a large number of parameters. If your database is Microsoft SQL Server and the number of database parameters is greater than 2,100, the query might fail.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#69781An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#69781| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-01-26 12:55:46 |
| Date Created: | 2022-12-19 17:07:07 |