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

Workflow hangs in PowerCenter 9.6.1

来源:INFOCOOL   发布时间: 2017-06-17   作者:网友   浏览次数:
摘要: Workflow hangs in PowerCenter 9.6.1 Problem Description INFA_Problem_Description In PowerCenter 9.6.1, the Workflow ha...
Workflow hangs in PowerCenter 9.6.1
Problem Description

In PowerCenter 9.6.1, the Workflow hangs.

There is no error/info message displayed in the Workflow logs nor in the session logs. 
It is aborted and after re-execution, it works fine.
Cause
This issue occurs because of the pmdtm process being stuck at the Database level (and more specifically in Oracle).

Pmstack traces have been taken during the hang and are as follows:

Thread 3 (Thread 0x7ff8417fb700 (LWP 30940)):
#0  0x00007ff89222176d in read () from /lib64/libpthread.so.0
#1  0x00007ff87b661578 in snttread () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#2  0x00007ff87b660509 in nttfprd () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#3  0x00007ff87b654678 in nsbasic_brc () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#4  0x00007ff87b657bdb in nsbrecv () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#5  0x00007ff87b647785 in nioqrc () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#6  0x00007ff87b69c9c1 in ttcdrv () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#7  0x00007ff87b64e185 in nioqwa () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#8  0x00007ff87b636fb2 in upirtrc () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#9  0x00007ff87b63cca2 in kpurcsc () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#10 0x00007ff87b638646 in kpuexec () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#11 0x00007ff87b637ab3 in OCIStmtExecute () from /u01/oracle/product/11.2.0/client_4/lib/libclntsh.so.10.1
#12 0x00007ff8801413ac in TOracleStatement::executenormal(int, long&) () from /hostname/informatica/powercenter961/server/bin/libpmora8.so
#13 0x00007ff8801447d5 in TOracleStatement::execute(int, long&) () from /hostname/informatica/powercenter961/server/bin/libpmora8.so
#14 0x00007ff88cbb191b in TStatementImpl::Execute() () from /hostname/informatica/powercenter961/server/bin/libpmodl.so
#15 0x00007ff88cbae60e in TStatement::Execute() () from /hostname/informatica/powercenter961/server/bin/libpmodl.so
#16 0x000000000087403e in SLookupWidget::GetDataFromDB() ()
#17 0x00000000008764fd in SLookupWidget::rowExec() ()
#18 0x0000000000877138 in SLookupWidget::execRows(SCmnExecInfo&, int, unsigned long) ()
#19 0x00000000008775f2 in SLookupWidget::blkExecute(unsigned long) ()
#20 0x0000000000836eb4 in SWidget::blkPush(unsigned long, unsigned long, SRowBlockingInfo*) ()
#21 0x000000000083773e in SWidget::blkPushDown(unsigned long, SRowBlockingInfo*, int) ()
#22 0x00000000008255e7 in SExprWidget::blkExecute(unsigned long) ()
#23 0x0000000000836eb4 in SWidget::blkPush(unsigned long, unsigned long, SRowBlockingInfo*) ()
#24 0x000000000083773e in SWidget::blkPushDown(unsigned long, SRowBlockingInfo*, int) ()
#25 0x00000000008255e7 in SExprWidget::blkExecute(unsigned long) ()
#26 0x0000000000836eb4 in SWidget::blkPush(unsigned long, unsigned long, SRowBlockingInfo*) ()
#27 0x000000000083773e in SWidget::blkPushDown(unsigned long, SRowBlockingInfo*, int) ()
#28 0x0000000000837b0a in SWidget::blkFormSegmentAndPushDown(unsigned long, SRowBlockingInfo*, int) ()
#29 0x00000000007e05cc in TLeafExchangeWidget::PushSegment(TLeafExchangeWidget**, unsigned int, unsigned int, unsigned long&) ()
#30 0x00000000007af867 in STransformationRunnable::processOneBlk() ()
#31 0x00000000007aeec5 in STransformationRunnable::run() ()
#32 0x00000000007af206 in STransformationRunnable::handleRequest(SManagerRequest const&) ()
#33 0x0000000000621fe9 in SWorker::run() ()
#34 0x00000000005fb127 in SDTMRunnable::MainEntryPoint() ()
#35 0x00007ff89200de8a in runit(void*) () from /hostname/informatica/powercenter961/server/bin/libpmcef.so
#36 0x00007ff89221a7b6 in start_thread () from /lib64/libpthread.so.0
#37 0x00007ff8847009cd in clone () from /lib64/libc.so.6
#38 0x0000000000000000 in ?? ()

Database Administrators found out that there are constraint issues in  the Database. 
Specifically, a Primary Key does not enforce a NOT NULL constraint due to an issue.​
Solution
To resolve this issue:
  • Prevent the Workflow from querying a table using the Primary Key when the value is NULL.
  • Ensure that the constraints are enforced correctly in the Database.
Involve Oracle Database Administrator to work on this issue.​
More Information
For this issue, the following points have been checked by the Database Administrators:
  • A full trace on the Database service (that the workflow used) has been performed: the table (on which the workflow was stuck) does not appear in the trace.
  • Active Session Monitoring shows no sessions waiting on the Database from Informatica or indeed any other concurrent processes.
  • There are no locks or blockings sessions.
  • Manually running the SQL from the Workflow returned results near instantaneously showing that there is no issue with the query when run outside of Informatica.
A feedback from the Database Administrators is as follows:
The workflow is querying that table and intermittently trying to query with a NULL value against the Primary Key. If the constraint was enabled the query would have returned immediately with zero rows returned. In our case, it took a short period of time for each query. Leading to extreme delays.
Applies To
Product(s): PowerCenter
Database: Oracle

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


我来说两句
评论内容:
验  证  码:
 
(网友评论仅供其表达个人看法,并不表明本站同意其观点或证实其描述。)
评论列表
已有 0 条评论(查看更多评论)
精彩专题
友情链接:
设为首页 - 加入收藏 Copyright @2016 Infocool 版权所有 粤ICP备16000626号