SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 68857: Indexing links and transactions can fail on Microsoft SQL Server when join key values require validation in SAS® Visual Investigator

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual InvestigatorLinux for x6410.7Viya
* 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.