How to resolve the error "Failed to translate the username into domain\user format"?

How to resolve the error "Failed to translate the username into domain\user format"?

book

Article ID: KB0072757

calendar_today

Updated On:

Products

Statistica

Description

This article describes how to resolve the following error -
-------------------------------------------------------
Statistica Data Function failed: SpotfireSPCCharts
An error occurred in Statistica: 0x8007054B Failed to translate the username abc@SPOTFIRE into domain\user format
-------------------------------------------------------



 

Issue/Introduction

How to resolve the error "Failed to translate the username into domain\user format"?

Environment

Windows Only

Resolution

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 : config.bat export-service-config --config-name=[Configname] --tool-password=[Bootstrap_Password] or alternatively run : config.bat export-service-config --capability=STATISTICA --deployment-area=[Deployment area] --tool-password=[Bootstrap_Password]
4.Navigate to : C:\tibco\tss\10.10.0\tomcat\spotfire-bin\config\root\conf on the Spotfire Server. This should have the statistica.properties and custom.properties file used by the Statistica service.
5. Ensure that the below properties are set :
---------------------------------------------
statistica.enterprise: TRUE
statistica.enterprise.user: admin
statistica.enterprise.password: ******
statistica.enterprise.server:DSN=[Name of DSN that connects to Statistica Enterprise meta database];UID=[dbuser];PWD=[dbpwd]
(or)
statistica.enterprise.server: DRIVER=SQL Server;SERVER=dbserver;DATABASE=databasename;UID=dbusername;PWD=dbpassword

statistica.enterprise.spotfiredomain: SPOTFIRE
statistica. enterprise.prohibitedusermappings: admin;system
---------------------------------------------

User-added image
 
NOTE: 
​​​​​​1. "spotfiredomain" - Spotfire checks for local Spotfire user accounts. The Spotfire domain should be "SPOTIFRE". In case there is a different domain name as per the machine. Kindly change it to "SPOTFIRE" as it looks for the Spotfire domain, not the local machine domain.
2. "Prohibitedusermappings" - will prohibit these user names from being mapped from Spotfire local user accounts to enterprise local user accounts; e.g., SPOTFIRE\admin should not be automatically mapped to Enterprise admin users. Defaults to admin; system if not provided. 

Additional Information

How-to-resolve-Statistica-Data-function-failed-The-object-appears-to-be-an-Enterprise-object-but-Enterprise-is-not-available