SAP Knowledge Base Article - Preview

1306933 - CMS queries on Oracle database are taking up CPU

Symptom

  • Certain runaway queries of the format "SELECT si_table, si_hidden_object, si_ruid, si_runnable_object, si_instance_object, si_guid, si_cuid, si_plugin_object, si_nameduser, si_recurring, objectid, parentid, typeid, ownerid, lastmodifytime, objflags, userflags, schedulestatus, nextruntime, aliases, crc, properties FROM cms_infoobjects5 WHERE objectid IN (nnnnn)" will be running on the Central Management Server (CMS) Database
  • These queries consume high CPU on the system database server (up to 100%)
  • Error: "Timeout (0ms) waiting for database mutex."
  • CMS querying performance gets slower as time goes by


Read more...

Environment

  • Business Objects Enterprise XI R2
  • Business Objects Enterprise XI 3.1
  • Oracle 10.x
  • Oracle 9.x

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

KBA , BI-BIP , Business intelligence platform , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.