Spotfire Server: Promoting a user to Spotfire Administrator role returns an error "Could not promote administrator"

Promoting a user to Spotfire Administrator returns error "Could not promote administrator".

This article provides a resolution for the error, "Could not promote administrator" which may occur while promoting a user to a Spotfire Administrator.

Symptoms:

The following error appears while promoting a user to a Spotfire Administrator in the Configuration tool:

Could not promote administrator
admin[abd90f78-e0a9-4fdc-b88c-b9b82b3a01c3]

For example:

The following error is logged in the server.log file under the Spotfire server logs:

com.spotfire.server.ServerInitializationException: TIBCO Spotfire Server will not be started. Database consistency verification failed. Errors found:
 Incorrect number of views. Expected 1 but was 0
 Missing views: UTC_TIME

The error, which is logged in the server.log file under the Spotfire server logs, indicates that UTC_TIME is missing in the Spotfire Database. This is most likely caused by a permission issue with the Spotfire Database user. The Spotfire Database user you specify needs to have “Create view” privilege. To fix this issue you need to manually create this view:

- Login to the Database with a user that has permissions to grant necessary privileges to the Spotfire Database user.
- Once logged in, run the command "GRANT CREATE VIEW TO <DATABASE USER>".
- Once the privilege has been granted to the Spotfire DB user you then need to login as the Spotfire Database user and create the view.

NOTE: You may need a DBA to grant necessary privileges to the Spotfire Database user.