All Forums Teradata Applications
Govind3331 6 posts Joined 12/15
06 Dec 2015
Terdata BTEQ script ERROR:
####################################
bteq <<EOF
.LOGON servername/username,********
/* sql code on next line(s) */
select  databasename from dbc.databases where databasename="P_EIW_S_LIS_01";
.export reset
.LOGOFF ;
EOF
###################################

Above is the BTEQ Script:
When i am executing the above script i am getting below error:

CLI:Message catalog open failed!: No such file or directory
The file "errmsg.cat" cannot be opened.
There may be problems with your installation.
 *** CLI error: -1 Message Not Found!
 *** Return code from CLI is: -1
 *** Error: Fatal error from CLI.
 ***        Program exiting!

 *** Exiting BTEQ...
 *** RC (return code) = 16

Could any1 plez help me resolving this issue. Thanks in advance.

ulrich 816 posts Joined 09/09
07 Dec 2015

Can you als run a 
 bteq 
with no input from the shell. 
You should see something like
 Teradata BTEQ 15.00.00.03 for Mac OS X. PID: 23275
 Copyright 1984-2015, Teradata Corporation. ALL RIGHTS RESERVED.
 Enter your logon or BTEQ command:

 
If it not starts you have an issue with the BTEQ installation...
 

If it starts: please check you /etc/hosts file
it should contain a entry like
xxx.yyy.zzz.www servernameCOP1
if it is not present this is you issue.
Ulrich
 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Govind3331 6 posts Joined 12/15
08 Dec 2015

Yes exactly Ulrich, the installation was done in the server ,that is d reason it got failed .
Thanks ulrich for ur support in solving this issue

You must sign in to leave a comment.