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

Pmdtmsvc2 process crash while running EDC profile on ODBC Redshift Connection
Problem Description
While running an Enterprise Data Catalog profile on an ODBC Redshift connection, it fails with "Data Transport Errors" in the Data Quality DIS log. On further inspection, it is found that the core files were being dumped to $INFA_HOME/tomcat/bin. The pmdtmsvc2 process keeps crashing. 
Cause
In this case, the DIS had the following DIS custom property set: 

ExecutionContextOptions.JVMMaxMemory=8192

The "M" was missing and must be present. This should be changed to ExecutionContextOptions.JVMMaxMemory=8192M.
Solution
Do as follows to resolve the pmdtmsvc2 process crash: 

1. Disable the DIS. 
2. Edit the DIS custom property from "ExecutionContextOptions.JVMMaxMemory=8192" to "ExecutionContextOptions.JVMMaxMemory=8192M". 
3. Enable the DIS and run the profile. The pmdtmsvc2 process would no longer crash.
More Information
the following output is noticed in the core files dumped to $INFA_HOME/tomcat/bin: 

#1  0x00007f3241552a68 in abort () from /lib64/libc.so.6
#2  0x00007f324cd8df4d in PmAbortAssertHandler(char const*, int) () from /apps/informatica/10.4/services/shared/bin/libpmcmnasrt.so
#3  0x00007f324b94fa61 in PmUString::grabBuffer(PmUStringData*) () from /apps/informatica/10.4/services/shared/bin/libpmi18n.so
#4  0x00007f324cb78f92 in IUString::IUString(IUString const&) () from /apps/informatica/10.4/services/shared/bin/libpmsdkcmn.so
#5  0x00007f32494f5a4f in MNExecutionContext::getOverrideTracing() const () from /apps/informatica/10.4/services/shared/bin/libpmdtmnmd.so
#6  0x00007f324912e822 in SSession::getTracingLevel() const () from /apps/informatica/10.4/services/shared/bin/libpmdtmrts.so
#7  0x00007f324ab5b849 in SMapping::getTracing(SSession*) () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#8  0x00007f324ab4a93a in SLkpCacheDirectorImpl::init(SDTMMaster*, SSession*) () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#9  0x00007f324ab087c9 in SDTMMaster::initMappingCompilationTask() () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#10 0x00007f324ab0a376 in SDTMMaster::start() () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#11 0x00007f324ab218b8 in SDTM::execute() () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#12 0x00007f324ab21b38 in SDTM::start() () from /apps/informatica/10.4/services/shared/bin/libpmdtm.so
#13 0x00007f324c1850b2 in DTMControlImpl::asyncStart(void*) () from /apps/informatica/10.4/services/shared/bin/libpmdtmimpl.so
#14 0x00007f323ceb1a35 in ACE_Thread_Adapter::invoke_i() () from /apps/informatica/10.4/services/shared/bin/libACE.so.6.3.3
#15 0x00007f323ceb1ab1 in ACE_Thread_Adapter::invoke() () from /apps/informatica/10.4/services/shared/bin/libACE.so.6.3.3
#16 0x00007f32410f0ea5 in start_thread () from /lib64/libpthread.so.0
#17 0x00007f32416198cd in clone () from /lib64/libc.so.6

MNExecutionContext::getOverrideTracing pointed us to check DIS custom properties and DIS advanced profiling settings. This is where the DIS custom property is present. 
Applies To
Product: Enterprise Data Catalog; Data Quality
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version: Informatica 10.4
Database: ODBC
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/1/2020 9:16 PMID:619429
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)