field conversion error limit reached

[mstoler]

Hello,

I am getting 'field conversion error limit reached' on a fuzzy match when all my strings are v_wstrings.

Why am I getting this message and how can I trobuleshoot?   I assume that the fuzzy match is processing all the records and just skipping the records with the field conversions?

Thanks,

Michael

[grazitti_sapna · Accepted solution]

Hi @mstoler,

I can see the data type you are using is v_wstring, but can you please check the size of the fields and try to give them a bigger value like 256,512 whatever works for you. I think this should resolve your issue. If the issue persists can you please share the sample of data and the output you are trying to achieve?

[mstoler]

Hello,

Yes I increased the size to 3000 characters, problem gone.

Thanks!

Michael