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.