The following Teradata Schema Workbench message might display for several reasons:
Unable to establish repository connection. Please verify you have permission to access the repository, that it exists, and is the correct version.
The following are possible reasons for the error with suggested solutions:
- The Teradata Schema Workbench user does not have the TBI_WORKBENCH role. You can associate the user with the TBI_WORKBENCH role.
- The Teradata BI Model Repository does not exist. Ensure the repository exists by looking for the BIM_REPOSITORY database on your server. Use an SQL script to list the cubes and schemas in the repository to ensure it responds. See Listing Cube Schemas in the Repository.
- You might have an old version of Teradata Schema Workbench or a version newer than the Teradata BI Model Repository. The Teradata BI Model Repository version number rarely changes. Use the following SQL to see the Teradata BI Model Repository version number:
SELECT * from BIM_REPOSITORY.BIM_InstanceSettings WHERE Setting = 'BIM_REPOSITORY_VERSION'
To narrow the diagnosis using the Windows “Application” event log, see Teradata Schema Workbench Event Logging.