Background Job RSPPFPROCESS Taking too long to execute.

[Former Member]

Hi Gurus,

I'm working with SAP CRM 2007 - Interaction Centre

We have configured first response date and to do by date in item category.

If agent fails to response within the first response date or if agent fails to complete

to close the ticket within the to do by date,An action is configured to trigger and an

escalation email(Smart Form) is sent to agent`s manager inbox.

We have scheduled background job for the program RSPPFPROCESS with variant in background

to trigger this actions( It is scheduled 4 times in a day ).

Previously this job used to take 6 hours to complete execution.

But now its taking 12 hours to complete the execution and there is no change in the

variant.

Can anyone please advice me reason for this behavior.

Kind Regards,

Vinod

[sumaira_gopalani]

This message was moderated.

[sumaira_gopalani]

Hi Vinod,

We were facing the same issue then we tried  optimization rule in action profile and observe pretty much difference afterwards.

Did you try that?

[Former Member]

Hello,

when we changed from CRM 5.0 to CRM 7.0 we faced the same issue.

Today we are using our own report ZRSPPFPROCESS.

In debugging you will find out the performance critical step.

Regards

Manfred

[madeline_poh]

Hi Manfred,

We are experiencing similar performance issue when running the RSPPFPROCESS Job. We opened a OSS message for quite some time but didn't get any useful help from SAP.

Can you please provide more information regarding your ZRSPPFPROCESS program on identifying the crtical performance steps to resolve the performance issue? We are also thinking of archiving the record in table PPFTTRIGG , we have over 73+ millions records in the table but there is no archiving object for PPF actions. We would like to focus on reducing the number of entries in the table PPFTTRIGG hopefully to improve the performance. Any thoughts on it?

Thanks in advance for your kind help!

Best Regards,

Madeline