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

Fill Internal Header Table for Table VBUK corrupted

Posted on Jul 27, 2010 at 06:55 AM 47 Views

Hi all

I had Cluster on each table ( VBUK, VBFCL... )

SP13 all need notes are implemented,

Parameter P_ROLL = 'X'

P_CUST = 'Y'

but system dumpt all 6 hours Remote error

one question does für VBUK fill also gave a Paramter p_full ?

thanks for feedback or other inputs

L

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo SUMAN P R Padubidri
    SUMAN P R Padubidri
    Posted on Oct 11, 2010 at 08:20 AM
    1

    Hi,

    @Sri: In case of Lou, it is indeed not possible to create an index on VBFA since it is a cluster table. This in turn leads to access of the VBFCL cluster which was known to have performance issues. This is the reason VBFA was shipped as a transparent table later on.

    @Lou: If possible, you can convert the cluster table to a transparent table on which indexes can be built to speedup the process. But yes, this takes quite some time. You can refer to note 77282 for the conversion process. So once you have converted VBFA to a transparent table, it would be possible to create the secondary indices and hence bring about considerable improvement in the performance of the activity.

    Best Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Sunny Pahuja
    Sunny Pahuja
    Posted on Jul 27, 2010 at 09:53 AM
    0

    Hi,

    Have you executed below settings as per operation guide ?

    When you start working in the phase u2018Data Transferu2019 (which means that this phase

    is the technically active phase), set parameter u2018P_CLUu2019 to u2018Yu2019 in the following

    activities before you start the activities for filling internal header tables:

    �� TD05X_FILL_BKPF

    �� TD05X_FILL_CE

    �� TD05X_FILL_EKKO

    �� TD05X_FILL_VBUK

    �� TD05X_FILL_VBUK_1

    �� TD05X_FILL_VBUK_2

    �� TD05X_FILL_VSRESB

    �� TD05X_FILL_WBRK_1

    You can do so by placing the cursor on each of these activities, then using the

    Troubleshooting button and executing activity 'Adjust parameter for excution in

    Troubleshooting treeu2019. Then you get a list of possible parameters for the

    activity. Set P_CLU to Selection value low = Y

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Oct 10, 2010 at 11:31 AM

      TDMS experts:

      I remember that I indeed created an index for VBFA per that famous OSS note.

      However because I have changed to a different project so that I cannot verify.

      Additionally, this link also almost explicitly says that index on VBFA is feasible:

      performance-issue-during-td05xfillvbuk2-and-time-o

      So why in the previous posting Lou says:

      1256679 -> VBFA is a cluster table, i can't create a Index ...

      I appreciate if you experts can share your experience on this.

      Regards!

    Comment on This Answer

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.