SAP Knowledge Base Article - Public

2853968 - Error:'HY000:[SAP][Salesforce] (120) SOQL_FIRST mode prepare failure…' when creating or refreshing a report based off Salesforce Lightning Stored Procedure in Crystal Reports

Symptom

  • Reports connecting to Salesforce fails.
  • Unable to create new report based off a Salesforce Stored Procedure.
  • Able to create and refresh reports based off Salesforce Tables in Crystal Reports.
  • When attempting to create, or refresh reports based off  Salesforce Stored Procedure in Crystal Reports, it fails with the error:
        
    Database Connector Error:’HY000:[SAP][Salesforce] (120)  SOQL_FIRST mode prepare failure:
    SOQL error:[SAP][Salesforce] (30) Syntax error or access violation when parsing SOQL.
    SQL error: :[SAP][Salesforce] (80) Unknown error received from SOAP response, potentially a problem with user privileges.
    [Database Vendor Code: 120 ]’

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
          
  • Salesforce

Reproducing the Issue

  1. In Crystal Reports, open a report based off a Salesforce Reports.
        
  2. When refreshing the report, it fails with the error:
       
    Database Connector Error:’HY000:[SAP][Salesforce] (120)  SOQL_FIRST mode prepare failure:
    SOQL error:[SAP][Salesforce] (30) Syntax error or access violation when parsing SOQL.
    SQL error: :[SAP][Salesforce] (80) Unknown error received from SOAP response, potentially a problem with user privileges.
    [Database Vendor Code: 120 ]'

Cause

  • From the intial investigation, this error only occurs when reporting off Salesforce Standard Report, which are seen as Stored Procedure in Crystal Reports, and the Salesforce user was migrated from Salesforce Classic, to Salesforce Lightning. 
                 
  • The cause is currently under investigation by Development, and has been track under SAP Note 2838248

Resolution

  • The cause is currently under investigation by Development.

Keywords

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

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016