tSalesforce component using SOQL failing with "Str...
tSalesforce component using SOQL failing with "String literal is not properly closed by a double-quote"
Upgrade of tSalesforceInput -with Manual input of SOQL query- broken in 6.2.1
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.