SAP SLT – table in status: ‘Calculate Access Plan blocked’

Sometimes in transaction LTRC is possible to observe that a replicated table has a status like on screen below:

Solution

1. Go to transaction LTRC | Expert Functions | ‘Reset Load and Replication Status’
2. Fill in the Mass Transfer ID
3. Put in the table name
4. Uncheck the boxes under the ‘Reset Status’
5. Check the box next to ‘Reset “Blocked Data Trans.” flag’
6. Click Execute

Now the table is processing:

Useful KBA 2254376 – SLT trigger(s) in an inconsistent state