cancel
Showing results for 
Search instead for 
Did you mean: 

RSA1 taking long time for execution .

Former Member
0 Kudos

Dear Experts,

When execute t.code RSA1,it is taking long time.please help to solve,(win 2008,NW 7.3)

Warm Regards,

Prabaharan B

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Prabaharan,

 

Is your extraction mode perhaps set to full?

 

Note 1788303 - Increasing runtimes during quality validation

 

Also follow note

 

Note 1599602 - FAQ: BW system performance

 

Johan

Former Member
0 Kudos

Dear Prabaharan,

often the RSA1 long time execution depends on some SourceSystem not available.

Try to run RSA1_OLD too.

Please check this action, and return us a feedback.

Regards,

Cristian

former_member182034
Active Contributor
0 Kudos

hi Dear,

You need to investigate the root cause with the help of ST05 and then You can resolve this issue.

You also need to monitor the table/report via SM50 and get the cause of slow speed of RSA1.

have a look at sap note:859683


Regards,

Former Member
0 Kudos

Hi,

Thanx for your replay.checked at sm50.it is running so long.

WR,

prabaharan B

former_member182034
Active Contributor
0 Kudos

hi Prab,

You just check the root cause with the help of ST05. Please active the filter as mentioned below before execute the RSA1.

Regards,

Former Member
0 Kudos

hi abdul,

Right now,i can execute RSA1.I am only able to execute.plz help to resolve permently.

WR,

prabahartan B

former_member182034
Active Contributor
0 Kudos

Dear,

When the execution of RSA1 is completed then click on Deactivate Trace and you can check the result after click on Display Trace. Now you get to know the table or sql statement which are taking time. would you share the result of Display Trace.

Regards,

Former Member
0 Kudos

Hi,

 

Check for jobs running in sm50, sm37. sm66 may be some locks are keeping job.

In sm37 to status check for the active job.

 

Check in sm12. Also check your provider logs right click on any provider and in additional functions > Display Logs. Remove all selections and see for errors

 

View the dev_w* trace file of the relevant process for any errors.

Check for any entries for user running job in sm21/st22.

Maybe check this also:

1531783 - Index creation Jobs on Infocubes run for a long time

 

When last was db statistics processed?

 

Johan