The repository cache size is too small for your packages. You can
increase the cache size to prevent this from happening. There was a
registry hack that could be used with SQL 7 to increase the size. The
registry keys are at:
HKEY_LOCAL_MACHINE\Software\Microsoft\Repository\Engine
The keys are MaxRelEntriesSize, MaxRelColCacheSize, MaxRelRows,
VersionCacheLimit
All are all DWORDS with a default of 65534. They can be set to the max
value of a signed int.
And that's about all I remember about it. You could hit the issue with
a large number of versions for a package. If you are on 2000, I
thought that the keys didn't exist but that you can create them. Can't
remember all the specifics - maybe someone else who remembers will
jump in.
-Sue
On Thu, 30 Sep 2004 08:05:05 -0700, "V" <V@discussions.microsoft.com>
[quoted text, click to view] wrote:
>Hello Sue,
>
>Thank you very much for your response, this really helped me out. In the end
>I had to delete quite a few versions of the DTS before I could delete the
>whole package. There was probably a few corrupt versions in there. The error
>I was getting before I could delete the entire package was the following:
>
>C:\>DTSRun /S "Server" /U "user" /P "pass" /N "Data Transfer" /R "." /G
>"GUID" /!D
>DTSRun: Loading...
>DTSRun: Executing...
>
>Error: -2147217296 (80041070); Provider Error: 0 (0)
> Error string: The object cache is full.
> Error source:
> Help file: C:\Program Files\Common Files\Microsoft
>Shared\Repostry\REPOSTRY.
>CHM
> Help context: 4208
>
>Do you know what the Error String: "The object cache is full" mean?
>
>Thanks again!
>
>V
>
>"Sue Hoegemeier" wrote:
>
>> If you are having problems deleting a package in the
>> repository, it could be that the repository is corrupt. I've
>> deleted packages in the same situation by using the !D
>> argument of the dtsrun utility. The package doesn't run, it
>> just tries to delete it. Sometimes it doesn't work right
>> away and you may have to try it a couple of times.
>>
>> -Sue
