KNOWLEDGE BASE

Errors ""Tableau Server cannot complete the operation because the repository is not available." and "could not extract ResultSet" Running tabcmd initialuser


Published: 05 Apr 2018
Last Modified Date: 10 Apr 2018

Issue

When you run tabcmd initaluser, the following error occurs: 
*** ... the repository is not available. Wait a few minutes and then try to publish again. org.hibernate.exception.SQLGrammarException: could not extract ResultSet" 

Environment

  • Tableau Server 10.5.2
  • Red Hat (RHEL) Linux 7
  • LDAP

Resolution

Ensure that the .json file used to import the Identity Store configuration settings is correct and completely updated. For more information, see identityStore Entity.

Cause

Incorrect Identity Store configuration.

Additional Information

The identityStoreSchemaType configuration in the Tableau Server Identity Store configuration templates must be customized to match your specific LDAP configuration. To verify that this is configured correctly and that the user mappings are valid, run:
 
tsm user-identity-store verify-user-mappings -v <the username passed to tabcmd initialuser>

This should return valid values. If any required entries show as "Not found", then the configuration is incorrect.

Did this article resolve the issue?