Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] Record Logging
 Login/Join
 
Madhumitha
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: 53 | Registered: September 30, 2008Report This Post
Clif
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.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
Madhumitha
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: 53 | Registered: September 30, 2008Report This Post
Clif
Guru
posted Hide Post
Please open a hottrack case and upload your Direct Load Flow, source and target synonyms, and some sample erroneous data.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders