注册 留言板
当前位置:首页 > 企业级应用 > Informatica > 正文

"[ERROR] (Could Not Find Message Catalog )" while running PowerExchange for Teradata Parallel Transporter (TPT) session

来源:INFOCOOL   发布时间: 2017-06-17   作者:网友   浏览次数:
摘要: "[ERROR] (Could Not Find Message Catalog )" while running PowerExchange for Teradata Parallel Transporter (TPT) sessio...
"[ERROR] (Could Not Find Message Catalog )" while running PowerExchange for Teradata Parallel Transporter (TPT) session
Problem Description

A PowerCenter session with a PowerExchange for Teradata PT connection fails with one or more of the following errors in the session log.

A PowerCenter session with a PowerExchange for Teradata PT source (TPT reader):

ERROR TPTRD_21211 [ERROR] Plug-in failed to Initiate Teradata database connection.
ERROR TPTRD_21012 [ERROR] Type:(Teradata PT API Error), Error: (Could Not Find Message Catalog opermsgs.cat)
ERROR TPTRD_21508 [FATAL] Plug-in failed to create connection to Teradata database.
ERROR TPTRD_21501 [ERROR] Plug-in failed to initialize Teradata PT Reader Partition Driver.
ERROR SDKS_38200 Partition-level [SQ_ADDRESS]: Plug-in #315000 failed in init().
INFO TPTRD_22504 [INFO] De-Initialized Teradata PT Reader Partition Driver.

A PowerCenter session with a PowerExchange for Teradata PT target (TPT writer):

ERROR TPTWR_21012 [ERROR] Type:(Teradata PT API Error), Error: (Could Not Find Message Catalog opermsgs.cat)
ERROR TPTWR_21211 [ERROR] Plug-in failed to Initiate Teradata database connection.
ERROR WRT_8068 Writer initialization failed. Writer terminating.

Cause

This issue occurs because of any one of the following:

  • The opermsgs.cat file does not exist on the machine hosting the Integration Service.
  • The NLSPATH environment variable is not set or is set incorrectly.
  • On AIX, the
    LANG environment variable is set to C.
  • This issue can also occur when Teradata ODBC msg file is added at the beginning of the NLSPATH (and before tbuild/msg64 path) as follows:

     

    NLSPATH=/opt/teradata/client/14.00/odbc_64/msg/%N:/opt/teradata/client/14.00/tbuild/msg64::/usr/dt/lib/nls/msg/%L/%N.cat

Teradata Parallel Transporter drivers require the opermsgs.cat file to print the exact error message, but it is not available or environment variable NLSPATH pointing to this file is not set. 

Solution

To resolve the issue, do the following:

  1. Add the opermsgs.cat file to the NLSPATH environment variable.
    Example

    setenv NLSPATH /opt/teradata/client/14.00/tbuild/msg64/%N

  2. AIX ONLY: This error occurs when LANG is set to C.
    Set the LANG environment variable to the required language (For example, us_EN for US English). 

  3. Also, make sure that there is no Teradata ODBC msg file in the NLSPATH as shown:
    NLSPATH=/opt/teradata/client/14.00/tbuild/msg64/%N

  4. Restart the Informatica Services.

Note

By default, the 
opermsgs.cat file is in the  <TPT_HOME>/msg or <TPT_HOME/msg64 (for 64-bit setup) directory.

More Information
The NLSPATH environment variable could also be set in the Integration Service.
For Teradata TTU version 15.10, the following has to be set for NLSPATH:

NLSPATH=/opt/teradata/client/15.10/msg/%N:/opt/teradata/client/15.10/odbc_64/msg/%N
Applies To
Product(s): PowerCenter
Product Version(s): PowerExchange for Teradata PT
Operating System(s): AIX; HP-UX; Redhat Linux; SUSE Linux ES; Solaris

Reference
CR 189751
Last Modified Date:6/16/2017 12:42 AMID:ID:104978
People who viewed this also viewed


我来说两句
评论内容:
验  证  码:
 
(网友评论仅供其表达个人看法,并不表明本站同意其观点或证实其描述。)
评论列表
已有 0 条评论(查看更多评论)
精彩专题
友情链接:
设为首页 - 加入收藏 Copyright @2016 Infocool 版权所有 粤ICP备16000626号