Alteryx Input Tool - ServiceData parser error

[vatsan19]

Hi All,

I'm getting this error message "Error: ServiceDataParser (2): Tool #3: Internal Error: Attempt to read past the end of a blob" from Server Data Parser macro when i use normal Input tool to connect with MongoDb. I'm not getting this error when i use deprecated MongoDB Input tool. Can you please let me know what is the issue? I'm currently using Alteryx Server v2023.1.  PFA error screenshot.

Thanks,

Srivatsan

[OllieClarke]

Hi @vatsan19 

I'm not familiar with this macro, but my guess here is that the size of the blob column going into the macro is different to what it's configuration is expecting. 

If you right click the the macro you can open it and view its configuration. find tool id3 and share a screenshot of its config here. Also look at the metadata going into the macro and share that here too if you don't mind.

Ollie 

[kiedam26 · Accepted solution]

Hi @vatsan19 , 

I faced the same error when using the Input tool with the MongoDB ODBC driver. The fix is to increase the Binary Column Size in the Advanced Options of your AlteryxService ODBC DSN Setup.

Try setting it to a higher value like 214748364. That resolved the issue for me.

Regards,
Kieda

[vatsan19]

Thanks @kiedam26 the issue is resolved now