Resolve error "COleException: Not enough storage is available to complete this operation" in Sagent Data Flow


While running a plan from Sagent client(Weblink/Design Studio), COleException error is thrown.
"Not enough storage is available to complete this operation"

 User-added image


The user is trying to display more than 3 lac records in Excel Sink. This is a known problem with MS Excel.

This problem is caused by the limitation in the remote procedure call (RPC) layer where only 256 unique interfaces can be called from one process to another. This problem typically occurs when you use COM+ or Microsoft Transaction Server with many objects in the program or package.

This is explained in an MS KB article.

Click here for more details.


UPDATED: November 20, 2017

To resolve this issue, use either of mentioned options:
  • Split up the records. Use of Filtered Splitter transform is one of the choices. You can also change the logic of workflow to split the displaying records. 
  • Or save data in the file on disk.

Environment Details

Product Feature: Weblink Client, Design Studio



  • No Downloads