Error on Render tool

Hello,

I'm trying to create my first large push reporting using the alteryx reporting tools out to a .pdf file and then push that via email. There are going to be roughly 2,000 emails going out.

Everything seems to work fine when I run a small sample through.

However, when I run the workflow with all of the data(Not sending emails yet), I get hundreds of lines like this on a few different render tools:

"Error: Render (207): Exception parse error line: 1 column: 40 An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (b) of a 3-byte sequence."

A lot of the lines seem to process appropriately, but I've never seen this error before, and I can't seem to figure out which records within the render tool are even causing it, which makes it even harder to trouble shoot.

I couldn't find anything about this error anywhere, so any information on what causes this so I can start digging for a solution would be greatly appreciated.

Thanks!

Reporting

Error Message

Output

Accepted answers

AdamR_AYX

The error indicates you have some corrupted string data coming from somewhere. It is specifically saying that it has a character which it expects to be encoded in 3 bytes of data, however the second byte of the three is not valid.

Does your data have any 'non-ascii' characters in it? That's where I would start looking.

All comments

AdamR_AYX

Does your data have any 'non-ascii' characters in it? That's where I would start looking.

FFFool

So, you are right, and I foung the culprit. JeanSébastien I'm guessing it is the e with the accent. Not entirely sure how to get rid of it now, though. It is coming out of a query straight into Alteryx and the Replace Function in the formula tool failed. I'm not great with Regex, but I would imagine it would also fail if the replace formula failed.

Any ideas?

Thanks again!

Hollingsworth

I've run into this problem before and used the ConvertToCodePage([fieldname],20127) function in the Formula tool to downgrade the Unicode to simple ASCII.

20127 is the CodePage for ASCII. It does a nice job of choosing the simple version of the vowels without the accents. That way you don't end up with misspelled words.

I do think this is a bug though. IMO, the Render tool should be able to handle Unicode.

derekc

Agreed: we need the accented characters here in Québec. Please update this tool to work with Unicode characters.

Hello @AdamR_AYX

I have the same error.

I am trying to create a report. I have two tables, i make an union of two tables and a layout with horizontal orientation. The render poster an error : "Error: Render (33): Exception parse error line: 1 column: 40 An exception occurred! Type:UTFDataFormatException, Message:invalid bytes à, of 3-byte sequence."

To khnow the problem comes from which table. i add render after the two basic table and i don't have the same error message after layout.

attached a screen shot, of my workflow. Please any help

please any help

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703