Skip to Content
author's profile photo Former Member
0
Former Member

Convert BP Status to BP Roles

Posted on Oct 13, 2010 at 07:30 AM 13 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2010 at 11:43 AM
    1

    Hi,

    May be this note help you:

    Note 1121015 - Time out when running report CRM_BUPA_USERSTATUS_CONV2ROLE

    Denis.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 13, 2010 at 01:08 PM

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.