Check the logs and abort the jobs on the basis of the count received

Answer 06/28/2019 Developer FAQ 4

Question:

For my code , I have 5 logs generated for 5 different tables . I have to find for which table the records are not loaded correctly .

Logs generated<br /> NWPR_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors. NWPX_TempLoad_CSP_11.log: 326 Rows not loaded due to data errors. PRAD_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors. PRER_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors. PROV_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors. PRSQ_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors. PRWM_TempLoad_CSP_11.log: 0 Rows not loaded due to data errors.

Here we can see that for NWPX 326 were not loaded due to data errors . so I want the job to abort and in the error message we neeed to print , job aborted for NWPX load

Answer1:

One option is to define a reject link from the Connector with which you write the target table. With a reject link you can specify to abort the job if number of rows on that reject link is >= 1

The job log should have the information about the rejected record anyways.

For more details the stages and exact requirements should be described in more detail.

Similar

Exception Using PayPal-PHP-SDK [Http response code 400]

hooking another program's calls to winapi functions in vb.net

400 error. Recipient address required. JavaScript

What does this mean ~method( ){ } [duplicate]

Is it possible to trash an Azure role host and get it started on the same host without cleanup?

Many-to-one relation exception due to closed session after loading

Can't get iOS push notification device token in react-native

Using PHP to get number of google search results for strings?

How to update column in one table from another if both tables have a text field in common

image overlay and change on dropdown selection?

pointer to strings

How to reference Firebase Functions config variables from a Firebase-hosted application?

CakePHP - Model behaviours with variables

what does quotechar mean in mysql while importing data?

First three characters missing from string when send from android via bluetooth

Why Am I Not Able To Embed My Custom Framework?

Could not initialize class net.sourceforge.pmd.lang.xpath.Initializer

ADGV C# DataGridView - update query bug?

Apache Storm spout stops emitting messages from spout

CSS Grid with dynamic heights for columns and growing rows not fully working

My job scrapes only the last page instead of all of them

Goback Developer FAQ 4

Recommend

JavaScript IE rotation transform maths

C# - Most efficient way to iterate through multiple arrays/list

Consuming a WCF service in a Java Client using wsHttpBinding

ASP.NET MVC Application won't update some controllers

Web.config system.webserver errors

How to revert to previous XCode version?

Excel's Macro-Recorder usage

Oledb connection string for excel files

Is there a way to do normal logging with EureakLog?

Make VS2015 use angular-cli ng at build time in a .NET project

Why querying a date BC is changed to AD in Java?

How do I alternate colors in Flat List (React Native)

Django rest serializer Breaks when data exists

Change Inet root folder for iis 7

How to delay loading a property with linq to sql external mapping?

When to use `image` and when to use `Matrix` in Emgu CV?

R - Combining Columns to String Based on Logical Match

How do I change content of ComboFieldEditor?

Retrieving value from sql ExecuteScalar()

Counter field in MS Access, how to generate?

Is there a amazon webstore API for customers?

Can Jackson SerializationFeature be overridden per field or class?

How to extract text from Word files using C#?

Where to put my custom functions in Wordpress?

vba code to select only visible cells in specific column except heading

Do I've to free mysql result after storing it?

Warning: Can't call setState (or forceUpdate) on an unmounted component

Numpy divide by zero. Why?

Transpose CSV data with awk (pivot transformation)

SetUp method failed while running tests from teamcity

Windows forms listbox.selecteditem displaying “System.Data.DataRowView” instead of actual value

InvalidAuthenticityToken between subdomains when logging in with Rails app

KeystoneJS: Relationships in Admin UI not updating

trying to dynamically update Highchart column chart but series undefined

What are the advantages and disadvantages of reading an entire file into a single String as opposed

embed rChart in Markdown

Sorting a 2D array using the second column C++

How to get NHibernate ISession to cache entity not retrieved by primary key

How can I use `wmic` in a Windows PE script?

Unable to use reactive element in my shiny app