Problem Note 68857: Indexing links and transactions can fail on Microsoft SQL Server when join key values require validation in SASĀ® Visual Investigator
Full or incremental indexing might fail in SAS Visual Investigator while indexing links and transactions on Microsoft SQL Server when SQL queries have join key values that require validation.
After the indexing fails, an error message that is similar to the following appears in the sas-svi-indexer log:
[wrapped] org.apache.metamodel.jdbc.UncheckedSQLException: java.sql.SQLException: [SAS][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | | Viya | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2022-02-09 13:34:28 |
Date Created: | 2022-01-31 12:06:41 |