Skip to Content

Issue Description : Standard Data source 0MAT_PLANT_ATTR is not Picking any Deltas in Production system and giving memory dumps in source system.  In BW Delta Queue using transaction RSA7 in ECC system there are no records when the Delta Info packages are executed in BW and its causing memory dumps as “TSV_TNEW_PAGE_ALLOC_FAILED” in source system.

This type of dump can occur due to tables BDCPV and BDCP2 which may have many entries. Let’s closely look at this.


BDCP2 has 55 million entries and table BDCPV 6 million entries.

Table BDCP2 contains over 55 million entries.

/wp-content/uploads/2013/10/1_291527.jpg


Table BDCPV contains over 6 million entries.

     /wp-content/uploads/2013/10/2_291528.jpg

To clean down these entries the report RBDCPMIG_ALL_WITHOUT_MIG_FLAG needs to be run and then the report RBDCPCLR needs to be executed.     

RECOMMENDATION:

1. Schedule report RBDCPMIG_ALL_WITHOUT_MIG_FLAG to migrate all the Change Pointers for different message types.

2. After migration you should delete all change pointers with processed flag. Use report RBDCPCLR without test mode and option ‘processed change pointer’.  

3. For various message types  sometimes we see a lot of not processed change pointers and no processed change pointers. Sometimes it’s a sign that they have been activated by mistake. So please cross check this If they are not needed delete them using RBDCPCLR and use the obsolete option. Then deactivate message types that are not needed.

Thanks for reading.




To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

  1. Raman Korrapati

    Hi kamal,

    Really helpful and very nice explanation. I think this may needs add to housekeeping activities topic. because we may receive rarely this kind of error “TSV_TNEW_PAGE_ALLOC_FAILED”.

    Request : please change blog headings than 0mat_plant_attr. its not specific to data source. its specific memory allocation. so use error description(TSV_TNEW_PAGE_ALLOC_FAILED)

    . it would be more useful and easy to search thru error description.

    Thanks

    (0) 
    1. Kamal Mehta Post author

      Hi Raman,

      Thanks for your valuable comments.

      Yes, if this can be added to Housekeeping it would help. Very often we get dumps related to “TSV_TNEW_PAGE_ALLOC_FAILED‘. However, this is not specific to this dump.

      Thanks

      (0) 

Leave a Reply