常见informatica powercenter错误

最新推荐文章于 2021-02-07 06:24:52 发布

原创最新推荐文章于 2021-02-07 06:24:52 发布 · 7.9k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #character #transformation #database #file #sql

Informatica Powercenter 专栏收录该内容

3 篇文章

订阅专栏

本文汇总了ETL过程中常见的错误及其原因，包括致命错误、目标表未指定键、数据库类型转换问题、文本文件格式错误、查找表数据未排序及无效对象名称等问题，并提供了相应的解决思路。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1)
Severity Timestamp Node Thread Message Code Message
FATAL 1/18/2011 17:50:51 PM ETLDEVS1 *********** FATAL ERROR : Unexpected Condition in file [/export/home1/build80/zeusbuild_64/powrmart/server/dreader/relrdr/relreader.cpp] line [206]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition. ***********

reason : check the $source, $target connection.

2)
ERROR: Target table [Event_actl_temp] has no keys specified

reason : the logical key(primary) is not set in the Target.

3)
Severity Timestamp Node Thread Message Code Message
ERROR 2/16/2012 6:11:07 PM ETLDEVS1 WRITER_1_*_1 WRT_8229 Database errors occurred:
FnName: Execute -- [DataDirect][ODBC SQL Serv
FnName: Execute -- 523 158

reason : the datatype conversion has issue,
ex: the sql server can't convert 01/04/0001 01:16:50 to datetime.

4)
ERROR: Row [6021]: 2-th character is a null character, which is not allowed in a text input file /schedapps/tmap/log/Driving_Activity.log.

reason : the flat file contains erither null character or blank rows.

CMN_1701 Error: Data for Lookup [<transformation name>] fetched from the database is not sorted on the condition ports. Please check your Lookup SQL override.

reason : lookup override sql中order by 的顺序和端口的顺序不一样

6)
FnName: Execute -- [DataDirect][ODBC SQL Server Driver][SQL Server]Invalid object name 'DOT_actl'.
FnName: Execute -- [DataDirect][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

reason : the connection is not set up properly.