SAP Knowledge Base Article - Public

1461807 - Error: "An error occurred while parsing the native salesforce report", when refreshing a reports based on Salesforce.com in Crystal Reports

Symptom

  • Error:  An error occurred while parsing the native salesforce report.
  • Crystal Reports returns the following error while trying to connect to salesforce.com stored procedure with special character like © (copyright)
       
        "Database Connector Error: An error occurred while parsing the native salesforce report"
         
  • The same value is displayed successfully when connecting to a Salesforce.com table from 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

  1. Open Crystal Reports designer.
  2. Connect to Salesforce.com
  3. Connect to Stored Procedure that contains data with a special character in any string value.
  4. It will then fail with the error:  "Database Connector Error: An error occurred while parsing the native salesforce report"

Cause

  • Copyright character is not supported due to Salesforce.com Stored Procedure connectivity limitation.
  • Salesforce.com Stored Procedure connectivity is different than Salesforce.com direct Table connection.
  • For Stored Procedure, Crystal Reports download the xls file from Salesforce.com, and parse it using pullparser, and if the data contains copyright character, the xls file would be:
      
    <td style="vnd.ms-excel.numberformat:@">Subject</td><td style="vnd.ms-excel.numberformat:@">copyright character &copy; here</td>“&copy;”
      
    Which is an invalid element content in pullparser.
          
  • For Salesforce.com Table, Crystal Reports is getting the data using the API directly without pullparse.

Resolution

  • To be able to report off a Salesforce.com Stored Procedure that have data that contains special characters, you have to delete or replace the unsupported characters in Salesforce.com data.

Keywords

SFDC, SForce, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011