Executing the query “{call [core].[sp_create_snapshot](?, ?, ?, ?, ?, ?…” failed with the following error: “The specified @collector_type_uid (14AF3C12-38E6-4155-BD29-F33E7966BA23) is not valid in this data warehouse.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.
if we look sp_create_snapshot procedure in Management_dataware_house it accepts six parameters @collection_set_uid ,@collector_type_uid ,@machine_name , @named_instance , @log_id , @snapshot_id
this procedure creates a snapshot in the management datawarehouse for a collection instance one parameter is Collecter_type_id
Note: Sql Server Data collector can collect data from Dynamic management views , SQL trace and Windows performance counters using TSQL and WMI query’s
We can get list of availanle data collector types by querying
SELECT
[collector_type_uid],[name]
,[parameter_schema]
,[parameter_formatter]
,[schema_collection]
,[collection_package_name]
,[collection_package_folderid]
,[upload_package_name]
,[upload_package_folderid]
,[is_system]
FROM [msdb].[dbo].[syscollector_collector_types_internal]
insertinto [core].[supported_collector_types_internal](collector_type_uid)
values (’14AF3C12-38E6-4155-BD29-F33E7966BA23′)
Thank you for sharing your info. I truly appreciate your efforts and I will
be waiting for your further write ups thank you once again.