SAP Knowledge Base Article - Public

2238875 - Connecting to Oracle from Crystal Reports - Master Knowledge Base

Symptom

  • Problems connecting Crystal Reports to Oracle datasources

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
       
  • Oracle 11g
  • Oracle 12c

Reproducing the Issue

  1. In Crystal Reports, create or refresh report connecting to Oracle datasource.

Resolution

  • Below is a list of common issues connecting to Oracle datasources from Crystal Reports, and Crystal Reports for Enterprise: 
       
                 
  • For Crystal Reports 2008, 2011, 2013 and 2016  
                
  • Generic Connectivity and Configuration:
        
    • 2384904 - Does Crystal Reports supports Oracle 12c ? 
           
    • 1752459 - Oracle Server connection missing in Crystal Reports
        
    • 1337708 - Crystal Reports support of 64 bit Operating Systems
         
    • 1217820 - Registry settings to configure ODBC database drivers and SQL Syntax joins
         
    • 1850017 - Error: 'ORA-12505' when creating a JDBC connection based on Oracle database 
         
    • 1698249 - Error: 'Failed to open the connection' when refreshing a report based off a universe using an Oracle JDBC connectivity
         
    • 1688743 - Error: 'Failed to load database information', when scheduling or viewing reports based off Oracle
        
    • 1432328 - Schema tables do not appear in the Database Expert of Crystal Reports when connecting to Oracle 11g through ODBC driver
         
    • 1197846 - Error: 'Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-01456: May not perform insert/delete/update operation inside a READ ONLY transaction' when viewing a report based off Oracle
             
        
  • Oracle Stored Procedures:
         
    • 1181947 - Oracle Stored Procedures Requirements for Crystal Reports
        
    • 1822696 - Poor performance when reporting off an Oracle Stored Procedure in Crystal Reports
        
    • 1569938 - No data or incomplete data set returned in Crystal Reports when reporting off an Oracle View, Stored Procedure, or Command Object
        
    • 2169139 - Oracle OLE DB Provider support for Stored Procedures in Crystal Reports (ORA -06550)
        
    • 1574554 - Error: 'Invalid argument type' when refreshing a report based off an Oracle Stored Procedure in Crystal Reports
        
    • 2140646 - Error: 'Failed to retrieve data from the database. Details: ORA-00942' when attempting to create a report off an Oracle 12c Stored Procedure
        
    • 1569990 - Error: 'Failed to Retrieve Data from Database ORA-06550' when adding Oracle Stored Procedure
         
    • 1544128 - Error: 'Failed to retrieve data from the database Details: ORA-06550 PLS-00103: Encountered ... " while reporting off a Universer based off an Oracle Stored Procedure
              
             
  • Incorrect behavior:
        
    • 1564768  - Oracle native connection returns fewer records than ODBC in Crystal Reports
        
    • 1680608 - Crystal Reports against Oracle database takes a long time to refresh
           
    • 2005553 - Crystal Reports does not display Oracle Unicode data correctly
           
    • 1206647 - Does Crystal Reports support Oracle TIMESTAMP data type fields?
           
    • 1205489 - Mixed or incorrect data in Crystal reports that use Oracle Long fields
         
    • 1843192 - Report based on an Oracle View returns wrong data
         
    • 1839148 - Crystal Reports based on Oracle takes a long time to execute
           
    • 1415792 - Crystal Reports return incorrect result when reporting against Oracle
          
    • 1906004 - Error: 'Oracle tnsnames entry not found', while Viewing a Crystal Reports based on Universe on demand in SAP BI LaunchPad
        
    • 1626943 - Error: 'ORA-00942 Table or View does not exist' on a report based on Business Views with Oracle as a data source in Crystal Reports
          
        
  • Known Defects: 
       
    • 1339862  - Reports slow to render with multiple subreports and Native Oracle driver
        
    • 1702608 - Wildcard character not working for Oracle database in Crystal Reports
          
    • 1202730  - Oracle database connectivity issues installing BusinessObjects Enterprise XI Release 3 or Crystal Reports 2008 on a 64-bit Windows platform
               
                
  • How to:
      
    • 2017430 - How to add Oracle hint in Crystal Reports?
        
    • 1204190 - Size limitation of an Oracle CLOB field in Crystal Reports
         
    • 1517132 - Timestamp is included in the input parameter inspite of the parameter being Date type in Crystal Report based on Oracle stored Procedure.
        
             
         
  • For Crystal Reports for Enterprise:
          
    • 2166471 - Error: 'The data source 'Oracle 12' is not suported' when attempting to connect to an Oracle 12c
        
    • 2169341 - Error: 'Java Class not found in classpath : oracle.jdbc.OracleDriver' when creating a universe connection using an Oracle JDBC driver
         
    • 2147860 - Search in Crystal Reports for Enterprise LOV prompt is case-sensitive for reports connected to Oracle

Keywords

KBA , crystal reports , connectivity , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016