Solution : https://service.sap.com/sap/support/notes/1597364 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette Note SAP traite de divers problèmes de performance liés à l'extraction de données du système source BW, incluant des modules tels que LO, FI, HR et CO. Les problèmes proviennent de paramètres mal configurés ou de configurations spécifiques aux sources de données à travers les composants applicatifs. Les solutions clés incluent l'optimisation de la taille des paquets de données de chargement BW, la configuration correcte des paramètres dans la table ROIDOCPRMS, le bon paramétrage dans SMQS pour le planificateur tRFC, la gestion de la taille des grandes tables, notamment pour tRFC, qRFC et le traitement IDoc, et l'optimisation des configurations de travaux et de paquets de données pour une extraction efficace. De plus, de nombreuses références à d'autres Notes SAP fournissent des étapes détaillées pour résoudre des configurations techniques spécifiques et améliorer la performance.
Mots Clés :
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
Notes associées :
| 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 |