Settings
This page contains an overview of the settings in the Xtract Table CDC component.
To open the settings, click Settings in the main window of the component.
Extraction Settings
Package size
The extracted data is split into packages of the defined size. The default value is 50000 lines.
A package size between 20000 and 50000 is advisable for large amounts of data. 0 means no packaging. Not using packaging can lead to an RFC timeout for large data extractions.
Warning
RFC_ERROR_SYSTEM_FAILURE - No more storage space available for extending an internal table
To avoid a memory overflow on the SAP source system and to avoid huge overheads, choose a package size that suits your memory capacity.
Background Job
Use background jobs for long-running extractions that process large data volumes and may run into a timeout error ("Time limit exceeded"). Background jobs bypass the SAP timeout limit, but they incur more overhead and require more SAP resources. Overall extraction time is longer for background jobs.
Background jobs are only supported in combination with the custom function module THEO/READ_TABLE.
Mode
- None, dialog mode only: All data extractions are executed as a dialog job in SAP (default). When extracting large amounts of data you may run into a timeout error.
- Background mode only for initial load: The initial table extraction is executed as a background job in SAP. This option only applies if the checkbox Extract table on first run is active in the main window. Subsequent delta extractions are executed as dialog jobs.
- Background mode for both initial and delta loads: Both initial and delta extractions are executed as a background job in SAP.
Tip
Extraction jobs are listed in the SAP JobLog (SM37) under the JobName theo_read_table.
Warning
Shared Memory ran out of memory!
If this error appears when running a background extraction, increase the Shared Memory size. SAP recommends 800MB~1.5GB for production or test system and 2GB~4GB for S/4 systems, see SAP Support: How to solve SYSTEM_NO_SHM_MEMORY runtime error.
Timeout (seconds)
Sets a timeout period for extractions that run in background mode.
The default value is 180 seconds. The maximum timeout value is 3600 seconds.
Note
The background job timeout setting only takes effect if the extractions run in background mode using /THEO/READ_TABLE.