SAP Knowledge Base Article - Preview

3059536 - Activation of InfoObjects/Infoproviders is slow/high CPU utilization

Symptom

The activation of BW objects like:

  • ADSO-s
  • InfoObjects
  • HCPR-s

after a structural change can lead to one or all of the following situations:

  • The CPU utilization on the database is very high
  • The activation of the particular object takes longer than usual
  • In DB02 -> Locks -> Object locks hundreds of column views/projections/etc are listed which are waiting to be processed
  • Many HANA threads show thread detail 'parallel metadata object recompile'.

This can happen if at any point in time the system was on SP07 (SAPK-20007INDW4CORE ) or the SAP NOTE 2954865 was applied and during this time any BW Column view was (re)generated by activation/transport.

The following SQL statement can be used to check if the system is possibly affected or not:

select case when cnt > 20 then 'System is possibly affected' else 'System is not affected' end as CheckResult from
(select top 1 bw_object_name, count(*) as cnt from
(select SUBSTR_REGEXPR('[^:]+' IN "VIEW_NAME" OCCURRENCE 3) as bw_object_name from views where view_name like '0BW:BIA%')
group by bw_object_name order by count(*) desc)


Read more...

Environment

  • SAP BW/4HANA 2.00

Product

SAP BW/4HANA 2.0 ; SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , BW4-ME-IOBJ , InfoObjects , BW4-ME-ADSO , DataStore Object (Advanced) , BW4-ME-HCPR , Composite Provider , BW4-ME-CTS , Change and Transport , Problem

About this page

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

Search for additional results

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