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.