53227

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

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.

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