VERIFIED SOLUTION i
X

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

Issue

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

Cause

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.

Resolution

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

 

Downloads

  • No Downloads