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
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.