January 5, 2012 at 7:33 am
shew (1/4/2012)
scott.shaw (1/4/2012)
My MDW logs were showing data conversion errors for QueryActivity. I also noticed a backlog of CACHE files in the MDW directory related to QueryActivity. I deleted all the QueryActivity CACHE files and this fixed the problem.Where is the directory located?
Right click on Data Collection under Management in SSMS. Select properties and you'll see a path setting for the Cache Directory.
November 19, 2015 at 7:38 am
You guys might want to have a look at these:
http://paulouyang.blogspot.com/2015/05/data-collection-mdw-errors-after.html
https://support.microsoft.com/en-us/kb/2793580
Running the following query should give you SSIS errors.
use msdb
select * from dbo.syscollector_execution_log_internal
where start_time >= '2015-11-19 00:01:00.000' --change date as needed
On my 'Stored Procedure Usage Analysis' data collector, the uploads are working, but the collections are not. The message is:
"output "OLE DB Source Output" (11)" contains no output columns. An asynchronous output must contain columns.
and:
SSIS error. Component name: DFT - Collect Query 0, Code: -1073594105, Subcomponent: (null), Description: There were errors during task validation.
From what I've been able to gather, it appears that this occurred after a MS patch. Look at ChrisAllenNC's comment on this page towards the bottom.
I have a support call into MS on this matter, but they have not been very responsive. If and when I hear something, I'll post more. One other thing, I was told to install SQL 2012 SP2 CU7 (this is supposed to address the other error, which is here:
https://support.microsoft.com/en-us/kb/3062001 -- Failed to create kernel event for collection set: {2DC02BD6-E230-4C05-8516-4E8C0EF21F95}. Inner Error ------------------>
Please keep this thread alive. There's a lot of people having this same issue.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply