Common BTEQ Error Messages and Related Directory Setup Problems - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™
Error Message Problem Solution
CLI error: External authentication failed by gateway. LDAP cannot authenticate the user with the information provided in the logon. A common cause of failure is that the LDAP logon contains a Teradata Vantage username and/or password.

Confirm that the directory username and password are entered correctly, and that the account specification, if used, is valid.

If the logon appears to be correct, you can use tdgssauth to identify other possible problems. See Working with tdgssauth.

If you are testing a Kerberos configuration that includes authorization support, see Working with tdsbind.
Gateway error: User, account, or password information is invalid. The user, account, or password is invalid.
DBS error: User identification is not authorized. The Vantage user (tdatUser object) mapped to the directory user does not exist in the database. Do either one of the following:
  • Remap the directory user.
  • Create the user in the database.
DBS error: Profile ‘xxx’ does not exist. The mapped Vantage profile (profile_name) does not exist.
  • The profile may not exist in the database or the directory.
  • The profile may be misnamed in the directory.
  • The logon user may not be mapped to the profile.
Take one of these actions depending on the details of the problem, if the:
  • Profile does not exist, create it in the database.
  • Profile directory object does not exist, create the object it in the directory.
  • Profile directory object is misnamed, rename the profile object in the directory.
  • User is not mapped to the profile, remap the user to the profile.