bteq batch mode error.help me pls!

Tools & Utilities
Teradata Employee

bteq batch mode error.help me pls!

when I run my perl script, the error always occur . the message as follow:

.LOGON TU_CBIC,
*** CLI error: MTDP: EM_ERRFAILPCLGSSRSP(242): error or failure gss/sso rsp.

*** Return code from CLI is: 242
*** Error: Logon failed!

*** Total elapsed time was 45 seconds.

---------------------------------------
when I run again, the message change to :

.LOGON TU_CBIC,
*** Error 3004 User identification is not authorized.
*** Error: Logon failed!

*** Total elapsed time was one minute and 6 seconds.

How can I fix it?
pls help me!
1 REPLY
Teradata Employee

Re: bteq batch mode error.help me pls!

OK I got the answer from forum user "Fred Pluebell":

"A likely explanation: The same TDPID, but with more COPs, is defined to point to a different Teradata system (in your hosts file or nameserver/DNS). That's easy enough to check: "ping TDPIDcop2" (or one number higher than the highest "cop" you defined).

CLIv2 will enumerate and attempt to resolve the "cop" suffix names in sequence until it gets a failure, then randomly pick one from the list to use as the starting point. If "cop1" points to system A but cop2 through copN point to system B, that could explain the behavior you observe.
"

cited from his article.