Solution : https://service.sap.com/sap/support/notes/417307 (SAP Service marketplace login required)
Summary :
Several performance issues occur due to high load times when uploading data in SAP systems, undeterred by customizing extractor settings via transaction SBIW. Specific settings in ROIDOCPRMS or the scheduler are sometimes ignored by extractors, raising questions about data package size definitions during BW transfers. A general package sizing formula is provided, capped by MAXSIZE and MAXLINES parameters. System-specific override options are available through SBIW in OLTP or in the BW's scheduler, albeit with limitations. Variations exist across applications, and a series of notes provide guidance for tailored settings. Differential handling includes adjusting setup and transfer stages to optimize data loading processes, particularly for larger datasets.
Key words :
business partner standardproduct standardcustomer standardvendor standardplant standardmaterial standard, 2 patch 3lo-lis standardlogistic cockpit sd notes 419465, py standardpa standardre standardisr-cam, fi-fm note 416669ec-pca, -> utilities -> runtime object -> table length, solution application/datasource standard settings, 423118logistic cockpit mm-im, note------------------------------------------------------------------------generic extractor standard, -om note 413992ps standard, note 413992co-pc standardfi
Related Notes :
| 1597364 | FAQ: BW-BCT: Extraction performance in source system |
| 662652 | SAP-GP: Hierarchy extraction without BW adapters |
| 641977 | Poor performance |
| 639072 | CRM/BW parallel proc. for extracting business transactions |
| 610938 | Error 7 during transfer of an IDoc into BW |
| 605620 | Delta update has poor performance |
| 601362 | BW Ext. 0CO_PC_ACT_10: Dump TSV_TNEW_PAGE_ALLOC_FAILED |
| 589997 | SYSTEM_IMODE_TOO_LARGE dump during update from LBWQ |
| 585750 | RMCBNERP: SELECT on table CKMI1 is very slow |
| 583276 | BCT-CO delta DataSources: poor performance in PI2002.1 |
| 574714 | BW extraction 0FI_GL_4 blocks online transactions |
| 567747 | Composite note BW 3.x performance: Extraction & loading |
| 567169 | BP group hierarchy for BW: Performance improvements |
| 553727 | Extraction 0FI_GL_4: Data is missing |
| 550936 | GP group hierarchy: Reorganization of a hierarchy in BW-A |
| 549808 | Performance of extractor 0FI_TX_4 |
| 549184 | FAQ: What is important for extraction |
| 543145 | Memory overflow in the kernel |
| 538729 | Bad performance |
| 537235 | Statistical data setup - Performance for access on CKMI1 |
| 534608 | Poor performance and high memory requirement |
| 526439 | Time data extractor: Performance gets worse per package |
| 522986 | CO extractors: Packages are too large |
| 522006 | PSBW: Performance during extraction of costs |
| 482494 | Loading data from liveCache: Performance optimization |
| 454267 | 2LIS_03_BF:TSV_TNEW_PAGE_ALLOC_FAILED durng BW loading proc. |
| 444773 | Dump with delta extraction business partner texts |
| 438364 | Initial download for CRM product: Performance improvement |
| 423118 | Extractors SD: Data package size |
| 420947 | Bad performance at FI-SL extractor |
| 419465 | Insufficient memory during delta initialization |
| 416669 | Package size in the extractor is smaller than it should be |
| 413992 | CO-OM Extractors: Data packet size |
| 410958 | BW extraction 0FI_AR_3/0FI_AP_3: Package size and performanc |
| 409641 | Examples of packet size dependency on ROIDOCPRMS |
| 397209 | BW: Packaging DataSources of time management |
| 392635 | Information: Sources with BW extraction from the CO-PA |
| 380078 | FAQ: BW delta queue (RSA7): Questions and answers |
| 213083 | Packet size too small w/ EC-PCA + FI-SL extraction |
| 210219 | Performance when updating SAP BW from CO-PA |
| 165504 | Loading R/3 data uses too many work processes |
| 157652 | Main memory requirement for extraction from R/3 |
| 130052 | BW extr: Packet size too large (FI-SL-InfoSource) |