SAP Knowledge Base Article - Preview

2118506 - Error: "Failed to retrieve data from the database. Qualified column could not be bound." when reporting on Salesforce.com in Crystal Reports

Symptom

  • Error: "Failed to retrieve data from the database. Details: 42S22:[Simba][SQLEngine[(31400) Qualified column could not be bound: <Object Name> [ Database Vendor Code: 31400 ]"
  • When refreshing a report in Crystal Reports 2013, based on Salesforce.com, it fails with the error.
  • Same report refresh successfully in Crystal Reports 2011 and below.
            
            
  • 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
  • SAP Crystal Reports 2016
          
  • Salesforce.com

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

Sforce, SOQL, CR , 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.