Convert BP Status to BP Roles

[Former Member]

Hello experts,

We are trying to use the CRM_BUPA_USERSTATUS_CONV2ROLE report to convert the BP status to a BP Role for 11.000.000 entries and we are facing some very serious problems.

Like "Lock Table Overflow", VERY slow, all the other jobs are delaied... etc.

When we used the report at the DEV our entries were very few and it didn't cause any problem.

Has anyone ever faced similar problems when using this report????

Thank you in advance

Michalis Tamiolakis

[Former Member · Accepted solution]

Hi,

May be this note help you:

Note 1121015 - Time out when running report CRM_BUPA_USERSTATUS_CONV2ROLE

Denis.

[Former Member · Accepted solution]

Hi Denis,

Thanks for the reply.

Unfortunately the note you mention works for a previous version.

We run the report at the background and it still "breaks down" the whole crm.

We tried to run the report for only 2 BPs.

It took 40 minutes to update this 2 BPs

It looks like it selects all the partners first and then tries to update them...

SAP CRM 6.0 2007

SAPKU60005

Thanks anyway

Michalis