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

Unable to load master data attributes from DSO

Hi Gurus,

I am unable to load data from standard DSO to Master Data Attributes (BI 7.3). below are the details:

1) DSOs Active table have 6M records and change log table have around 130M records.

2)Data loading was through a daily Delta Process chain which was loading data fine but 3 months back i unscheduled it and hence last 3 months data got accumulated in DSO (Frequency was around 2 M daily).

3)Now I rescheduled the that daily delta PC but it was unsuccessful with Table Space issue. So we extended the PSAP Temp table size from 10 to 44GB.

4) I tried to Full load and it happened and now we need to do Initialize the source.

5)The issue here is INIT isnt happening. Itried with both the options available in DTP and that are:

a) Extraction tab :--> Delta Init without Data

b) Execute :--> Processing mode -> No data transfer delta status in source fetched.


Please help me with this init thing else please walk over through any other way to load that 3 months of data.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 09, 2014 at 10:19 AM

    Hi Vedant,

    As you have no time related objects to split your data then it will be very difficult to load data in batches.

    Try this Option: "GET ALL NEW DATA REQUEST BY REQUEST" in DTP. This option helps you load large number of records.

    When you are loading change this option also:

    GOTO -> Setting for Batch Manager -> No. of processes -> Change it to 6.

    And try all these option when system resources are maximum free (Basically in weekend).

    Thanks & Regards,

    Vipin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 07:58 AM

    Hi

    While running init with out data transfer, are you getting any error or any messages, if yes please share here.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 08:14 AM

    You stooped that process chain 3 month back and now you starting again it means data is still there in RSA7 for last 3 months you need to run delta in IP then run the DTP with delta only it will get all the delta records in the data target.

    Regards,

    SM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 08:19 AM

    Dear Vedant

    Check the no of lock entries in SM12 while doing the init without data transfer and check whether the no of locks are not exceeding the limits.

    Regards

    Gajesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Which every key cominations you have, try to split based on it and load the data.

      Other wise there is no other option except running during weekends, make sure resources available during execution time.

      If possible stop other process for time being until this gets finished during weekend .

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.