Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

PowerCenter Session Crashes With Unexpected Error While Running Session for Teradata Using "PowerExchange for Teradata Parallel Transporter" Connector
Problem Description
The session terminates unexpectedly with below error when configured to run using PowerExchange for Teradata Parallel Transporter (TPT) Connector:

--------------------------------
FATAL 11/9/2019 6:11:43 AM NODE_1 *********** FATAL ERROR : An unexpected condition occurred in file [/export/home/build_root/EBFs/ebf-15500_1020hf2_lin-x64/powrmart/server/dmapper/trans/srcpipe.cpp] line [1383].  Aborting the DTM process.  Contact Informatica Global Customer Support. ***********
--------------------------------
Cause
This issue is because Pre-SQL or Post-SQL command used with "PowerExchange for Teradata Parallel Transporter" (TPT) Connector.
Solution
PowerExchange for TPT connectivity does not support pre-SQL/post-SQL commands. So, to resolve this crash, do as below:

1. Remove the pre-SQL/post-SQL commands for TPT connector.
2. Re-run the session.

Workaround

Refer the below steps if there is a requirement to use pre-SQL/post-SQL commands with "PowerExchange for Teradata Parallel Transporter" (TPT) Connector:
  • Create a dummy table in the PowerCenter Designer with a Teradata type connection. 
  • Add this to the mapping and output it to a flat-file. 
  • From the Designer, change the Target Load Plan (check the "mapping" menu), so that this new pipeline is either first or last in the list depending on if you want Pre or Post session SQL.
  • Add your Pre/Post session SQL to the dummy source from the Workflow Manager --> Session Properties --> Mapping tab (under the dummy source).​
More Information
​Below is the stack trace captured in core file:

--------------------
#1  0x00007fc375e94a68 in abort () from /lib64/libc.so.6
#2  0x00007fc380c30569 in PmAbortProcess() () from /opt/informatica/pwc_1020/server/bin/libpmuti.so
#3  0x00000000005de7f1 in DTMAssertHandler(char const*, int) ()
#4  0x000000000075816d in SPipeline::runTgtSQL(SPipeline::ESessionSQLType, int) ()
#5  0x000000000075b422 in SPipeline::deactivate(int) ()
#6  0x00000000006fbb9d in SConcurrentSourceSet::deactivate(int) ()
#7  0x00000000006276b2 in SWorker::run() ()
#8  0x0000000000602df1 in SDTMRunnable::MainEntryPoint() ()
#9  0x00007fc382b45fea in runit(void*) () from /opt/informatica/pwc_1020/server/bin/libpmcef.so
#10 0x00007fc382d52ea5 in start_thread () from /lib64/libpthread.so.0
#11 0x00007fc375f5b8cd in clone () from /lib64/libc.so.6
--------------------
Applies To
Product: PowerCenter; PowerExchange
Problem Type: Product Feature; Crash/Hang
User Type: Developer
Project Phase: Implement
Product Version: PowerCenter; HotFix
Database: Teradata
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:3/30/2020 10:57 PMID:608031
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)