Good morning Gentlemen,
I am facing a weird issue while doing a TPT export on linux . I am facing this issue when I am trying to export more than 4million records(not sure of the row size) .
The same code ran fine for fewer records (apprx ~ 3 mil) .
I verified the DBQL logs for this session and found that there are no error codes related to it (this being an export job is there nothing to be err'ed out ?.)
My tpt file is below :
Any ideas or suggestions to resolve this ?.
Just an update to the above issue . I ran it with a different user on the same server and job ran fine . I am thinking this is a unix related issue .
Any Ideas on what I should check for this user ?
Yes, a dude named Bob from Texas solved the issue for us :)
Just to update the forum with the solution that worked in our case .
The problem is with the tpt binaries that are running this job . Our current environment is on 32bit libraries which is throwing this core dump issue for this export .
Switching the libraries to 64 bit helped resolve the issue .
Steps to update the path:
We are facing the same issue. Below is the error details:
Teradata Parallel Transporter Version 14.10.00.10 Job log: /opt/teradata/client/14.10/tbuild/logs/EVEREST_LEG
ACY_CONTRACT_ATTRIBU-213.out Job id is EVEREST_LEGACY_CONTRACT_ATTRIBU-213, running on ebdp-ch2-e047p.sys.comcast.net Teradata Parallel Transporter Export Operator Version 14.10.00.10 o_ExportOper: private log specified: Export Teradata Parallel Transporter DataConnector Operator Version 14.10.00.10 o_FileWritter: Instance 1 directing private log report to 'DataConnector-1'. o_FileWritter: DataConnector Consumer operator Instances: 1 o_FileWritter: ECI operator ID: 'o_FileWritter-5401' o_FileWritter: Operator instance 1 processing file '/home/edpintevrp/ExtractFramework/TgtFile/FullExt ract/LEGACY_CONTRACT_ATTRIBU.txt'. o_ExportOper: connecting sessions o_ExportOper: sending SELECT request Unexpected error. TPT_INFRA: TPT01036: Error: Task (TaskID: 4, Task Name: INSERT_1) terminated due to the receipt of signal number 6 TPT_INFRA: TPT01037: Error: Task (TaskID: 4, Task Name: INSERT_1) core dumped OS_GetLocalShmAddr: Invalid cntl shm address ac00001 TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2) terminated due to the receipt of signal number 6 TPT_INFRA: TPT01037: Error: Task (TaskID: 5, Task Name: SELECT_2) core dumped Job step MAIN_STEP terminated (status 8) Job EVEREST_LEGACY_CONTRACT_ATTRIBU terminated (status 8)
We are using "TTU 14.10.00.10" which allows only 32 bit TPT. OS version is: "CentOS release 6.6 (Final)"
Can someone please help in this issue.
Thanks & Regards,
To overcome this issue for 32 bit environment, limit the output file size to less than 1244 MB.
Not sure why, but its working.
This is a known issue and we have not yet determined the root cause, nor resolved this issue.