SAP Knowledge Base Article - Preview

1976422 - Error: ‘HY000:MALFORMED_QUERY' when refreshing a report based off Salesforce.com, that filter data on a date, in Crystal Reports

Symptom

  • When refreshing a report in Crystal Reports 2013, it fails with the error: "Failed to retrieve data from the database".
     
  • Used to be able to refresh the same report in Crystal Reports 2011.
       
  • When reporting off Salesforce.com in Crystal Reports 2013, if the report contains a Record Selection Formula that filter on date fields, it fails with the following errors:
      
    "SAP Crystal Reports: Failed to retrieve data from the database"

    "SAP Crystal Reports: Database Connector Error: ‘HY000:MALFORMED_QUERY: CreatedDate >= YYYY-MM-DD 00:00:00 ) AND ( CreatedDate < YYYY-MM-DD Error at Row:1:Column:81  line 1:81 no viable alternative at character ‘ [Database Vendor Code: 70]’ "
         

  • 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 2013
       
  • Salesforce.com

Product

SAP Crystal Reports 2013

Keywords

CR, Salesforce, SForce, SP02, SP03, SP04, Salesforce.com, ADAPT01718495,  ADAPT01718496, ADAPT01719327, ADAPT01719328, date field, filter data on a date, filter by date, failed to retrieve data from the database, HY000, MALFORMED_QUERY, CreatedDate , 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.