3579953 - Error "Failed to fetch data" appears intermittently in a varying number of widgets while loading an SAP Analytics Cloud story.

• When executing an SAC story that contains a page with several widgets, e.g. charts, which are supposed to show data from the same BW query. Many charts show message "Failed to fetch data.".
• There also might be an error popup occurring, showing message "MC 601 The requested object is currently locked by user ...". The affected widgets may differ for each time the story is refreshed.
• The issue is intermittent.

• SAP Analytics Cloud (SAC) 
• BW Live
• S/4HANA Live

1. Login to SAC.
2. Open the problematic SAC story having a page that contains several widgets requesting data from the same BW query in parallel.
   >>Notice the error:"Failed to fetch data."

• When a query is executed in BW, the system first checks whether the query runtime object needs to be re-generated. For instance this is necessary, if the query or basic objects changed. If re-generation is required, the system sets a lock, generates the query and then lifts the lock again.
• While the lock is active, the query cannot be accessed by other processes. Such attempt will raise message "MC 601 The requested object is currently locked by user". So far, this is standard behavior and correct.
• SAC allows up to 12 parallel requests being sent to BW. In above situation, the first processed query request will set the lock and all the others, which reach the BW/S4 system in the meanwhile, will get the issue. However, the widget related to that first request will finally get data.
• The required time for query generation highly depends on complexity. Usually it takes a second, in some cases it takes many seconds (30+). In case of fast query generation time, no widgets, only a few widgets or all other widgets might be affected, depending on how fast all parallel sent requests get processed. In case of long query generation time probably all other requests, except the first, will be affected.

A new mechanism was introduced. If a lock is detected, it checks each 5 seconds whether the lock is still active. This will be repeated up to 18 times. After 90 seconds in total the message "MC 601" is returned to SAC. With this mechanism users will experience a corresponding delay in the affected widgets, instead of getting message "Failed to fetch data."

Implement note 3527773 - "INA : Sporadic locking error related to object RSRREPDIR"

SAP Note: 3527773 - "INA : Sporadic locking error related to object RSRREPDIR"

MC 601, locked by user, RSRREPDIR, Failed to fetch data, generation. , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , Problem