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

Long Running Master Data Transport

Hello BW experts,

We have a Masterdata info object with 20 attributes. Now added about 200 attributes and made most of them as NAV attributes. When we sent the transport to QA system it took about 40 hours to complete. We deleted the unused masterdata from target systsem before the tranport but not all of it as it was still in use in some data targets.

Now wondering if anyone has experience transporting such master data with huge number of attributes and are there any database or use settings that needs to be changed to make this reduce the transport times. Appreciate any help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 20, 2012 at 02:49 AM

    I dont think there is any way to make it faster .. things that you could try can be :

    What is basically happening is that when the transport is being sent through - it is adjusting the P , Q , X , Y tables and regenerating all the master data to check the consistency ( and of course deactivating any transformation that uses the read master data )

    What are the sizes in records of your X and Y tables in particular ..?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2012 at 03:05 PM

    Okay, this might be a massive help to anyone having the same issue. SAP has released a note (Note 1466536 - Long runtimes when transporting InfoObjects) valid since 26.05.2011.

    Basically, this note will make the indexes are deleted by default in the database before the XY-table is rebuilt and they are created again after the table is successfully rebuilt.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2012 at 04:01 PM

    a good trick can be ( if possible in production ) to delete data before to transport and after reloading

    Add a comment
    10|10000 characters needed characters exceeded

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.