SAP Knowledge Base Article - Public

3525083 - Error: 'Execution was halted due to an attempt to load an unsigned component <folder path>\oci.dll' when refreshing a report based on Oracle in Crystal Reports

Symptom

  • Error: 'Execution was halted due to an attempt to load an unsigned component...'
  • Could successfully refresh reports based on Oracle before applying an update to Crystal Reports.
  • When refreshing a report based on Oracle, Crystal Reports generates the following error, then crash:

         "Execution was halted due to an attempt to load an unsigned component <folder path>\oci.dll"

Environment

  • SAP Crystal Reports 2020 - Support Pack 03 - Patch 11
  • SAP Crystal Reports 2020 - Support Pack 03 - Patch 12
      
  • Oracle 12c
  • Oracle 18c
  • Oracle 19c
  • Oracle 21c

Reproducing the Issue

  1. Start Crystal Reports 2020
  2. Open a report based on an Oracle data source using a native connection.
  3. Refresh the report.
  4. Crystal Reports generates the following error then crash:

    "Execution was halted due to an attempt to load an unsigned component <folder path>\oci.dll"

Cause

  • Error caused by the security feature implemented in
    - Crystal Reports 2020 with Support Pack 03 - Patch 11
    - Crystal Reports 2020 with Support Pack 03 - Patch 12
    Where unsigned external third party driver can no longer be executed.

Resolution

  • If you are not using SAP Crystal Server 2020, or SAP BusinessObjects BI 4.3, then install:
    • Crystal Reports 2020 - Support Pack 04 , or higher
         
  • If you are using SAP Crystal Server 2020, or SAP BusinessObjects BI 4.3, with Support Pack 04 or higher, then install:
    • Crystal Reports 2020 with the Support Pack corresponding to the Support Pack installed on the server side
         
  • If you are using SAP Crystal Server 2020, or SAP BusinessObjects BI 4.3, with Support Pack 03, then install:
    • Crystal Reports 2020 - Support Pack 03 - Patch 12 - Hotfix 1; or
    • Crystal Reports 2020 - Support Pack 03 - Patch 10
                  
  • To download and install Crystal Reports 2020 - Support Pack 03 - Patch 12 - Hotfix 1 
       
    1. Go to the SAP Software Download at: https://origin.softwaredownloads.sap.com/public/site/index.html   
        
    2. Then select in the following:
      • Software Product: SAP Crystal Reports
      • Product Version  : SAP Crystal Reports 2020  
      • Software Type     : *
           
    3. Click "Go"
        
    4. In the list at the bottom, select the following download:     

          SAP Crystal Reports 2020 SP03 Patch 1200 - ONE
        
    5. Install Crystal Reports 2020 - SP03 - Patch 12
        
    6. Download Support Pack 03 - Patch 12 - Hotfix 1, from the link below:

         https://softwaredownloads.sap.com/file/0020000000905322024
         
    7. Then install Crystal Reports 2020 - SP03 - Patch 12 - Hotfix 1

Keywords

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

Product

SAP Crystal Reports 2020