3439367 - Request activation in an ADSO hangs in the activation process

The activation of a request in an ADSO takes longer than expected. The slow/hanging statement can look like this:

SELECT DISTINCT <FIELDNAME>
  FROM <ADSO_AQ_TABLE> 
  WHERE  (    ( <FIELDNAME>   )    NOT IN    (       
       SELECT <FIELDNAME>      
         FROM <CHARACTERISTIC_SID_TABLE>      
         WHERE DATAFL          =           'X'   )  )

In scale-out systems this problem is more likely to happen.

• SAP NetWeaver 7.50
• SAP BW/4HANA

KBA , BW4-DM-ADSO , DataStore Object (Advanced) , BW-WHM-DBA-ADSO , DataStore Object (advanced) , Problem