注册 留言板
当前位置:首页 > 企业级应用 > Informatica > 正文

Session crashes without any error message while loading a large input file in PowerCenter 9.6.1

来源:INFOCOOL   发布时间: 2017-06-17   作者:网友   浏览次数:
摘要: Session crashes without any error message while loading a large input file in PowerCenter 9.6.1 Problem Description IN...
Session crashes without any error message while loading a large input file in PowerCenter 9.6.1
Problem Description

In PowerCenter 9.6.1, a session crashes without any error message while loading a large input file.


A project having a production Workflow using PowerCenter 9.6.1 HotFix 1 fails during a session as follows:
  • The input file has 400k rows. This is the first time there is such large volume. Normally it is around 246k.
  • The session has no error reported in session logs. However, there is an error reported in Integration Service log as follows:
    ORA-24550: signal received si_signo=25 si_code=0 si_int=0.
  • Managed to reproduce the same issue with the same input file in another environment. Modified the Memory setting for the Sorter Transformation from Auto to 2048M. The issue still is the same.
  • A core file is generated when the session crashes.
  • Changed the value for ulimit -f to unlimited and restarted the services. However, this does not help too.
Cause
This issue occurs when the file system or the disk (which is making the  write()) is slow. 
It could be observed from the trace that the write() function of the Operating System is the last to be called or executed.

The trace is as follows:

Thread 1 (Thread 0x7f15d83d6700 (LWP 11140)):
#0  0x0000003cbbe0f5db in raise () from /lib64/libpthread.so.0
#1  0x00007f16f70e599e in skgesigOSCrash () from /logiciels/oracle/oradb/11.2.0/ora_clt/lib/libclntsh.so.10.1
#2  0x00007f16f7397251 in kpeDbgSignalHandler () from /logiciels/oracle/oradb/11.2.0/ora_clt/lib/libclntsh.so.10.1
#3  0x00007f16f70e5bae in skgesig_sigactionHandler () from /logiciels/oracle/oradb/11.2.0/ora_clt/lib/libclntsh.so.10.1
#4  <signal handler called>
#5  0x0000003cbbe0e6fd in write () from /lib64/libpthread.so.0
#6  0x00007f175dd5e9d3 in fdostreambuf::flushBuffer() () from /logiciels/pcent196/PowerCenter9.6.1/server/bin/libpmuti.so
#7  0x00007f175dd5ede9 in fdostreambuf::sync() () from /logiciels/pcent196/PowerCenter9.6.1/server/bin/libpmuti.so
#8  0x00007f1752ec74f2 in std::basic_ostream<char, std::char_traits<char> >::flush() () from /usr/lib64/libstdc++.so.6
#9  0x00007f175ee0fda4 in PcsfLocalLogFile::writeImpl(LogEvent*&) () from /logiciels/pcent196/PowerCenter9.6.1/server/bin/libpcsflog.so
#10 0x00007f175ee0c0cd in PcsfLogFile::write(LogEvent*&) () from /logiciels/pcent196/PowerCenter9.6.1/server/bin/libpcsflog.so
#11 0x000000000065c3b3 in opbLog::OutputLSImpl(SServerLogMessageLevel, unsigned short const*, PmUString const&, long long) ()
#12 0x000000000065c5d3 in opbLog::OutputLS(SServerLogMessageLevel, unsigned int, PmUString const&, unsigned short const*, long long) ()
#13 0x000000000065df14 in opbLog::LogEvent(unsigned int, ...) ()
#14 0x000000000065e0b2 in opbLog::printDebug(unsigned short const*, ...) ()
#15 0x00000000006266f7 in BlkCmnTmpl<SBlkData>::DumpBlock(SBlkData const*, outputLog*, unsigned short const*, unsigned short const*, unsigned short const*, int) ()
#16 0x0000000000834fbd in SWidget::blkPush(unsigned long, unsigned long, SRowBlockingInfo*) ()
#17 0x00000000008353ee in SWidget::blkPushDown(unsigned long, SRowBlockingInfo*, int) ()
#18 0x0000000000874fba in SLookupWidget::blkExecute(unsigned long) ()
[...]
Solution
To resolve this issue, set the data segment size to unlimited.

Following is the way to set the data segment size to unlimited:
  1. Go to $INFA_HOME/tomcat/bin.
  2. Shutdown the services: infaservice.sh shutdown
  3. Once the services are down, type ulimit -d unlimited
  4. Ensure that all the other environment variables are set up correctly.
  5. Start the services again: infaservice.sh startup.
  6. Run the session.
Applies To
Product(s): PowerCenter

Last Modified Date:6/16/2017 5:29 AMID:ID:508171
People who viewed this also viewed


我来说两句
评论内容:
验  证  码:
 
(网友评论仅供其表达个人看法,并不表明本站同意其观点或证实其描述。)
评论列表
已有 0 条评论(查看更多评论)
精彩专题
  • 本月排行
  • 总排行
友情链接:
QQ交流群:①群 155252576 INFOCOOL官方交流群 ②群 469193068 WEB前端技术交流群 ③群 531831996 数据库交流群 ④群 243504572 编程技术交流群
设为首页 - 加入收藏 Copyright @2016 Infocool 版权所有 粤ICP备16000626号