SAP Knowledge Base Article - Preview

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


  • Reports connecting to Salesforce fail.
  • Unable to create a report of a Salesforce Stored Procedure.
  • Able to create and refresh reports based of Salesforce Tables in Crystal Reports.
  • When attempting to create, or refresh reports based of 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 ]’



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


SAP Crystal Reports 2013 ; SAP Crystal Reports 2016


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.