VERIFIED SOLUTION i
X

Resolve cache blocks utilization exceeds 'Maxblocks' parameter in Sagent

Issue

While running same plan from two different machines on Weblink/Design Studio, the cache blocks used exceeds the 'Maxblocks' parameter and still the plan completes successfully.

User-added image

Cause

When the plan is already running and the used cache blocks becomes over the value of 'MaxBlocks', the plan still continues to run. In this case, if the spilling of cache results is ON then the cache blocks can be spilled.

Once the used cache blocks exceeds the value of 'MaxBlocks' parameter and the plan execution is started again, 'Unable to execute plan. The Data Flow Service cache is full. Please try again at a later time' error is encountered.

Resolution

UPDATED: November 2, 2017


This is a designed behavior and the resource used for extra caching during plan execution is the virtual memory for Dataflow server specified using 'AgentVMMemory' parameter.

Environment Details

Product Feature: DataFlow Server

Downloads

  • No Downloads