Skip to Content
Author's profile photo Kamal Mehta

0MAT_PLANT_ATTR – Not Picking Any Delta

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.




Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      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

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog 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

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Great Job 🙂
      Thanks for sharing 🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks for your comments.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Nice one.. 🙂 Bookmarked it..

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author
      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice one and grate work.... 🙂

      Regards,

      SM

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Satendra.

      Regards

      Kamal

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Good one ...

      Thanks for sharing 🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Prashant.

      Regards

      Kamal

      Author's profile photo Martin Grob
      Martin Grob

      intresting a bit specific but good to know thanks

      Martin

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Martin for your comments........

      Author's profile photo Former Member
      Former Member

      Good job Kamal!!!

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Chetan...

      Author's profile photo Former Member
      Former Member

      Hi, Kamal,

      Nice one, Thanks  for sharing valuable information.

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks for your comments.

      Regards

      Kamal

      Author's profile photo Former Member
      Former Member

      Good one.