Symptom
- Error: "Database Connector Error."
- In Crystal Reports, when refreshing a report based off a Saleforce.com data source, it fails with the error: "Database Connector Error."
- Other reports based off Salesforce.com refresh successfully in Crystal Reports.
- 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.
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- Salesforce.com
Reproducing the Issue
- In Crystal Reports, create a report off Saleforce.com.
- Add a complex Record Selection formula like:
({Case.LastModifiedDate} in YearToDate and {Case.CreatedDate} < Date (2011, 10, 01)) OR {Case.ClosedDate} in YearToDate
- Refresh the report
- Notice a Database Connector Error.
- Check the SOQL by clicking Database | Show SQL Query... and notice it is missing parenthesis.
Cause
- The issue has been identified and logged under Problem Report ID ADAPT01657927
Resolution
- The issue is resolved in the following product updates:
- Crystal Reports 2008:
- Fix Pack 4.4
- Fix Pack 5.4
- Service Pack 6
- Crystal Reports 2011:
- Support Pack 04 - Patch 4
- Support Pack 06
See Also
Keywords
- SFDC
- ADAPT01658149
- ADAPT01657928
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011