This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
Adam Riley Principal Software Engineer Tech Lead Core Engines, Alteryx
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.
This is sort of a solution, as it removes the letter completely, which isn't 100% what we want, but it will work. If we only had one special character in one name it wouldn't be a problem and we could replace with that letter, but we have several.
Thanks again for pointing me in the right direction, couldn't have done it without you!
I am getting an error "Error: Render (110): Data field not found" every time while I attach render tool with lift chart. Is there any other solution to permanently capture lift chart output apart from browse tool? Render tool is working perfectly fine while I attaché it with Logistic regression or Random Forest or decision Tree but not with Lift. Thanks.
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