cancel
Showing results for 
Search instead for 
Did you mean: 

0CO_OM_CCA_9 Delta load performance are very Slow

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for your response.

I Have seen that notes and checked the BWOM_SETTINGS table, all entries are their. That notes didnt help me to improve the Delta data loads.

even tracing in ST04, still not getting enough information for solving the problem.

Thanks

Rupa