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
We have tried the solution mentioned in the following forum:
i) export NLSPATH=/opt/teradata/client/14.10/tbuild/msg64/opermsgs.cat;
Are you sure that CLI & fastload are both on 14.10?
Is BTEQ starting? Is it showing 14.10?
Fastload version is
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.
Chanchal Preet Singh
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?
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.