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

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 > 100 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)

• SAP BW/4HANA 2.00

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