2245162 - How to troubleshoot the error “Exception during http Transaction: Unterminated string at XXX[character YY line ZZ]”

This KBA explains on how to troubleshoot the error which is encountered in the Boomi process.

Error seen in process reporting page:

Interface Failed.

Detailed Error:

[EXCEPTION] ODATA Execution Error Code: 500

When you download the process logs for Boomi process you can find this error for SEVERE:

2015-11-17T14:21:46Z     SEVERE Connector priv_prod Connector; I08_Query_SF_PositionData    Exception during http Transaction: Unterminated string at 124479 [character 255 line 939]

Boomi , BizX environment

KBA , odata execution error code: 500 , unterminated string at , data issue , api issue , bad data in boomi , api not reading data , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , How To