3774102 - Replication Flow with ABAP SLT source system stuck on initial load partitioning with "work order timed out in 12 minutes"

• Replication flow remains in state "initial load partitioning".
• Error message: "work order timed out in 12 minutes".
• Error: WORK_ORDER_TIMEOUT.
• Observed only during large-volume initial load; small sample load succeeds.

• Product: SAP Datasphere
• Replication Flow with ABAP SLT source system

1. Set up a replication flow from an ABAP-based on-premise source via SLT to a target database and start an initial load for a large table.
2. Observe that the run remains in "initial load partitioning" and ends with "work order timed out in 12 minutes" (WORK_ORDER_TIMEOUT).

• In case of large source table, the access plan generated an excessively high number of partitions (far above what the runtime can process in parallel). Only up to 80 partitioning jobs are processed concurrently; creating far more partitions adds overhead and can cause a single partitioning work order round trip to time out, resulting in WORK_ORDER_TIMEOUT during the initial load partitioning phase.
• No default cap for RMS_MAX_PARTITIONS was set, allowing the access plan to create too many partitions.

1. Pause the affected replication flow before changing the parameter (to avoid restarting from scratch), then resume the replication flow after the change.
2. In the ABAP backend, set a default value for the runtime parameter RMS_MAX_PARTITIONS to 80 (transaction SM30), refer to: 3260185 - ABAP Data Integration - Runtime Parameters (DHBAS_RUNTIME / LTBAS_RUNTIME).
3. Restart the initial load and confirm that the flow progresses beyond "initial load partitioning" without WORK_ORDER_TIMEOUT.
4. If issues persist, review authorizations and required technical jobs as referenced below, then retest.

• Refer to: KBA 3487621 - Replication Flow fails: "No source partition is available" due to Subscription authorization issues
• Refer to: Note 3561739 - ABAP Data Integration - Technical Jobs
• Refer to: State: Partitioning initial load # Operation:0
• Refer to: 3260185 - ABAP Data Integration - Runtime Parameters (DHBAS_RUNTIME / LTBAS_RUNTIME)

initial load partitioning, work order timed out in 12 minutes, WORK_ORDER_TIMEOUT, replication flow, abap slt, bigquery, partitioning timeout, rms_max_partitions, large table load, access plan, partitions, parallel jobs limit, datasphere data integration, initial load stuck, timeout , KBA , DS-DI-RF , Replication Flow Runtime , Problem