TDLOAD Error 8017: The UserId, Password or Account is invalid.

Connectivity

TDLOAD Error 8017: The UserId, Password or Account is invalid.

I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.

Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt

Below are the contents of my "tdloadjobvars.txt" file.

TargetLogonMech='ldap',
TargetLogonMechData='authcid=xxxx password=xxxx',
TargetTdpId='idwprd',
TargetWorkingDatabase = 'xxxx',
TargetUserName='xxxx',
TargetUserPassword='xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5

I am getting the following error message.

Teradata Load Utility Version 13.00.00.12
Got RDBMS Error 8017: The UserId, Password or Account is invalid.

I can logon using BTEQ and FASTLOAD utility.

Can anyone help?

2 REPLIES
N/A

Re: TDLOAD Error 8017: The UserId, Password or Account is invalid.

The same as you. I need help too.

Re: TDLOAD Error 8017: The UserId, Password or Account is invalid.

Seems like "tdload" does not support any kind of target "LogonMech" other than the default td2. Hence your ldap database access can't be used.

IE Only a full tpt script will allow ldap authentication.