Blocked Transactions SAP ME / HANA

[Carlos_Quiñones]

Hi 

We have some problems with SAP ME and SAP MII, for a few moments, the system becomes slow

We review in the SAP Hana Cockpit tool, and we can see some Blocked Transactions, the main blockeds are following: 

We can see this top 3 queries in the tool

1.- UPDATE SFC_ROUTER SET QTY=?
WHERE HANDLE=? 

2.-SELECT MODIFIED_DATE_TIME,
START_DATE_TIME,
STRT,
HANDLE
FROM RESOURCE_TIME_LOG
WHERE RESOURCE_BO=?
AND ACTIVE=? forUPDATE 

3.- SELECT MODIFIED_DATE_TIME,
START_DATE_TIME,
HANDLE,
RESOURCE_STATE,
STRT
FROM RESOURCE_TIME_LOG
WHERE RESOURCE_BO=?
AND ACTIVE=? forUPDATE 

One question, This queries are standard?

Any idea to identify where it is executed from? 

Regards

[andrew_hopwood]

Hello,

Can't be certain, but they look like queries from standard ME.

1) could be SFC Qty Adjust, Split, or release of additional qty for example.

2) and 3) are for updating Resource_Time_log / Resource_Time_Member whenever an SFC is placed in work or removed from work (Start /Signoff  / Complete).Check that Track Resource Time system rule is only enabled on resources where it is needed, and check that you don't have old SFCs left abandoned but active at a resource, and that old RTL/RTM records are getting archived.

Regards,

Andrew.