How to resolve "User x is prohibited by the statistica.enterprise.prohibittedusermappings setting" ?

How to resolve "User x is prohibited by the statistica.enterprise.prohibittedusermappings setting" ?

book

Article ID: KB0073278

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.6,14.0
Spotfire Server 10.3 through 10.10

Description

How to resolve " Statistica Data Function failed: [data function name]
An error occurred processing the request: java.lang.Exception: User [username] is prohibited by the statistica.enterprise.prohibitedusermappings setting"?

User-added image

 

Issue/Introduction

How to resolve "Statistica Data Function failed: User x is prohibited by the statistica.enterprise.prohibittedusermappings setting" ?

Resolution


On Spotfire Node manager, navigate to : [Spotfire Node manager installation directory]\nm\services\Statistica Service-[Version]-[id]\conf\ directory and open statistica.properties file

Check if property "statistica.enterprise.spotfiredomain:" is enabled and has been set up with the right domain. If it is,check property "statistica.enterprise.prohibitedusermappings:" is enabled. Remove # on the property : "statistica.enterprise.prohibitedusermappings:" and remove the user that is being prohibited

User-added image

Save the file and restart the Statistica service as detailed in : https://support.tibco.com/s/article/How-to-restart-the-Statistica-service-in-Spotfire-Adminstrator-Console

If the error is still observed,configure the service to use the statistica.properties file that was saved as follows :

 
1. Remote into Spotfire Server. Open a command prompt (preferably as an Administrator).
2. Navigate to C:\tibco\tss\[Spotfire Server Version]\tomcat\spotfire-bin directory.
3. Run the command : config.bat import-service-config --config-name=[name] --tool-password=xxx