using TDCH cannot connect to Teradata database: username and password invalid

Connectivity

using TDCH cannot connect to Teradata database: username and password invalid

Hi all, 

  i am encuntering the following error when trying to use TDCH to load data to Teradata. 

16/01/08 00:32:04 INFO tool.ConnectorExportTool: com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

I am sure that my acc name and password is correct, as in i can connect through Teradata Studio. 

I am not sure whether this is becuase that my account is a LDAP account, is there anyway to speficy the authentication in the configuration settings?

my command is: 

hadoop com.teradata.hadoop.tool.TeradataExportTool \

-libjars $LIB_JARS \

-Dmapreduce.job.queuename=ingest \

-url jdbc:teradata://tsteraprod09/database=labs__test,chatter=off \

-username ****** \

-password  ********* \

-jobtype hive \

-fileformat textfile \

-method internal.fastload \

-sourcetable test_fsy.probe \

-nummappers 2 \

-targettable test_fsy

Pls suggest! 

Thank you very much! 

best regards, 

SY

Tags (2)
1 REPLY
Teradata Employee

Re: using TDCH cannot connect to Teradata database: username and password invalid

SY,

I work on the TDCH development team and want to look into your issue a little further.  Would it be possible for you to provide the full error stack that you are seeing so I can better figure out where in the process the exception is occuring.

Best regards,

Sean Dorval