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

Talend Version          6.2.1


Upgrade of tSalesforceInput -with Manual input of SOQL query- broken in 6.2.1
Additional Versions  
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)