All Forums Connectivity
fengshaoyu 1 post Joined 01/16
07 Jan 2016
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.ConnectorExcep tion: java.sql.SQLException: [Teradata Database] [TeraJDBC] [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, 


smdorval 1 post Joined 06/15
13 Jan 2016

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

You must sign in to leave a comment.