Share via

  • Article

DTS_E_READNOTFILLEDCACHE

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-1073675771

Event Source

SSIS

Component

Integration Services 

Symbolic Name

DTS_E_READNOTFILLEDCACHE

Message Text

The cache is being written to by __, and cannot be read by __.

Explanation

A Lookup transformation is trying to read data from the in-memory cache at the same time that a Cache Transform transformation is writing data to the cache.

The hexadecimal value for this error number is 0xc0010205.

Possible Causes

There are multiple data flows. In one data flow, a Lookup transformation uses a Cache connection manager to load a reference data set from a cache file (.raw) into the in-memory cache. In the other data flow, a Cache Transform transformation is writing data to the same Cache connection manager. The data flow that contains the Lookup transformation is trying to access in-memory cache at the same time as the Cache Transform transformation.

User Action

Use a precedence constraint to connect the data flow that contains the Cache Transform transformation to the data flow that contains the Lookup transformation. A precedence constraint ensures that the data flow that contains the Cache Transform transformation finishes before the data flow that containsthe Lookup transformation runs.