SAP Knowledge Base Article - Public

2205572 - Error: "Failed to open the connection. Nested exception:" when attempting to referesh a report based on in Crystal Reports


  • Error:"Failed to open the connection. Nested exception:"
  • Error when opening a report created in Crystal Reports based on Salesforce datasource from SAP BI Launchpad or the Central Management Console (CMC)
  • When attempting to connect to from Crystal Reports designer, it fails with the error:
    "Failed to open connection. Details: Unexpected error".
    "Nested exception is: PKIX path building failed: unable to find valid certification path to requested target"


  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence Platform 4.0

Reproducing the Issue

  • Scenario 1:
    1. In Crystal Reports designer, create a new report.
    2. Select the connection.
    3. After entering the user credentials, it fails.
  • Scenario 2:
    1. View a report based on a connection in SAP BI Launchpad or the CMC
    2. The report fails with the certificate error.


  • The connection fails because changed the Security certificate from SHA-1 to SHA-256 hash algorithms.
  • For more details read the Knowledge Article 9184


  • To change the Security Certificate Crystal Reports uses when connecting to from SHA-1 to SHA-256 hash algorithms:
    1. Rename the old certificate “cacerts” to “cacerts_old”, found in the following folder:
      • For Crystal Reports 2008 and SAP BusinessObjects Enterprise XI 3.1:
        • C:\Program Files (x86)\Business Objects\javasdk\jre\lib\security
      • For Crystal Reports 2011 and SAP BusinessObjects Business Intelligence Platform 4.0:
        • C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre\lib\security AND
        • C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\jre\lib\security AND
        • C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm\jre\lib\security
          Note: The best way to find required certificate location is to check <JavaDir32> and <JavaDir64> parameters in CRConfig.xml file.
    2. Download the new certificate by clicking here
    3. Copy the new certificate in the same path location.


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


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011