Synchronization of licenses may fail when users belong to more than 50 groups
Article ID: KB0080545
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.10, 7.11, 7.13, 714 |
Description
Users belonging to more than 50 users might be unable to use Spotfire.
In the server log, an exception similar to the one below can be found:
When using Data Direct driver:
When using native SQL Server driver:
In the server log, an exception similar to the one below can be found:
An exception occurred in method 'getLicenses'.
com.spotfire.server.license.LicenseException: Database error
at com.spotfire.server.license.LicenseManagerMSSQL.toException(LicenseManagerMSSQL.java:431) ~[server.jar:?]
at com.spotfire.server.license.LicenseManagerMSSQL.getLicensesCore(LicenseManagerMSSQL.java:311) ~[server.jar:?]
at com.spotfire.server.license.LicenseManager.getLicenses(LicenseManager.java:191) ~[server.jar:?]
...
...
When using Data Direct driver:
Caused by: java.sql.SQLException: [tibcosoftwareinc][SQLServer JDBC Driver]Invalid parameter binding(s).
When using native SQL Server driver:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 2 is out of range.
Issue/Introduction
Due to a defect in certain versions of Spotfire, synchronization of licenses fails for users belonging to more than 50 groups when using MS SQL Server as the Spotfire server database. Fixed in hotfix.
Environment
Spotfire Server with SQL Server database, versions 7.10, 7.11, 7.13, 7.14
Resolution
Fixed in hotfixes for Spotfire Server:
A temporary workaround would be to make sure affected users are not members of more than 50 groups.
- 7.10.1 HF-009
- 7.11.1 HF-009
- 7.13 HF-002
- 7.14 HF-001
A temporary workaround would be to make sure affected users are not members of more than 50 groups.
Feedback
Yes
No
Powered by
