After Spotfire server upgrade, when Spotfire Administrator user log on to Spotfire server URL can only see "Home" and "Analytics" options and no other options are visible.

After Spotfire server upgrade, when Spotfire Administrator user log on to Spotfire server URL can only see "Home" and "Analytics" options and no other options are visible.

book

Article ID: KB0080015

calendar_today

Updated On:

Products Versions
Spotfire Server 7.5 and higher

Description

If you check Spotfire server logs, you can see below type of errors in server.log file:
----------- 
ERROR 2018-09-26T07:29:04,380+0200 [sfadmin, #48, #274] server.security.RoleManagerImpl: Internal error when looking up administrator privileges for user 'sfadmin[2689a4a5-61a2-402b-a928-e8cb4ac6804e]' in the UserDirectory
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'GROUP_MEMBERS_VIEW'.
------------

------------ 
WARN 2018-09-26T08:54:25,567+0200 [monitoring@SPOTFIRESYSTEM, #54, #144] ws.userdir.UserDirectoryService: An exception was thrown in method 'getGroupsRecursive'.
com.spotfire.server.userdir.DirectoryException: Failed to load group membership associations from database
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'GROUP_MEMBERS_VIEW'.
------------- 

------------- 
ERROR 2018-09-26T09:16:21,188+0200 [sfadmin, #57, #2237] server.security.RoleManagerImpl: Internal error when looking up administrator privileges for user 'sfadmin[2689a4a5-61a2-402b-a928-e8cb4ac6804e]' in the UserDirectory
com.spotfire.server.userdir.DirectoryException: Failed to load group membership associations from database
    at com.spotfire.server.userdir.MSSQLDatabaseProvider.getParentGroupsRecursive(MSSQLDatabaseProvider.java:203) ~[server.jar:?]
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'GROUP_MEMBERS_VIEW'.
------------- 

These errors indicates that there is some issue with group membership in Spotfire Database which may be causing this issue.

Issue/Introduction

After Spotfire server upgrade, when Spotfire Administrator user log on to Spotfire server URL can only see "Home" and "Analytics" options and no other options are visible.

Resolution

Points to check to resolve this issue:

1. Check the user permissions on Spotfire Database by which you ran Spotfire server upgrade tool. Check if this user has proper permissions(For example: CREATE SESSION,CREATE TABLE, CREATE PROCEDURE, CREATE VIEW, QUERY REWRITE) on Database views for which you are getting errors in logs.

2. Check if your Spotfire database equipped with integrated security. If yes, make sure that you checked this integrated security option while running Spotfire server upgrade tool.

3. Check if Database views for which you are getting above errors in logs, are get created properly in Spotfire Database. If not, you may need to create these Database views under Spotfire Database user again with the help of your DBA.