1980814 - No Oracle stored procedures listed in Crystal Reports, when using an ODBC connection

Symptom

• Stored procedures missing.
• No Oracle stored procedures listed in Crystal Reports, when attempting to create a new report via an ODBC connection to Oracle using the CR Oracle ODBC driver. 
• When creating a new report via an Oracle native connection, it list all the Oracle stored procedures.

Environment

• Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
     
• CR Oracle ODBC Driver 5.3
• CR Oracle ODBC Driver 6.0
• CR Oracle Wire Protocol ODBC Driver 5.3
• CR Oracle Wire Protocol ODBC Driver 6.0

Reproducing the Issue

1. Install and configure the Oracle client on the local computer.
2. In the ODBC Data Source Administrator, create an ODBC DSN to the Oracle database using the CR Oracle ODBC Driver.
3. In Crystal Reports, when creating a native Oracle connection to the database, it list all the Oracle stored procedures.
4. But when creating an ODBC connection to the same Oracle database using the ODBC DSN created in step 2, it does not list any Oracle stored procedure.
   

Cause

• The ODBC DSN created to the Oracle database is configured to only return the stored procedures owned by the user logged in to Oracle.
• Since the user logged in to Oracle isn't the owner of any of the stored procedures, it does not list any stored procedures.

Resolution

• To display a list of all available Oracle stored procedure when using the following ODBC drivers to connect to Oracle:
      
     - CR Oracle ODBC Driver
     - CR Oracle Wire Protocol ODBC Driver
  
  Uncheck the CR Oracle ODBC driver option: "Use Current Schema for SQLProcedures". To do so, follow the steps below:
          






1. Open the ODBC Data Source Administrator.
2. Select the ODBC DSN created using the CR Oracle ODBC Driver, and click on the button "Configure"
   
   
3. In the "ODBC Oracle Driver Setup", under the tab "Performance", uncheck the option: "Use Current Schema for SQLProcedures"
   
   

4. Click "OK" to accept the change.
     
   Now, when creating a new report in Crystal Reports using the CR Oracle ODBC driver, it will list all the available Oracle Stored Procedures.

Keywords

CR, Oracle, Data Direct Oracle ODBC driver, DD ODBC

Header Data

Released On	13.03.2014 16:10:12
Release Status	Released to Customer
Component	BI-RA-CR Crystal Reports designer or BusinessViews Manager
Priority	Normal
Category	Problem

1738989 - Upgrade/Support Package import hang due to INACTIVE wait event "SQL*Net break/reset client" in Oracle

Symptom

*** This note is only applicable in platform MS Windows ***
*** Bug 13017584 is already fixed in Oracle patch set 11.2.0.4 and higher ***

During upgrade, phase DDIC_UPG, ACT_UPG or SHADOW_IMPORT_INC hang.
OR
During Support Package import, main import(IMPORT_PROPER) phase hang.
When you check the Oracle session via ST04/ST04old or OS level, you will see that sessions are in status INACTIVE with wait event SQL*Net break/reset to client.
You can follow the steps below to identify the current wait event which corresponding to the hanging session:

1. First you need to identity the PID for the hanging session, example R3trans.    

          Using Windows Task Manager, Ctrl+Alt+Del -> Start Task manager -> "Processes" tab
    2.   Then, check the wait event for the hanging session.

• From R3 level:

ST04/ST04old  -> detailed analysis session -> oracle sessions

OR

DBACockpit (as of SAP Basis Release 7.00 Support Package 12) -> Performance -> Wait Event Analysis -> Session Monitor

REMARK: Only ACTIVE sessions will be displayed in DBACockpit. This is not useful as we need to find INACTIVE sessions too.

• From OS level:

sqlplus "/as sysdba"

set pagesize 200
set linesize 200

SELECT
S.SID,
S.STATUS,
S.PROCESS,
SUBSTR(DECODE(SW.WAIT_TIME, 0, SUBSTR(SW.EVENT, 1, 35), 'CPU'),
1, 30) ACTION,
DECODE(ST.SQL_TEXT, NULL, AA.NAME,
SUBSTR(ST.SQL_TEXT, 1, 32)) SQLTEXT,
S.MODULE,
S.PROGRAM
FROM
V$SESSION S, V$SESSION_WAIT SW, V$SQLTEXT ST, AUDIT_ACTIONS AA
WHERE
S.STATUS in ('ACTIVE', 'INACTIVE') AND S.SID = SW.SID AND
S.SQL_HASH_VALUE = ST.HASH_VALUE (+) AND
S.SQL_ADDRESS = ST.ADDRESS (+) AND ST.PIECE (+) = 0 AND
AA.ACTION = S.COMMAND
ORDER BY
S.STATUS;

Environment

• SAP Netweaver Release Independent
• Support Package Tools(SPAM) for ABAP
• SAPup for ABAP
• SAP Enhancement Package Installer (SAPehpi)
• Software Update Manager (SUM)

Reproducing the Issue

The problem can be reproduced when Oracle patch set lower than 11.2.0.4 is running on MS Windows.

Cause

Known bug in Oracle 11g.

Resolution

There is a known bug in the Oracle 11g. Please check SAP note 1635605.

To prevent this error, apply the mentioned SAP Bundle Patches /Oracle patch collections as per mention in the note 1635605.
If you already encounter this issue during upgrade or support package import then set the Oracle initialization parameter " _use_zero_copy_io=false" as a workaround and reboot the database instance.

See Also

1635605 -  Client hangs on insert into table with SecureFile LOB

Keywords

SPAM, SUM, EHP, support package, upgrade, SHADOW_IMPORT_INC, hang, performance, slow, main import, IMPORT_PROPER, DDIC_UPG, ACT_UPG, SQL Net break, reset client, Oracle, 11g, 11.2, bug, Windows, NT, _use_zero_copy_io, Oracle client, SecureFile LOB, SecureFile,

Header Data

Released On	15.12.2014 06:32:19
Release Status	Released to Customer
Component	BC-UPG-OCS-SPA Support package tools for ABAP
Other Components	BC-DB-ORA Oracle BC-UPG-TLS-TLA Upgrade tools for ABAP
Priority	Normal
Category	Problem

1206647 - Does Crystal Reports support Oracle TIMESTAMP data type fields?

Symptom

• Oracle Timestamp data type fields displays as picture in Crystal Reports.
• Oracle Timestamp data type fields doesn't display in Crystal Reports.
• Oracle Timestamp data type fields doesn't work in Crystal Reports.

Environment

• Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013

Reproducing the Issue

1. In Crystal Reports, create a report off an Oracle data source using an ODBC or OLEDB connection.
2. Notice the database field that have a Timestamp data type in Oracle displays as a picture data type in Crystal Reports, and it does not return data for the field.

Cause

• Crystal Reports doesn't supports the following Oracle data type:
• Timestamp
• Timestamp with time zone
• Timestamp with local time zone
       
• When connecting to Oracle using the following connections:
• ODBC
• OLEDB

Resolution

• To report from Oracle timestamp data type fields in Crystal Reports, connect to Oracle using the Oracle Native (Oracle Server) connection:
     
1. In Crystal Reports, under the menu "File", select "New - Blank Report..."
2. In the "Database Expert" window, expand "Create New Connection"
3. Under "Create New Connection", select "Oracle Server"
4. Select the Oracle server to connect to.

Keywords

ORACLE TIMESTAMP DATETIME FIELD TIME ZONE NATIVE ODBC OLEDB CONNECTION stamp ole db connect date time RDO ADO , 9231146

Header Data

Released On	19.03.2015 20:45:03
Release Status	Released to Customer
Component	BI-RA-CR Crystal Reports designer or BusinessViews Manager
Priority	Normal
Category	Problem
Database	ORACLE 11.0

1670876 - Client Versions needed for Oracle 10.2 in BI 4.0 for Crystal Reports

Symptom

Reporting off of Oracle 10.2 in Crystal Reports 2011 gives unexpected results or errors

Environment

Crystal Reports 2011, BI 4.0, Windows 64 bit, Windows Server 2008

Reproducing the Issue

Create or migrate a Crystal Report that uses a 10.2 Oracle middleware.

Cause

The version of the Oracle 10 client does not include the fixes requested from Oracle

Resolution

 Starting from Oracle 10.2.0.1 patch 6, Oracle fixed a bug to support SAP Crystal Reports default install folder format on 64 bit Windows. Please use that or later versions of Oracle 10gR2 on 64 bit Windows.

Keywords

Oracle, ORA-12157, Crystal Reports, 10g,Oracle 10

Header Data

Released On	10.01.2012 15:26:32
Release Status	Released to Customer
Component	BI-BIP Business intelligence platform
Other Components	BI-RA Reporting, analysis, and dashboards
Priority	Normal
Category	How To

1822696 - Poor performance when reporting off an Oracle Stored Procedure in Crystal Reports.

Symptom

• Slow when reporting off an Oracle Store Procedure in Crystal Reports.
• Crystal Reports status bar shows records are coming from the Stored Procedure in small batches.
• Native connection to an Oracle Stored Procedure in Crystal Reports is 10 times slower than an ODBC connection to the same stored procedure.

Environment

• Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
     
• Oracle version 11.2 

Reproducing the Issue

1. In Crystal Reports, create a report off an Oracle Stored Procedure returning large amount of records (about 10 000) using a native Oracle connection.
2. Refresh the report.
3. Notice it takes a long time to return the data.

Cause

• The reason it takes more time to fetch the data when connecting to an Oracle stored procedure in Crystal Reports using the native Oracle connection, it's because Oracle did not support pre-fetch feature for store procedure prior to Oracle version 11.2.0.1, so the Oracle driver is not fetching data to optimize performance.
• In newer version of Oracle, the pre-fetch feature should allow to improve the performance.
• This situation was reported to product under ADAPT01682544.

Resolution

• The performance has now been improved when reporting off an Oracle stored procedure using the native Oracle connection in the following version of Crystal Reports:
     
• Crystal Reports 2008:
• Fix Pack 5.5
• Service Pack 7
    
• SAP Crystal Reports 2011:
• Support Pack 08
       
• SAP Crystal Reports 2013:
• Support Pack 01, Patch 1.2
• Support Pack 02

Keywords

CR, Oracle, stored procedure, performance

Header Data

Released On	09.01.2014 00:25:27
Release Status	Released to Customer
Component	BI-RA-CR Crystal Reports designer or BusinessViews Manager
Priority	Normal
Category	Problem
Database	ORACLE 10.0

1626443 - PCM10: Failed to connect to Oracle database when configuring PCM v10 64bit "80880021 General Data Base Error ORA-12541 : TNS:no listener"

Symptom

When trying to connect to Oracle database, PCM configure failed to connect and raised 2 possible error messages :
"80880021 General Data Base Error ORA-12541 : TNS:no listener"

Or
"Invalid Workflow user - General Database Error"

Environment

• SAP BusinessObjects Profitability and Cost Management 10.0 (PCM)
• Oracle 11g client package installed on the same machine
• Business Objects Enterprise components (BOE - IPS 4.0 SP2 for CMS tool) installed and connected with Oracle CMS schema

Reproducing the Issue

1. Start with a working system:
   a) Windows Server 2008 64bit
   b) Oracle 11gR2 64bit
   c) Information Platform Services 4 (4.0 SP2) installed as the first product
   d) Can connect to the CMS correcly
2. Install PCM v10.0 64bit on the Primary Applications server.
3. Run the “Configuration Wizard” and the error message will be generated on the “Test Connection to Primary Server” page after pressing the “Next >” button.

Cause

• During the configuration, PCM v10 64bit environment failed to connect Oracle database due to the OCI Oracle *.dll currently installed in the system
• The PATH for Environment Variables pointed at the OCI dll from Client Oracle package, instead of using the OCI dll from the Oracle Instant Client for 64-bit

Resolution

1. Download the basic package "Instant Client for Microsoft (x64)" from the Oracle download website :
   
   
2. Extract the "instantclient-basic-windows.x64-11.2.0.2.0.zip" on a local drive of the PCM server.
   For example, C:\OCIx64\Instantclient_11_2
   
   
3. Copy all files from the root of "C:\OCIx64\Instantclient_11_2"  (excluding the 2 sub-directories "vc8" and "vc9")
   
4. Paste all of them into the "...SAP BusinessObjects\PCM\x64" directory
   
   
5. Copy the 2 files (oraocci11.dll and oraocci11.sym) from "C:\OCIx64\Instantclient_11_2\vc9"
   
   
   
   
6. Paste these 2 files into the "...SAP BusinessObjects\PCM\x64" directory.
   
   
7. Confirm the copy of the 2 files oraocci11.dll and oraocci11.sym to replace the 2 existing ones in the "...SAP BusinessObjects\PCM\x64" directory.
   
8. From the PCM Configure, choose the location of 64 bit OCI dll respectively from "...SAP BusinessObjects\PCM\x64" directory as shown below :

After completing the PCM Configure, PCM changes the PATH values in Environment Variables with the following order :
PATH : C:\Program Files (x86)\SAP BusinessObjects\PCM\x64; C:\app\Administrator\product\11.2.0\dbhome_1\BIN;...
Unfortunately, with this order, the CMS fails to connect to Oracle database.
The workaround to make both CMS and PCM work is :
1. Modify the order in the PATH values as following :
PATH : C:\app\Administrator\product\11.2.0\dbhome_1\BIN;C:\Program Files (x86)\SAP BusinessObjects\PCM\x64;... where ORACLE HOME BIN directory will be at the first place in the PATH, before PCM x64 directory
2. Reboot the machine
Knowing the issue of changing values in PATH for PCM Configuration, a new enhancement request was raised and can be tracked under the ADAPT01577625 :  PCM won't modify the system path if the OCI.dll is in the PCM x64 install directory for 64 bit setups or PCM Install directory for 32 bit setups. If the DLL is found anywhere else the path will be modified as before and asks for reboot.
This enhancement request has been implemented in PCM 10 SP01. Please see the PCM 10 SP release notes for full details.

See Also

1805310 - PCM: Oracle related errors
1753611 - PCM 10 Upgrade Configuration Errors - Oracle database
1626443 - PCM10:Fail to connect to Oracle database when configuring PCM v10 64bit
1853742 - Oracle Support for PCM v10 requires Oracle Database 11g Enterprise Edition Release
1671525 - PCM: What versions of Oracle are supported by PCM 10?
1524945 - PCM: When will PCM support Oracle v11.2?
1546214 "PCM: Oracle 11g R2 - #1 Installation"
1546171 "PCM: Oracle 11g R2 - #2 Create PCM Database"
1546215 "PCM: Oracle 11g R2 - #3 Create PCM TableSpace"
1546209 "PCM: Oracle 11g R2 - #4 Listener Configuration"
1546218 "PCM: Oracle 11g R2 - #5 Create PCM Schema"
1546210 "PCM: Oracle 11g R2 - #6 Configuration Wizard"
See also the PCM 10 Installation Guide available through the SAP Help Portal

Keywords

ADAPT01577625, ADAPT 01577625, Oracle OCI, Instant Client, x64 bit

Header Data

Released On	16.07.2013 10:58:10
Release Status	Released to Customer
Component	EPM-PCM Profitability and Cost Management, EPO, PP, AA, Metify
Priority	Normal
Category	Bug Filed

2211262 - Oracle Listener cannot be started

Symptom

Oracle listener cannot be started. When you try to do it manually, it throws the error bellow:

<hostname>:<sid>adm $ lsnrctl start [LISTENER_NAME]
LSNRCTL for <OS>: Version 12.1.0.2.0 - Production on 30-AUG-2012 18:06:43

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /oracle/<SID>/121/bin/tnslsnr: please wait...

TNSLSNR for <OS>: Version 12.1.0.2.0 - Production
System parameter file is /oracle/<SID>/121/network/admin/listener.ora
Log messages written to /oracle/<SID>/121/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   <OS> Error: 1: Not owner

Environment

• Any SAP System
• Oracle database as of 10.2
• Linux or Unix OS

Reproducing the Issue

The issue may be reproduced in several occasions, as bellow:

• Running SWPM
• Starting Oracle manually
• Starting Oracle on OS boot

Among other. The common behavior is the error while starting it manually, as described in the Symptom.

Cause

This error is caused by lack of permissions in the socket files.

Resolution

Make sure that both <sid>adm and oracle/ora<sid> have full permissions in the following two directories:

1. /tmp/.oracle
2. /var/tmp/.oracle

Correct by either changing the ownership or granting more privileges:

1. chown ora<sid>.dba /tmp/.oracle
2. chmod 774 /tmp/.oracle

See Also

SAP Note 562403: FAQ: Oracle Net

Keywords

oracle lsnrctl tnslsnr swpm sapinst hpux hp-ux linux redhad red hat solaris aix suse installation upgrade

Header Data

Released On	27.08.2015 23:49:43
Release Status	Released to Customer
Component	BC-DB-ORA Oracle
Other Components	BC-INS-UNX Installation Unix
Priority	Normal
Category	Problem

1868289 - Unable to start the BusinessObjects Enterprise XI 3.1 services after migrating the CMS Database from Oracle 10G to Oracle 11G

Symptom

Unable to start the BOE services after migrating the CMS database from oracle 10g to oracle 11g

Environment

• SAP BusinessObjects Enterprise XI 3.1
• Solaris 10 (SPARC)
• Oracle 11G

Reproducing the Issue

1. Migrate the CMS database from oracle 10g to oracle 11g
2. Launch the ./startservers script
3. The boe services won't be started

Cause

The oracle 11g client is on 64 bits.

Resolution

As BOE 3.1 is a 32 bits architecture, the oracle client 11g must be on 32 bits.

Keywords

oracle,32its, cms, migration, xi 3.1, sia not started, unix

Header Data

Released On	09.06.2013 13:46:28
Release Status	Released to Customer
Component	BI-BIP-DEP SBOP Web Application Deployment, Wdeploy
Priority	Normal
Category	Problem

1557665 - Database connection in Desktop Intelligence document doesn't get updated even oracle client is changed to connect to another Oracle server

Symptom

Database connection in Desktop Intelligence document remains while oracle client changes connection server to another.

Environment

• BusinessObjects Enterprise XI 3.1 Server Pack 3
• Oracle 10.2
• Desktop Intelligence document (DeskI)

Reproducing the Issue

1. Prepare two Oracle servers on two environments separately.
2. Create Oracle users with same user name and rights on two separate oracle server.
3. Create tables with same table name on both Oracle database servers.
4. Insert different data into tables on two Oracle database server respectively.
5. On BusinessObjects Enterprise (BOE) system, create a connection with default settings via oracle client connected to database server 1. ("Connection Pool Mode" should be "Keep the connection active for" by default.)
6. Create a universe with the connection created on step 5.
7. Create new Desktop Intelligence document (via InfoView or client tool) based on the universe created on step 6. 
8. Change database server IP address from server 1 to server 2 in "tnsnames.ora" file on BOE server.
9. Refresh DeskI report and check the data doesn't get updated at all.

Cause

Database connection used in Universe doesn't get updated after changing Oracle client to connect to another Oracle server.

Resolution

This issue can be resolved under steps below:

1. Close DeskI document and client tool.
2. Reopen the document.
3. Refresh the document and check data to be updated.

See Also

1540204 - Database connection in Web Intelligence document doesn't get updated even Oracle Client is changed to connect to another Oracle server

Keywords

Oracle, database, tnsnames.ora, IP address, connection

Header Data

Released On	15.02.2011 09:22:29
Release Status	Released to Customer
Component	BI-RA-DKI Desktop Intelligence
Priority	Normal
Category	Problem

2169341 - Error: Java Class not found in classpath : oracle.jdbc.OracleDriver in Crystal Reports for Enterprise when creating a universe connection using Oracle JDBC driver

Symptom

Error: Java Class not found in classpath : oracle.jdbc.OracleDriver  in Crystal Reports for Enterprise when creating a universe connection using Oracle JDBC driver.

Environment

• SAP BusinessObjects Business Intelligence Platform 4.x
• Crystal Reports for Enterprise 4.x
• Oracle JDBC connection
• Linux Operating System

Reproducing the Issue

1. Obtain the necessary JDBC driver software from the database vendor. (For Orcale: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html)
2. Put the Driver in the SAP BO Directory <Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc
3. Open jdbc.sbo file under  Directory <Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc.
4. Add the required .jar file details to the ClassPath area. 
5. The example below was entered in the jdbc.sbo file.

            <DataBase Active="Yes" Name="Oracle 12">
            <JDBCDriver>
                <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
                <Parameter Name="URL Format">jdbc:oracle:thin:@//$DATASOURCE$/$DATABASE$</Parameter>
            </JDBCDriver>
            <Parameter Name="Extensions">oracle12,oracle,jdbc</Parameter>
            <Parameter Name="Escape Character">/</Parameter>
            <Parameter Name="Force Execute">Always</Parameter>
            <Parameter Name="Catalog Separator">.</Parameter>
                <Parameter Name="Driver Capabilities">Query,Procedures,Cancel</Parameter>
           </DataBase> 

  

    6.  Save and close the .sbo file.

    7.  Go to Crystal Reports for Enterprise and create a New Connection and refresh the report.

Cause

The LD_LIBRARY_PATH for Oracle is not defined in system environment variable.

Resolution

1. Execute below command to set the related environment variables
             export PATH=$PATH:<oracle jbdc folder path>/ojdbc6.jar
             export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<oracle jbdc folder path>/ojdbc6.jar
2. Restart BI servers to load these environment variables.

Keywords

Crystal Report for Enterprise, SAP Business Intelligence Platform 4.x, CR4E, LI_LIBRARY_PATH, PATH, oracle, JDBC

Header Data

Released On	19.05.2015 02:44:34
Release Status	Released to Customer
Component	BI-RA-CRE Crystal Reports for Enterprise
Priority	Normal
Category	Problem

2120298 - Oracle Installer does not start

Symptom

When performing the Oracle database installation, after calling the RUNNINSTALLER, you see the following error:

And in the oraInstall log, this is what you see:

---# Begin Stacktrace #---------------------------
ID: oracle.install.commons.util.exception.DefaultErrorAdvisor:8
oracle.install.commons.base.driver.common.InstallerException: [INS-10102] Installer initialization failed.
        at oracle.install.commons.base.driver.common.Installer.run(Installer.java:317)
        at oracle.install.ivw.common.util.OracleInstaller.run(OracleInstaller.java:106)
        at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:136)
        at oracle.install.commons.util.Application.startup(Application.java:896)
        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:165)
        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:182)
        at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:348)
        at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:124)
        at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:155)
Caused by: oracle.install.commons.base.driver.common.SetupDriverException: [INS-10002] Inventory initialization failed
        at oracle.install.driver.oui.OUISetupDriver.load(OUISetupDriver.java:388)
        at oracle.install.ivw.db.driver.DBSetupDriver.load(DBSetupDriver.java:207)
        at oracle.install.commons.base.driver.common.Installer.run(Installer.java:299)
        ... 8 more

---# End Stacktrace #-----------------------------
Exception in thread "main" java.lang.NullPointerException
        at oracle.install.driver.oui.LogSafetyChecker.update(LogSafetyChecker.java:76)
        at oracle.install.driver.oui.LogSafetyChecker.update(LogSafetyChecker.java:53)
        at oracle.install.commons.util.EventSupport.fireEvent(EventSupport.java:100)
        at oracle.install.commons.util.Application.fireApplicationEvent(Application.java:1031)
        at oracle.install.commons.util.Application.shutdown(Application.java:946)
        at oracle.install.commons.base.driver.common.Installer.shutdown(Installer.java:406)
        at oracle.install.commons.util.Application.shutdown(Application.java:940)
        at oracle.install.commons.util.exception.DefaultExceptionHandler.handleException(DefaultExceptionHandler.java:48)
        at oracle.install.commons.util.exception.ExceptionManager.handleException(ExceptionManager.java:148)
        at oracle.install.commons.util.exception.ExceptionManager.handle(ExceptionManager.java:362)
        at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:157)

Environment

• SAP systems with Oracle database
• Not restricted to a product or product version
• Linux or Unix Operating System

Reproducing the Issue

Start the Oracle Universal Installer with the RUNINSTALLER script.

Cause

The Oracle database user lack permission to read and write in the Oracle Inventory.

Resolution

Check where the oraInventory is located:

cat /etc/oraInst.loc

You will see the following lines:

inventory_loc
inst_group

Then make sure the ora<sid> or oracle user is either the owner or has full read/write permissions on the directory and subdirectories in the inventory_loc of the oraInst.loc output.

See Also

SAP Note #1431796: Oracle 11.2.0: Troubleshooting the Software Installation
SAP Note #1524205: Oracle 11.2.0: Database Software Installation

Keywords

orainventory, inventory, oracle, installation, installer, oui, runinstaller, aix, hp-ux, solaris, linux, redhat, suse, oel, rhel, sles, orasid, ora<sid>, oraInst.loc

Header Data

Released On	21.01.2015 17:49:37
Release Status	Released to Customer
Component	BC-DB-ORA-INS Installation SAP System with Oracle
Other Components	BC-DB-ORA Oracle
Priority	Normal
Category	Problem
Database	ORACLE 10.2.0.5 ORACLE 11.2.0.1.0 ORACLE 11.2.0.2 ORACLE 11.2.0.3

1663672 - Web Intelligence query runs infinitely and Oracle process reaches 100% CPU

Symptom

• Unable to refresh or run a Webi Query in Infoview
• Query turns for hours without returning any results
• Oracle process reaches 100% CPU usage

Environment

• Business Objects Enterprise Xi 3.1 SP3
• Oracle 10.2.0.4.0

Reproducing the Issue

1. Logon to Infoview
2. Create a Webi report based on Oracle database
3. Click run
4. The query runs infinitely

Cause

• This is not a BOE defect but an optimization and configuration tuning on Database side issue.
• Oracle calculates every time, a different execution plan instead of reusing the plan of an already executed query.

Resolution

 Modify the value of the Oracle parameter CURSOR_SHARING to FORCED.
Note:

• Oracle does not recommend setting CURSOR_SHARING to FORCE in a DSS environment or if complex queries are used.
• Star transformation is not supported with CURSOR_SHARING set to FORCE. 

See Also

For more information see Also:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/memory.htm

Keywords

oracle 100% cpu, webi, turn, runs infinitely, no results

Header Data

Released On	19.12.2011 17:51:34
Release Status	Released to Customer
Component	BI-RA-WBI Web Intelligence
Priority	Normal
Category	Problem
Database	ORACLE 10.2.0.4.0

1816439 - General slowness with Business Objects Enterprise XIR3.1 and BI4.0 when using Oracle as CMS DB

Symptom

• Logon to Enterprise InfoViewApp or BILaunchpad is slow to respond.
• Objects in InfoViewApp or BILaunchpad Home page are slow to display.
• Browsing Public Folders in InfoViewApp or BILaunchpad is slow.
• Further investigation into Oracle CMS DB performance may show lock contentions within CMS_InfoObjects7 table  - this is completely normal but, in certain circumstances, mentioned below, the lock(s) remains for a longer time interval, causing a longer wait time than normal.
• Oracle DB monitoring tool (Grid Control), may show an increase in CPU usage
• Lock contention time may be noticed more during higher concurrent logons and increased scheduling activity.

Environment

• SAP BusinessObjects Enterprise XI 3.1
• SAP BusinessObjects Business Intelligence Platform (BI) 4.0 / 4.1
• Oracle as Central Management Server database (CMS) repository.

Reproducing the Issue

1. Configure BusinessObjects to use Oracle 11G as the CMS database repository.
2. Log into InfoViewApp, BILaunchpad or Central Management Console, browse Public Folders and objects.

Cause

The cause in this case was found to be Internal Maintenance job activity within the Oracle database.

Resolution

1. Involve your Oracle DBA to fine tune these activities.
2. Disable internal Oracle 'AutoTasks.'

See Also

974781 - Oracle internal maintenance jobs

Keywords

slow, navigate, refresh, bo, 3.1, 4.0, 4.1, oracle, cms, database, difficult, hang, freeze, performance, grid, contention, lock, long, time, response, folder, report

Header Data

Released On	06.01.2016 13:22:37
Release Status	Released to Customer
Component	BI-BIP-ADM BI Servers, security & CrystalReports viewing in BI platform
Priority	Normal
Category	Problem

1324358 - Column missing when importing table using Oracle Applications Data Store - Data Integrator Oracle GL Rapid Mart 11.5.x

Symptom

• When trying to "import by name" a table like "AX.AX_SLE_LINES" from Oracle Applications via Oracle Applications Data Store, the table is missing one column: SET_OF_BOOKS_ID

Reproducing the Issue

Environment:

• OS: Windows 2003 SP1
• Data Integrator version 11.7.3.3
• Oracle General Ledger Rapid Mart version 11.5.1.3
• Oracle Applications version 11.5.10.2
• Oracle DB version 10.2.0.2

How to reproduce:

• Use "import by name" to import a table like "AX_SLE_LINES", with owner "AX" from Oracle Applications via an Oracle Applications Data Store

Cause

• When you import tables into Data Integrator repository via Oracle Apps Data Store their definition is read from  Oracle Apps Object Library (FND_TABLES, FND_COLUMNS) and the column in question does not exist in those tables

Resolution

• Oracle Apps do not expose AX.AX_SLE_LINES.SET_OF_BOOKS_ID column in the Object Library tables (FND_TABLES, FND_COLUMNS) read by Oracle Apps Data Store to Rapid Mart. So this is expected behavior for Data Integrator Rapid Marts, especially when customizing the pre-build solution by adding extra tables,etc

• Solution:

1.  By using an Oracle Database datastore, the table definition is read from the database library directly, hence SET_OF_BOOKS_ID column shows up.

2. A more complex approach which requires more experience with the product is to export the Oracle Apps Data Store to an .atl file, modify the file content using notepad to add the missing column in the table metadata definition.

• Note: This resolution can be applied to any Oracle Apps with metadata missing, when one needs to apply Rapid Mart customization. The AX.AX_SLE_LINES table is not used by any Rapid Marts.

Keywords

Rapid Mart, Oracle Applications

Header Data

Released On	31.03.2009 09:56:35
Release Status	Released to Customer
Component	EIM-DI Data Integrator, Composer
Priority	Normal
Category	How To
Database	ORACLE 10.2.0.2.0
Operating System	WIN 2003