Member since
09-20-2023
1
Post
0
Kudos Received
0
Solutions
09-20-2023
05:26 AM
Hi ladies and girls, I'm trying to merge error logs generated by ExecuteSQL and send them via email. Currently, I have the following flow: ExecuteSQL - failure - > MergeContent - merged -> PutEmail. If I disable MergeContent, the logs are being sent as they should but ( an inidividual email for each error log). If I enable MergeContent, I receive a single email however it duplicates the first error. ERROR: syntax error at or near ""1qa"" Where: PL/pgSQL function "extract".truncate_tables(character varying) line 5 at EXECUTEERROR: syntax error at or near ""1qa"" Where: PL/pgSQL function "extract".truncate_tables(character varying) line 5 at EXECUTEERROR: syntax error at or near ""1qa"" Where: PL/pgSQL function "extract".truncate_tables(character varying) line 5 at EXECUTEERROR: syntax error at or near ""1qa"" Here are the settings that I use: I also added a LogMessage processor and the flow for original is showing the correct content. The problem seems to be with the merged logs. Can someone pinpoint where the problem is or how can I fix this issue?
... View more
Labels:
- Labels:
-
Apache NiFi