2522744 - Error: '42000: Syntax error near <Query>' when refreshing a report based off Salesforce.com Command Object in Crystal Reports

SAP Knowledge Base Article - Public

2522744 - Error: '42000: Syntax error near <Query>' when refreshing a report based off Salesforce.com Command Object in Crystal Reports

Symptom

  • Error:'Syntax error near'
  • Reports based off Salesforce fails in Crystal Reports.
  • After applying a product update, report based off Salesforce.com fails in Crystal Reports with the error:
       
           Database Connector Error: ‘42000:[Simba][SQLEngine] (31480)
           Syntax error near <SQL Query>  [Database Vendor Code: 31480 ]’
                              
    Or it fails with the error:
                
           Database Connector Error:’42000:[DSI] The error message ParsingFailure could not be found in the en-US locale.’

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • Salesforce.com

Reproducing the Issue

  1. In Crystal Reports, create a report off Salesforce.com using a Command Object.
  2. In the Command Objects enter a SQL Query or SOQL Query
  3. Add at least one database field to the report.
  4. When refreshing the report, it fails with the error:
                  
           Database Connector Error: ‘42000:[Simba][SQLEngine] (31480)
           Syntax error near <SQL Query>  [Database Vendor Code: 31480 ]’

Cause

  • The issue occurs with the latest update of the SAP Salesforce ODBC Driver version 1.02.07.1019 which is bundled in the following version of Crystal Reports and above:
        
    • Crystal Reports 2013 - SP09
    • Crystal Reports 2016 - SP04
               
  • The issue has been tracked under SAP Note 2522637

Resolution

  • The issue is currently under investigation by Development.
           
  • To workaround the issue, downgrade your version of Crystal Reports to a version that have a lower version of the SAP Salesforce ODBC driver. The version of Crystal Reports below are using version 1.01.29.1032 of the ODBC Driver where the issue does not exist, and are connecting to Salesforce.com using TLS 1.2
         
    • Crystal Reports 2013
      • Support Pack 06 - Patch 6
      • Support Pack 07 - Patch 3
      • Support Pack 08 - Patch 4
             
    • Crystal Reports 2016
      • Support Pack 03

Keywords

CR, SForce , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016