- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PutSQL catch the SQL error
- Labels:
-
Apache NiFi
Created ‎01-21-2023 05:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am getting an error after the PutSQL processor (failure)
I there a way the catch the SQL error, I want to send it via LogMessage
Thanks
Created ‎01-21-2023 08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I dont think you catch the SQL error in the sense that PutSQL wont report the error. However you can use the PutDatabaseRecrod instead and use the failure relationship to LogMessage where you can access the error message using the "putdatabaserecord.error" attribute.
A better way of capturing errors from any processor (Global Catch) is to use the SiteToSiteBulletinReportingTask as explained here:
SiteToSiteBulletinReportingTask
If that helps please accept solution.
Thanks
