Attribute Change run Performance issue

[Former Member]

Hi All,

We are facing issue with attribute change run and it is taking more time(3 to 4 hours) to complete in Production system.

Can you please suggest us to fix this issue.

Thanks

Sudhakar

[Former Member]

Hi

Please consider number range buffering for your master data loads and attribute change runs

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a6e3ff-f000-2d10-b59d-8ef35e248...

Thanks

[Former Member]

Hello,

check the block size in RSCUSTV8.

As per the system response one can increase this delta limit till you get minimum timings on ACR process. This depends upon system to system but ideal limit is 20.

Block size is use to prevent overflow of temporary tablespace i.e. PSATEMP. This is used if E table or F table of Infocube is larger then the Blocksize then source to update aggregates will not be read at once rather divided into blocks. Ideal size of blocksize is 999999999

steps to follow:

1. First Make sure you’re ACR got stuck

2. Identify the aggregate.

3. Kill ACR Job

4. Deactivate the aggregate manually

5. Restart failed ACR

6. Wait for ACR to finish

7. Activate deactivated aggregate

Regards,

Priya M

[Former Member]

hi Sudhakar

check the data load whether  it is doing a full load or delta load. make it delta if possible.  also check the load size, if it is big check if you can load it to transnational data target like DSO. also, you can enable parallel processing in the process chain variant and increase background jobs to finish it faster.