Symptom
- 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 ]’
Read more...
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- Salesforce
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016
Keywords
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.
SAP Knowledge Base Article - Preview