on 02-24-2010 10:17 PM
Dear Gurus,
I am extracting data from 0CO_OM_CCA_9, for full uploads / full repair the extraction is fast, but for delta loads its taking more than 3 horus. I have checked all the available notes, nothing helped me to improve the extraction performance on delta loads, I have checked R3 Table indexes all are exists as per the available notes.
Please help me out.
Thanks
Rupa
Hi Rupa,
Please check the below:
CO delta extractors: poor performance for Deltainit
SAP Note Number: 387964
Symptom
During the extraction of data from the R/3 System into the BW System by using DataSources 0CO_OM_CCA_9, 0CO_OM_OPA_6, 0CO_OM_ABC_7, 0CO_OM_WBS_6, 0CO_OM_NAE_2 and 0CO_OM_NWA_2 performance problems occur in the Delta Init mode.
Additional key words
0CO_OM_CCA_9, 0CO_OM_OPA_6, 0CO_OM_ABC_7, 0CO_OM_WBS_6, performance
Cause and prerequisites
This problem is caused by a database access which is not optimal
Solution
1. First of all, check whether a full update runs faster than a Delta Init update. Only then this note is relevant.
2. As of PI 2001.1, you can skip the implementation of the following corrections and continue with step 5, the maintenance of table BWOM_SETTINGS.
3. Implement - if not yet available in the system - the source code corrections attached to this note.
4. Implement - if not yet available in the system - the supplement corrections of Notes 399123, 432715 and 457317 a.
5. Now you can activate the optimization via the maintenance of table BWOM_SETTINGS.This makes the system select from the database in both delta init and full update and this should result in the same runtime as in the full update.
a)Create an entry (if itdoes notyet exist) in table BWOM_SETTINGS by using Transaction SE16, key fields
OLTPSOURCE = ' '
PARAM_NAME = 'NOTSSELECT'.
Alternatively you can run any of the affected extractors with any selection criteria by using Transaction RSA3, in this case the system generates the entry automatically.
b) Use Transaction SE16 to change the value in column 'PARAM_VALUE' for the above-mentioned entry of table 'BWOM_SETTINGS'to 'X'. The following applies:
PARAM_VALUE = ' ' Access as delta update
PARAM_VALUE = 'X' Access as full update
-Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.