Hi All,
I'm using Teradata connector stage to extract the data..i am using Bulk option. My job is running fine in DEV and SIT environments,,But job has failed in PROD environement... i am getting below error in Production.
[IIS-CONN-TERA-005004] RDBMS code 21012: Could Not Find Message Catalog opermsgs.cat SQL statement: SELECT CNCT_NUMB,CO_IDNN,REGN_IDNN,BRCH_IDNN,PDCT_IDNN,ACCG_DATE,PAYT_NUMB,NET_AMT,INT_EARN,DFLT_INT,INCM_FROM_PAYO,OTHR_INCM_CNCT (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1,248)
Could you please tell me why it is failing in Prodenvironment?
Teradata connector issue in Production
Moderators: chulett, rschirm, roy
Teradata connector issue in Production
vijayakumargoud
*drops 2 cents into the pot*
A) confirm with your Teradata DBA which version of TD is installed in PROD. The release levels could be different than your DEV and SIT environments.
B) Confirm with your Teradata DBAs the release level (and which compilers were used) your client TD tools. The BULK options will only work if your Client tools were compiled to a given release level. In our shop, the TD DBAs are the ones to package the TD tools and deploy them.
C) see if your SQL works outside of DataStage (Teradata supplied tools like Queryman) against your PROD environment.
A) confirm with your Teradata DBA which version of TD is installed in PROD. The release levels could be different than your DEV and SIT environments.
B) Confirm with your Teradata DBAs the release level (and which compilers were used) your client TD tools. The BULK options will only work if your Client tools were compiled to a given release level. In our shop, the TD DBAs are the ones to package the TD tools and deploy them.
C) see if your SQL works outside of DataStage (Teradata supplied tools like Queryman) against your PROD environment.