Solution : https://service.sap.com/sap/support/notes/1597364 (SAP Service marketplace login required)
Summary :
This SAP Note addresses various performance problems related to data extraction from the BW source system, including modules like LO, FI, HR, and CO. Issues stem from misconfigured parameters or data source-specific settings across application components. Key solutions include optimizing BW data load package sizes, setting correct parameters in ROIDOCPRMS table, proper setup in SMQS for tRFC scheduler, managing large table sizes especially for tRFC, qRFC, and IDoc processing, and optimizing job and data package configurations for effective extraction. Further, extensive references to other SAP Notes provide detailed steps for resolving specific technical configurations and performance enhancements.
Key words :
bw-sys-db bw database platformsbw-whm-dst data stagingsv-bo-bi business information priority recommendations / additional info category faq validity, components bc-bw bw service apibc-mid-rfc-qt queued rfc, delta mode 67014 reorganizing update requests 332677 rebuilding fragmented indexes 313454 info, customer component bw-bct-gen standard bi content - components, delta mode 332677 rebuilding fragmented indexes 313454 info, transaction sbiw -> general settings -> maintain control parameters, qt statistcs tables 641977 poor performance 787713 performance problems, __%pdfstyle%__ / } symptom poor performance, cosp/coss extractor performance 1599602 faq, cosp/coss extractor performance 1280898 idoc hangs
Related Notes :
| 1831594 | 2LIS_13_VDKON: condition extractor in collective billing run |
| 1599602 | FAQ: BW system performance |
| 1531175 | |
| 1474938 | |
| 1432022 | |
| 1424403 | BW-BCT: Performance when using CO line item extractor |
| 1404736 | |
| 1392817 | |
| 1333417 | Performance problems when processing IDocs immediately |
| 1312060 | BW-BCT-CO-OM: COSP/COSS Extractor performance |
| 1280898 | |
| 1163359 | Load methods using SMQS or SAPI-controlled to transfer to BW |
| 1095411 | BIAC: Reduction in Data volume in QT Statistcs Tables |
| 1056245 | |
| 916706 | Number of dialog processes for data transfer |
| 892513 | Consulting: Performance: Loading data, no of pkg, req size |
| 856148 | |
| 836740 | Delta extractors CO: OBJSELSIZE DataSource specific |
| 815638 | |
| 798536 | Possible performance problems after use of PI_2004_1 |
| 787713 | |
| 760973 | |
| 755977 | ST12 "ABAP Trace for SAP EarlyWatch/GoingLive" |
| 753654 | How can downtime be reduced for setup table update |
| 696838 | |
| 641977 | Poor performance |
| 578417 | BCT-CO: CO-OM delta DataSources: Executing the DeltaInit |
| 561880 | Requests hang because IDocs are not processed |
| 549552 | CO line item extractors: performance |
| 513454 | REP: High-performance operation with change pointers |
| 437672 | LBWE: Performance for setup of extract structures |
| 436393 | Performance improvement for filling the setup tables |
| 423118 | Extractors SD: Data package size |
| 417307 | Extractor package size: Collective note for applications |
| 416265 | BCT-CO delta DataSources: Technical background information |
| 409641 | Examples of packet size dependency on ROIDOCPRMS |
| 407125 | Poor performance of Q and TRFC on ORACLE |
| 382329 | Delta extractors CO: Poor performance |
| 375566 | Large number of entries in tRFC and qRFC tables |
| 353177 | |
| 332677 | Rebuilding fragmented indexes |
| 313454 | Info: Default value for settlement type |
| 210219 | Performance when updating SAP BW from CO-PA |
| 74141 | Resource Management for tRFC and aRFC |
| 67014 | Reorganizing update requests |