Teradata TPT 14.10.00.05 with SAP Data services 4.2

Tools & Utilities

Teradata TPT 14.10.00.05 with SAP Data services 4.2

Hello Folks, I see this issue with TPT 14.10.00.05 on the 13.10.04.04 TD database running with a BODS 4.2 version. 

I recently upgraded ALL the TTUs to 14.10 as we are upgrading the DB to 14.10. DB upgrade not done yet. So, I am using 14.10 TTUs on a 13.10 database. After I upgraded my tools on the SAP data services server. I found the below issue: I am not too much worried about the warnings, But the Job failes with the message " Named pipe error occurred: <The system cannot find the file specified"

(14.2) 04-14-15 22:43:54 (W) (3908:0176) DBS-120828: |Data flow DF_OM_CHD_CH011_MST1|Loader Query_PS_OM_CHD_CH011

                                                     Teradata returned with the following warning: <file_opt: TPT19003 NotifyMethod: 'None (default)'
file_opt: TPT19003 NotifyMethod: 'None (default)'
file_opt: TPT19003 ECI operator ID: 'file_opt-1964'
file_opt: TPT19003 ECI operator ID: 'file_opt-640'
Job start: Tue Apr 14 22:43:18 2015
Job end: Tue Apr 14 22:43:47 2015
>
(14.2) 04-14-15 22:48:10 (W) (3424:4048) DBS-120828: |Data flow DF_OM_CHD_011_MST2|Loader Query_PS_OM_CHD_CH011
Teradata returned with the following warning: <file_opt: TPT19003 NotifyMethod: 'None (default)'
file_opt: TPT19003 NotifyMethod: 'None (default)'
file_opt: TPT19003 ECI operator ID: 'file_opt-2828'
file_opt: TPT19003 ECI operator ID: 'file_opt-1968'
Job start: Tue Apr 14 22:44:07 2015
Job end: Tue Apr 14 22:48:03 2015
>
(14.2) 04-14-15 22:48:42 (E) (3436:3952) FIL-080134: |Data flow DF_OM_CHD_011_MST3|Loader Query_PS_OM_CHD_CH011
Named pipe error occurred: <The system cannot find the file specified.
>
(14.2) 04-14-15 22:48:43 (E) (3436:3640) FIL-080134: |Data flow DF_OM_CHD_011_MST3|Loader Loader1 for table 'Query_PS_OM_CHD_CH011'
Named pipe error occurred: <The system cannot find the file specified.
>
(14.2) 04-14-15 22:48:43 (E) (3436:3640) DBS-120804: |Data flow DF_OM_CHD_011_MST3|Loader Loader1 for table 'Query_PS_OM_CHD_CH011'
Cannot find log file that matches <*out>.
(14.2) 04-14-15 22:48:43 (E) (3436:3640) DBS-120804: |Data flow DF_OM_CHD_011_MST3|Loader Loader1 for table 'Query_PS_OM_CHD_CH011'
Cannot find log file that matches <*job>.
(14.2) 04-14-15 22:48:43 (3436:3952) CON-120828: (14.2) 04-14-15 22:48:43 (3436:3952) CON-120805: (14.2) 04-14-15 22:48:43 (3436:3952) CON-120805: |Data flow DF_OM_CHD_011_MST3|Loader Query_PS_OM_CHD_CH011
(14.2) 04-14-15 22:49:06 (E) (2228:2428) RUN-050316: |Session JOB_STG_OM_CHD_CH011
Error in JOB_STG_OM_CHD_CH011
(14.2) 04-14-15 22:49:06 (E) (2228:2428) RUN-050304: |Session JOB_STG_OM_CHD_CH011
Function call <raise_exception ( Error in JOB_STG_OM_CHD_CH011 ) > failed, due to error <50316>: <Error in
JOB_STG_OM_CHD_CH011>.
(14.2) 04-14-15 22:49:06 (E) (2228:2428) RUN-050316: |Session JOB_STG_OM_CHD_CH011
Error in JOB_STG_OM_CHD_CH011

2 REPLIES
Teradata Employee

Re: Teradata TPT 14.10.00.05 with SAP Data services 4.2

I've run into this issue quite often with BODI4.1 and 4.2... with TD14 and 15.  I've had several incidens open with BO support and they say that it's not an issue on their end and they want to say it's a problem on the TD dBase. 

Have you found a solution for this issue?

Thanks,

Terance

Re: Teradata TPT 14.10.00.05 with SAP Data services 4.2

One of my ETL developers had to change the TPT options to "generic named pipe" to resolve this issue. The job ran with no issues(execpt warning). No change in the perofrmance or the run times have been noticied. I believe this should be a work around for now. good luck!