Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Database
Enthusiast

Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Hi ,

We are doing the Teradata upgrade and facing  issue in Teradata connectivity Teradata.

New Teradata Version : 14.10

Teradata Previous Version before Upgrade: 13.10

Issue: We are facing following issue while running Fastload using informatica

The file "errmsg.cat" cannot be opened.

There may be problems with your installation.

**** 14:51:22 CLI Error -1:

**** 14:51:22 Fatal error from CLI. Program exiting!

**** 14:51:22 Warning: FastLoad Interrupted

     ===================================================================

     =                                                                 =

     =          Exiting                                                =

     =                                                                 =

     ===================================================================

**** 14:51:22 Total processor time used = '0 Seconds'

     .        Start : Tue Oct 28 14:51:22 2014

     .        End   : Tue Oct 28 14:51:22 2014

     .        Highest return code encountered = '12'.

**** 14:51:22 FDL4818 FastLoad Terminated

Tried solutions:

We have tried the solution mentioned in the following forum:

http://forums.teradata.com/forum/database/error-message-with-tpt-fastload-could-not-find-message-cat...

i)                    export NLSPATH=/opt/teradata/client/14.10/tbuild/msg64/opermsgs.cat;

  1. Also we installed the Teradata ODBC version 15 and still no luck.
4 REPLIES
Supporter

Re: Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Are you sure that CLI & fastload are both on 14.10?

Is BTEQ starting? Is it showing 14.10?

Enthusiast

Re: Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Hi  Ulrich,

Fastload version is 

     ===================================================================

     =                                                                 =

     =          FASTLOAD UTILITY     VERSION 14.10.00.04               =

     =          PLATFORM LINUX                                         =

     =                                                                 =

And bteq version is 


 Teradata BTEQ 14.10.00.03 for LINUX. PID: 3504

 Copyright 1984-2013, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

The cli package installed is  cliv2-14.10.00.07-1



My fastload run successfully if I directly run it from linux server , but face the above issue when I try to call it from Informatica.

Regards

Chanchal Preet Singh

Supporter

Re: Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Hi,

so installation seems to correct. But can't help you any further as I don't have access to Informatica currently.

Is it possible that this is pointing to a old version?

Ulrich

Enthusiast

Re: Errormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10

Not sure if anyone ever saw a fix for this issue, but I encountered the same issue when upgrading TTU 13.10 to 14.00, and 14.10 and 15.00. For me, i was able to use BTEQ from the commanf line only after logging off and back on, as the NLSPATH variable is now setup in the /etc/profile, so I assume this only gets update when you log onto LINUX.