Sales Statistics missed delta - reload

[former_member1307088]

Hi,

We have missed some delta records in DS:

0UC_SALES_STATS_02. So after referring the blog:

https://wiki.scn.sap.com/wiki/display/UIndustry/How+to+reload+Data+to+0UC_SALES_STATS_02 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.

[maggie_yi]

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,
Maggie