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

book

Article ID: KB0080545

calendar_today

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: 

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.

Environment

Spotfire Server with SQL Server database, versions 7.10, 7.11, 7.13, 7.14

Resolution

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.

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.
Powered by Wolken Software