question Re: Nifi treating newline as argument delimiter despite custom config in Support Questions

Nifi treating newline as argument delimiter despite custom config

abvincita — Tue, 15 Mar 2022 07:04:36 GMT

I'm having issues with ExecuteStreamCommand, I have set up the Argument Delimiter as ~ like screenshot below:

However when ERROR_DETAIL attribute contains newline characters (\n or %0A) apparently Nifi treats the newline as a delimiter and hence the shell script receives more than 1 arguments in the place of ERROR_DETAIL. I was expecting Nifi to use strictly just the ~ character as the argument delimiter.

Am I missing a different config in Nifi? Is there a way to make Nifi ignores the newline and only use the ~ as the delimiter?

Re: Nifi treating newline as argument delimiter despite custom config

araujo — Tue, 15 Mar 2022 11:51:15 GMT

Hi, @abvincita ,

Try using the following Command Arguments in your processor configuration:

"${ERROR_DETAIL}"~"${ERROR_CODE}"

Cheers,

André

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Re: Nifi treating newline as argument delimiter despite custom config

abvincita — Wed, 16 Mar 2022 05:23:47 GMT

Hi @araujo , thanks for your suggestion.

I tried doing that, and while it seems to make Nifi ignores the newlines indeed, the processor now throws a different error:

ERROR: ORA-01756: quoted string not properly terminated

The strings are definitely terminated in the configuration.... The ERROR_DETAIL does contain double quotes as well, can this be affecting it?

Re: Nifi treating newline as argument delimiter despite custom config

araujo — Wed, 16 Mar 2022 06:21:39 GMT

@abvincita ,

Yes, if ERROR_DETAIL has double-quotes in it, it will have adverse effects. Does it have single-quotes too? If not, you can try using:

'${ERROR_DETAIL}'~'${ERROR_CODE}'

Cheers,

André

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Re: Nifi treating newline as argument delimiter despite custom config

araujo — Wed, 16 Mar 2022 06:48:44 GMT

Hi, @abvincita ,

Please ignore my last post. I did a quick test using dynamic properties arguments and confirmed that it works well, regardless of the content of the attributes.

Please give this a try:

André

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.