SAP Knowledge Base Article - Public

1404062 - Error: "Invalid Argument" when refreshing a report based on Salesforce.com in Crystal Reports 2008 after applying Service Pack 2

Symptom

  • Error: Invalid Argument provided.
  • When refreshing a report based on Salesforce.com, it fails with the above error.
  • It was possible to successfully refresh the same report before applying a product update to Crystal Reports.
  • After applying Service Pack 2 to Crystal Reports 2008, all reports connecting to Salesforce.com fails to refresh with the following error:
       
    " Invalid Argument provided.
      Details: java Server startup failure.  Verify the PATH (JDK), (CLASSPATH), and IORFileLocation properties in the CRConfig.xml file. 
      In addition, verify that you are using JDK 1.5."

Environment

  • Crystal Reports 2008 - Service Pack 2
  • Salesforce.com

Reproducing the Issue

  1. In Crystal Reports 2008, create a report off Salesforce.com
  2. The report refresh successfully.
  3. Save the report.
  4. Apply Service Pack 2 to Crystal Reports 2008
  5. When attempting to refresh the same report, it now fails with the error: "Invalid Argument provided..."

Cause

  • Service Pack 2 provided a small code change that is not compatible with the current sforce-api.jar file.

Resolution

  • To solve the issue, apply Service Pack 3 or above for Crystal Reports; or
    If you cannot apply a product update at this time, then download and replace the sforce-api.jar:
         
    1. Download attached file: sforce-api.jar 
            
    2. Replace the current sforce-api.jar file with the newer version. The file is located by default in the following directory: 
       
          C:\Program Files\Business Objects\Common\4.0\java\lib\external
              
    3. Restart Crystal Reports designer.
            
      You will now be able to successfully connect to Salesforce.com from Crystal Reports 2008 SP02

Keywords

CR, SForce , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1

Attachments

sforce-api.jar