WRT_8316 The Writer ran out of buffer pool data blocks, terminating the session.

ERROR : 

WRT_8316 The Writer ran out of buffer pool data blocks, terminating the session.

Analysis : 
  • While seeing the storage mount it’s almost occupied and no space left for the session to write the cache.
         Allocate the sufficient storage for your project mount and see the result.
  • While analyzing the mapping design and sesslog we found that transaction control transformation has been used.  Above error is the know bug with Transaction Control Transformation in Informatica 9.1 Hot Fix 4 because the Writer holds onto the Buffer Blocks until a commit is issued. This therefore deprives the blocks for pmdtm, and the session fails as a result.  We would recommend you to have the below possibilities. Since we are on Informatica 9.1 Hot Fix 4,  To resolve this issue  please have the below recommendations as discussed.
1Increase the Buffer Pool Size in the session to accommodate records up to a commit point.

 Reduce the commit interval (so that commit is issued before the blocks are filled) logic with which the TCT generated the commits


This bug has been taken care and applied a fix in PowerCenter 9.1 HotFix 6 OR PowerCenter 9.5.1 HotFix 1 from informatica corp.

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...