谁知道啥原因不

0

QQ图片20170425151002.jpg 
2017/04/25 14:32:58 - Database join.0 - Couldn't get field info from [select a.Symphony_Camp_Id, a.[Symphony_Placement_Id]

2017/04/25 14:32:58 - Database join.0 - from [dbo].[Y02_MediaPlan_PlacementDetails_Extracted] a

2017/04/25 14:32:58 - Database join.0 - inner join [dbo].[Y03_PlacementTrackingMap] b

2017/04/25 14:32:58 - Database join.0 - on a.[Symphony_Placement_Id]=b.[Symphony_Placement_Id]

2017/04/25 14:32:58 - Database join.0 - where a.client='mercedes'

2017/04/25 14:32:58 - Database join.0 - and ? = b.[TrackingCmpgID

2017/04/25 14:32:58 - Database join.0 - and ? = b.[TrackingPlacementID] 

2017/04/25 14:32:58 - Database join.0 - and ( ? between a.startdate and a.enddate)]

2017/04/25 14:32:58 - Database join.0 - 

2017/04/25 14:32:58 - Database join.0 - 

2017/04/25 14:32:58 - Database join.0 - offending row : [caid Integer], [placement Integer], [date Date]

2017/04/25 14:32:58 - Database join.0 - 

2017/04/25 14:32:58 - Database join.0 - Error setting value #3 [Date] on prepared statement

 The index 3 is out of range.
 
2017-04-25 添加评论
分享

没有找到相关结果

    已邀请:
    0

    GeorgeYao - 路漫漫其修远兮，吾将上下而求索！ 2017-04-25 回答

    Kettle的中参数并非如此写法，你修改为${ID} = b.TrackingCmpgID试一下，以此类推
    2017-04-25 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册