October 6, 2010 at 5:15 am
Hi,
I set up Data Collector with all the defaults (apart from only retaining data for 1 day at the moment), but after a freak power hit in our data centre which brought the server down immediately, the collection set 3 Upload job, which on this server relates to the 'Query Statistics' collector, started to fail on the upload step (the log purge is fine).
The errors in the Data Collection log state...
String too long. The adapter read a string that was 1638407 bytes long, and expected a string no longer than 17 bytes, at offset 56293. This could indicate a damaged input file. The file shows a string length that is too large for the buffer column.
...follwed by...
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "RFS - Read Current Upload Data" (1) returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
SSIS isn't installed on this server! But the collection was working in the past!?
The collection, which runs permanently, and the upload both run dcexec which I can find little about.
I've tried leaving it running for a week but still get the error everytime it runs.
It's running as a SQL Admin as is the Agent.
I know you can't actually de-install Data Collector but I have tried deleting the Data Collector DB and reconfiguring and have also restarted SQL Server.
Any other help would be gratefully appreciated!!!
October 13, 2011 at 1:34 am
I got same error today. Here is solution
Go to cache directory and delete cache files which are related Query Activity Collection, then rerun upload job
Turgay Sahtiyan
SQL Server MVP
March 14, 2014 at 9:58 am
Exactly where and how do you remove the cached files?
March 14, 2014 at 10:09 am
Hi, this is by default the TEMP folder for the SQL Agent account, e.g., "C:\Users\accountname\AppData\Local\Temp".
October 21, 2015 at 5:33 am
You can find the path in "Data Collection Properties" under General and Cache Directory.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply