TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

Tools & Utilities

TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

Hello Everyone,

I'm loading a Teradata table from an Oracle table using TPT utility.

I am facing below error while running the script:

Teradata Parallel Transporter Version 13.10.00.02

Job log: /opt/teradata/client/13.10/tbuild/logs/abadap1a-254.out

Job id is abadap1a-254, running on cash070f

Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/abadap1aLVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter ODBC Operator Version 13.10.00.02

ODBC_Operator: private log not specified

Teradata Parallel Transporter Load Operator Version 13.10.00.03

LOAD_OPERATOR: private log specified: Test_POC

ODBC_Operator: connecting sessions

LOAD_OPERATOR: connecting sessions

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

LOAD_OPERATOR: disconnecting sessions

LOAD_OPERATOR: Total processor time used = '0.314103 Second(s)'

LOAD_OPERATOR: Start : Tue Sep 10 11:03:19 2013

LOAD_OPERATOR: End : Tue Sep 10 11:04:17 2013

Job step MAIN_STEP terminated (status 8)

Job abadap1a terminated (status 8)

I have gone through the previous posts related to this error and understood that this might be because of not having latest TPT patches installed. But if we look at the log then for LOAD OPERATOR its showing latest version and for ODBC OPERATOR its showing old version. I am not sure why is this happening. Can anyone please suggest me the solution for getting rid of this error.

Thanks,

Swapnali S.

8 REPLIES 8
Teradata Employee

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

Please download the latest patches for all components of TPT and try again.

There are separate packages for the Big-4 (Load, Update, Export, Stream) operators and the TPT infrastructure (the ODBC operator is part of the infrastructure package).

-- SteveF
Teradata Employee

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

And the efix numbers do not have to match between the different packages.

-- SteveF
Enthusiast

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

I have the last version for TPT, Can you help me with, with this error

Teradata Parallel Transporter Load Operator Version 14.00.00.09

LOAD_OPERATOR: private log specified: loadoper_privatelog-1

Teradata Parallel Transporter ODBC Operator Version 14.00.00.09

ODBC_Operator: private log specified: ODBC_OPERATOR

ODBC_Operator: connecting sessions

LOAD_OPERATOR: connecting sessions

TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: TPT10508: RDBMS error 2634: Existing ERROR table(s) or Incorrect use of TABCAERR in  Fast Load operation.

LOAD_OPERATOR: disconnecting sessions

LOAD_OPERATOR: Total processor time used = '0.2 Second(s)'

LOAD_OPERATOR: Start : Thu Dec  5 16:22:55 2013

LOAD_OPERATOR: End   : Thu Dec  5 16:22:58 2013

Job step MAIN_STEP terminated (status 8)

Job root terminated (status 8)

 Job root terminated (status 12)

Fan

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

same error...help please

Teradata Employee

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

If "same" means Signal 11, that could be due to mixing 32-bit libraries with 64-bit application or vice versa. It could also be a bug.

Be sure you have PATH, etc. is correct in your environment; consider upgrading to the latest patch levels.

Teradata Employee

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

Jose1: what version of TPT are you using? Always download the latest and greatest patch for that version, and if the problem still exists, then post. And please provide as much information as possible (including the console output so that we can easily see what version you are running).

-- SteveF
Enthusiast

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the re

We are facing "signal number 7" during tpt-load. It happened without obvious pattern (three different data feeds failed on different files). We are using 15.10.xx TTU(TPT) tools/client against 16.20.xx database. I know we should update anyway(and we will).

 

After some checking and try-fail-retry differently test loads, we found ...maybe it help others when facing this issue on their systems.

  • client side is ended and server is still reporting (in viewpoint) that session(s) are active 
  • as we run it from crontab, even if tbuild failed envelope script and cron/crond/"sh -c"  process were still waiting for any return code from "tpt". 
  • later we reached max session count limit for tpt and any other instance was put to delay queue (to just confuse us a bit more :) 
  • after we kill-all processed related to zombified loads, there were several files "SELECT_1" or/and "APPLY_1" files in "td-logs" directory
  •  What is strange. Same dataset fails first time, after cleared rerun finished fine.

There was no major update/upgrade related to Teradata, OS, loading framework. Just technical patches on server side. Base tables for loading are same for year, tpt scripts are same and are generated ad-hoc/on-fly. Nobody from our team faced this kind of error_message so far. For sure, we will update client side ASAP. Hope that will fix this (i assume yes, as TD16.20 doku has 01036 message listed for each "receipt signal" and in my local pdfs for td13/14/15 this error is not listed.)

btw: is there list of "receipt signal numbers" and meaning of each number ?

 

Highlighted
Teradata Employee

Re: TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the re

As the message says, TPT received the signal from the OS, so you would need to check the OS documentation for an explanation.

Signal 7 is a bit unusual; one possibility could be a problem with memory-mapped I/O for inter-process communication (e.g. underlying filesystem is full).

 

When you upgrade, make sure values for shared memory and semaphore kernel parameters meet the recommendations in the installation guide for your TTU release and platform.