Error starting data collection on new server

Alen Cappelletti 992 Reputation points
2022-11-11T11:08:25.74+00:00

Hi,
I try to activate on my new dev server "data collection" feature.

Oddly it gives me error. I have already defined a server/db where I collect data and already in other db instancesi it's up and running.

259542-image.png

While trying to activate no job was created.

I'm logged like sysadmin with my domain user naturally and also tried with sql server (sysadmin user)

This is the error:

===================================  
  
Unable to start collection set Disk Usage. (Microsoft.SqlServer.Management.Collector)  
  
------------------------------  
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47008.0&LinkId=20476  
  
------------------------------  
Program Location:  
  
   at Microsoft.SqlServer.Management.Collector.CollectionSet.StartStopUpload(String script, Boolean modifyIsRunning, Boolean isRunningVal, String exptnString)  
   at Microsoft.SqlServer.Management.Collector.CollectionSet.Start()  
   at Microsoft.SqlServer.Management.SqlManagerUI.StartDataCollectionSet.StartDataCollectionSetAction.DoAction(ProgressItemCollection actions, Int32 index)  
   at Microsoft.SqlServer.Management.SqlStudio.Controls.ProgressItemCollection.DoWorkOnThread()  
  
===================================  
  
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)  
  
------------------------------  
Program Location:  
  
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)  
   at Microsoft.SqlServer.Management.Collector.CollectionSet.StartStopUpload(String script, Boolean modifyIsRunning, Boolean isRunningVal, String exptnString)  
  
===================================  
  
Caught error#: 14373, Level: 16, State: 1, in Procedure: sp_verify_schedule_identifiers, Line: 29, with Message: Supply either @schedule_id or @schedule_name to identify the schedule. (.Net SqlClient Data Provider)  
  
------------------------------  
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-14684-database-engine-error  
  
------------------------------  
Server Name: XXXXXXXXXX  
Error Number: 14684  
Severity: 16  
State: 1  
Procedure: msdb.dbo.sp_syscollector_start_collection_set  
Line Number: 203  
  
  
------------------------------  
Program Location:  
  
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)  
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)  

Do you have any idea what the cause might be?
ALEN

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,351 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,081 Reputation points
    2022-11-14T08:04:31.987+00:00

    Hi @Alen Cappelletti ,

    What is the version of your SQL Server? If is 2016 or 2017, you can check out this article: https://support.microsoft.com/en-us/topic/kb4057190-fix-error-14684-when-you-reconfigure-management-data-warehouse-in-a-named-instance-of-sql-server-2016-and-2017-6c7667cc-c3cf-b866-8f95-8b7e838c9d76

    You said it is a new dev server, but as you also said and the error message are all implying that it is reconfiguring, this is strange.

    Or other solutions that others have found is to delete the generated SSIS packages, they are in MSDB database, you can find them by connecting SSIS through SSMS and going to "Stored Packages"->MSDB->Data Collector->Generated

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.