informatica 常见问题及解决方案

2022-08-16 20:16:51

本文对于informatica使用过程中产生的问题及解决方案做总结，持续更新中。。。

1、partitioning option license required to run sessions with user_defined partition points

原因:union 组件要求使用分区，但是license 却没有该权限。

解决方案：1、union中 is partitinable 设置为no，require single thread per partition 取消check；

2、重做task；

完成上述两步，该问题即可解决。

2、FATAL ERROR : Unexpected Condition in file [/u05/bld65_64/pm713n/server/dmapper/widget/wjoiner.cpp] line [3176]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition.

原因：某一个字段的连接线没有连上导致的错误

3、Message: *********** FATAL ERROR : Unexpected Condition in file [/ZeusbuilderProduction/view/powrmart/common/odl/oracle8/oradriver.cpp] line [241]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition.

原因：驱动问题

解决方案：原因是我导表结构时，使用的oracle提供的ODBC去导的。。driver是Oracle in OraHome92

这次我换了PC8提供的ODBC去导就好了，driver是DataDirect CLOSED ODBC 5.1 oracle wire protocol

4、FATAL ERROR : Unexpected Condition in file [\ZeusbuilderProduction\view\powrmart\server\cmnutils\svecmatrix.cpp] line [256]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition. ***********

Cause:
The error occurred due to sorter transformation's cache size setting. Cache size was set to 1GB.

Resolution:
Resetting
the cache size to Auto will resolve the problem. Max limit for cache
size on 32-bit server is 3.99 GB. When I calculated the cache size for
data I was getting was approximately 5 GB. So I set cache size to Auto
at session level and re-run the workflow

5、SRTTRANS: ERROR [22050] in processing Eof for input group 0

原因： there were some invalid records

解决方案： changed stop on errors property to 0, the session succeeded by rejecting the invalid records.

6、Hash insert thrashing detected or Hash find thrashing detected

解决方案：

Relax the paging restriction by increasing the value of HASH_THRASHING_PERCENT.
Increase
the size of the temporary cache (DBA only). Keep in mind that
increasing the size of the temporary cache requires an equal size
reduction in main cache allocation to prevent the possibility of system
thrashing.
Attempt
to identify and alleviate why Sybase IQ is misestimating one or more
hash sizes for this statement. For example, check that all columns that
need an LF or HG index have one. Also consider if a multicolumn index is
appropriate.

Decrease the value of the database option HASH_PINNABLE_CACHE_PERCENT.

问题2、3、4、5、6中设置session的cache size为auto，充分优化mapping，设置目标加载器的分隔符，减小生成文件大小，充分考虑数据库服务器和informatica的压力，平衡负载，效果比以上方案好。

7、Workflow执行时提示操作系统配置文件错误处理

（解决方案转自：http://blog.sina.com.cn/s/blog_520391d701016wb7.html）

Workflow执行时提示操作系统配置文件错误处理

一、问题截图：