RDDEXECL running log time during patch updation

[raj_kumar135]

Hi,

We are applying support packages basis 12,13 ,abap 12,13 and BW and BBPCRM.Initially we got error during basis support package.so we import all the support package through tp command and it completed with return code 4.Now we start the spam to finish the steps but we are finiding in XPRA_Execution phase the job RDDEXECL running last one days in the trans log we find patch BBPCRM - 9 is running.log is not updated yet. so pls suggest what i have to do.

Thanks

Raj

[kuen_cheng]

According with note 1232776, we re-collected statistics for table D010INC and then resolved this issue.

Reason and Prerequisites

The long execution time on the statement mentioned above is generally caused by missing or outdated statistics for the database optimizer so that the optimizer chooses an incorrect access plan. This response was observed on Oracle databases, but may also occur on other database platforms.

Solution

Create optimizer statistics for the table D010INC. When you do this, you must also ensure that the optimizer statistics are regularly created for the other tables.

Note 588668 contains all the information about database statistics for Oracle.

[kuen_cheng]

Hello All,

We suffered the same situation.The SPAM still stay in XPRA_Execution phase for a long time.Any advise will be appreciated!!

Regards,

[Former Member]

Hello Raj,

We are facing the similar problem.

How did you solve it?

Thanks,

Dipita