Synchronization of licenses may fail when users belong to more than 50 groups

Synchronization of licenses may fail when users belong to more than 50 groups

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:

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.

Fixed in hotfixes for Spotfire Server:

• 7.10.1 HF-009
• 7.11.1 HF-009
• 7.13 HF-002
• 7.14 HF-001

Link to information about hotfixes for TIBCO Spotfire Server.

A temporary workaround would be to make sure affected users are not members of more than 50 groups.