Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] Record Logging
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] Record Logging
 Login/Join
 
Gold member
posted
I created a flow with sql server source and target table. In the source table, one of the column data type is ‘A12’ and the corresponding mapping target table column data type is ‘I11’. I want to insert the format error data into separate table, I used “Record Logging” tab on the Flow Properties, we have options in there to capture rejects. Please find the attached screenshot .

When I run the job, I am not able to see the format error data into format error table ‘flow01_formaterr.ftm’ and the same – none of the “Record Logging” tables are not getting inserted.

Note:

Version – 7.7.03
Source table – SQL Server
Target table – SQL Server
Record logging tables – Flat File
Prior to load – Truncate/Insert record

This message has been edited. Last edited by: Tamra,
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
A Data Flow doesn't trap Format Errors as stated in the DMUG:

Format Errors
Logs transactions rejected due to a format error. (Format errors only apply to Direct Load Flows.)

So if the source is a single table try using a Direct Load Flow.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Clif,

I tried in direct load data not loaded into format error table.

Simply getting not able to convert for the field "Filed1"

Thanks,
MAdhu
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
Please open a hottrack case and upload your Direct Load Flow, source and target synonyms, and some sample erroneous data.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] Record Logging

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.