SAP Knowledge Base Article - Preview

1977803 - Error: "INVALID_QUERY_FILTER_OPERATOR", when refreshing a report based on Salesforce.com in Crystal Reports

Symptom

  • Error: "Failed to retreive data from the database".
  • When reporting on Salesforce.com in Crystal Reports, and filtering the data on an ID Field, it fails with the following errors:

    "SAP Crystal Reports: Failed to retrieve data from the database"

    SAP Crystal Reports: Database Connector Error: ‘HY000:INVALID_QUERY_FILTER_OPERATOR:
    Id, Name FROM Account WHERE (id = ‘1’)
    Error at Row:1:Column:38
    Invalid ID filed: ‘1’ [Database Vendor Code: 47]’ "

  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, Salesforce.com, sforce , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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.