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