关闭

常见informatica powercenter错误

标签: sql servercharactertransformationdatabasefilesql
4742人阅读 评论(0) 收藏 举报
分类:

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.

 

5)

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.

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:18665次
    • 积分:405
    • 等级:
    • 排名:千里之外
    • 原创:24篇
    • 转载:3篇
    • 译文:0篇
    • 评论:0条