Skip to Content

Delta 0MAT_PLANT_ATTR dumps on table bdcp2

Hi all,

i have a problem with this extractor and i can't solve it.

I delete the init from BW and launch a new init without data trasfer, then when i try my first delta load the R/3 job ends with errors due to a dump in table bdcp2 (TSV_TNEW_PAGE_ALLOC_FAILED), RSA7 there are no records in the queue.

I couldn't find a sap note of some help, do you have any suggestion?

Thanks

Stefano

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2010 at 03:03 PM

    Hi,

    This is not related to your datasource but a memory issue.

    Please ask your basis team to check that there is enough free memory.

    -RMP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2010 at 03:08 PM

    Hi,

    This is a very common memory issue. The system is not able to allocate memory for storing more data in the internal table.

    Please contact the BASIS guys in your team and ask to change the parameters for heap memory in system.

    Also, the below thread should be helpful to you.

    dump TSV_TNEW_PAGE_ALLOC_FAILED

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Alex,

      there is no way to reset the change pointer status to let the delta select only the records modified from today?

      EDIT: i want to add, i've done some tests in quality, yesterday i've run the delta several times and i was pulling from R/3 always 2649 records, today i've loaded a new delta and the same 2649 have been loaded, i think there's something wrong, today i didn't expect the same data in the delta load...

      Regards

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2011 at 07:03 PM

    Hi all,

    did you solve your problem? I actually have the same issue in my productive system.

    I have 3.5 Mio Change Pointer in my BDCP2 table for 0MAT_PLANT. A Delta load lead to the same out of memory dump as you have mentioned.

    I do not want to change any system parameters I just want to get rid of those 0MAT_PLANT entries in BDCP2.

    Using transaction BD22 only deletes entries from BDCP and BDCPS. Isn't there a way to delete these entries in BDCP2 even if they are not outdated or processed yet?

    Regards

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 12, 2011 at 05:05 AM

    I had same issue recently. opened up SAP OSS and was directed to apply SAP Note 1037679-Short dump in source system during

    master data delta update

    check sap note 170183

    The following DataSources are affected:

    DataSource comparison value to be used

    0ARTICLE_ATTR i_chabasnm_cmp = '0MATERIAL'

    0ART_PLANT_ATTR i_chabasnm_cmp = '0MAT_PLANT'

    0ART_SALES_ATTR i_chabasnm_cmp = '0MAT_SALES'

    0ART_ST_LOC_ATTR i_chabasnm_cmp = '0MAT_ST_LOC'

    0ART_UNIT_ATTR i_chabasnm_cmp = '0MAT_UNIT'

    0MATERIAL_ATTR i_chabasnm_cmp = '0MATERIAL'

    0MAT_PLANT_ATTR i_chabasnm_cmp = '0MAT_PLANT'

    0RT_MAT_PLANT_ATTR i_chabasnm_cmp = '0MAT_PLANT'

    0MAT_SALES_ATTR i_chabasnm_cmp = '0MAT_SALES'

    0MAT_ST_LOC_ATTR i_chabasnm_cmp = '0MAT_ST_LOC'

    0MAT_UNIT_ATTR i_chabasnm_cmp = '0MAT_UNIT'

    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.