tSalesforce component using SOQL failing with "String literal is not properly closed by a double-quote"

Talend Version          6.2.1

Summary

Upgrade of tSalesforceInput -with Manual input of SOQL query- broken in 6.2.1
Additional Versions  
Product  
Component  
Problem Description

Jobs with tSalesforceInput components, set with Manual input of SOQL query, which compiled successfully in previous version 6.1.1 are now broken and failing compilation with the following error:

String literal is not properly closed by a double-quote

 
Problem root cause  
Known issue TDI-37454, due to extra CR and LF characters.
Solution or Workaround  
Upgrade to  6.2.2 or 6.3.1.
As a workaround in 6.2.1: copy the SOQL query string value into a text editor to remove the problematic CR and LF chars and making sure the string is one unbroken line, then copy back to SOQL query field.
JIRA ticket number  https://jira.talendforge.org/browse/TDI-37454
Version History
Revision #:
1 of 1
Last update:
‎05-18-2017 09:00 PM
Updated by:
 
Labels (1)
Contributors