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 for Me (Login required).

Search for additional results

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