Skip to Content

Sales Statistics missed delta - reload


We have missed some delta records in DS:

0UC_SALES_STATS_02. So after referring the blog: I had followed the steps by doing Full and then checking the DBESTA_BWTRIG table, and then running the EBW_DQ_SS Job. But this job is taking very long time to run. I have to cancel this job. By cancelling this job, what will happen to the trigger in the DBESTA_BWTRIG table? Will I still get my lost data back by re-doing this steps by selecting smaller range of dates this time?

Please suggest.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Nov 07, 2018 at 12:03 AM

    Firstly, the cancallation won't cause the data missing.

    Secondly, please check if the following notes can be applied in your system:

    2636555 - INV: Performance when writing BW triggers (DBESTA_BWTRIG)
    2616235 - INV: Performance during writing of the BW trigger (DBESTA_BWTRIG)
    1995623 - BW: Data extracted too often for 0UC_SALES_STATS_01
    1964400 - BW: Parallel Extraction of sales statistics into BW and BODS
    2441213 - BW: IS-U tables are locked during extraction of sales statistics data with ODP

    Best regards,

    Add comment
    10|10000 characters needed characters exceeded