TPT API Error while using with INFA

Tools & Utilities
Teradata Employee

TPT API Error while using with INFA

Hi Folks,

Please help me to understand the below  TPT API Error, while using the TPT Stream connection with Informatica Tool as same job works fine with the ODBC connection to the same database and table.

Environment Details:

Informatica version: 9.5.1

Teradata Database version: 14.00

TTU Version: 13.10

Error Details:

[ERROR] Type:(Teradata PT API Error), Error: (libstreamop.so) instance(1): INITIATE method failed with status = Fatal Error)

[ERROR] Plug-in failed to Initiate Teradata database connection.

Please find below the table definition for reference:

CREATE MULTISET TABLE XXXX.XXXXXX ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      TRAN_DATE TIMESTAMP(0) NOT NULL,

      TRAN_TIME VARCHAR(6) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      SERN VARCHAR(8) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      DBIT_ACCT_NUMB VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      CRDT_ACCT_NUMB VARCHAR(19) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      MONTH_KEY VARCHAR(6) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      PERIOD_ID VARCHAR(8) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      BRCH_CODE VARCHAR(6) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      TELL_ID VARCHAR(8) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      SYST_PDCT_TYPE VARCHAR(2) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      TRAN_TYPE VARCHAR(2) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      CASH_AMT DECIMAL(15,2) NOT NULL,

      TRAN_AMT DECIMAL(15,2) NOT NULL,

      TRAN_INDC VARCHAR(1) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      TRAN_CODE VARCHAR(3) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      ITEM_COUNT DECIMAL(7,0) NOT NULL,

      CLER_CHEQ_INDC VARCHAR(1) CHARACTER SET LATIN CASESPECIFIC,

      ACTL_CASH_AMT DECIMAL(15,2),

      TRNF_AMT DECIMAL(15,2))

PRIMARY INDEX ( SERN ,DBIT_ACCT_NUMB ,CRDT_ACCT_NUMB )

PARTITION BY RANGE_N(MONTH_KEY (DATE, FORMAT 'yyyymm') BETWEEN DATE '2014-05-01' AND DATE '2015-08-31' EACH INTERVAL '1' MONTH )

UNIQUE INDEX ( TRAN_DATE ,TRAN_TIME ,SERN ,DBIT_ACCT_NUMB ,CRDT_ACCT_NUMB ,

MONTH_KEY ,PERIOD_ID );

Please let me know if any more details are required to analyze the error. Thanks.

Tags (1)
1 REPLY
Teradata Employee

Re: TPT API Error while using with INFA

We would need more information for this error:

[ERROR] Plug-in failed to Initiate Teradata database connection.

Since TPTAPI uses CLIv2, if there was an issue in the connection there should ba a CLIv2 error somewhere. You may have to contact Informatica to find out how to get that additional information.

-- SteveF