Utility Control Point - Error 37007 Job sysutility_mi_collect_and_upload

Question

Post reply

Utility Control Point - Error 37007 Job sysutility_mi_collect_and_upload

Pascal-226920

Old Hand

Points: 380
More actions
July 23, 2012 at 7:00 am

#259687

I have 4 instances enrolled into my UCP and 3 of them are standalone. The standalones instances gather the data very well.
The other instance is a FCI and on the clustered instance, I'm getting the folowing error during the last step "Upload to Utility Control Point" of the job sysutility_mi_collect_and_upload.
I cannot figured out what's going wrong and why i'm getting this error. There is nothing useful over the internet about this error.
Sorry for the error message in french:
Msg 37007, Niveau 16, État 1, Procédure sp_sysutility_mi_upload, Ligne 120
Une erreur s'est produite lors du chargement vers le point de contrôle de l'utilitaire SQL Server.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Satheesh E.P. SSCrazy Points: 2509 More actions · Answer 1

Can you translate the error message to English?

---------------------------------------------------
Thanks,
Satheesh.

Ant-Green SSC Guru Points: 113505 More actions · Answer 2

SELECT * FROM sys.messages WHERE message_id = 37007 AND language_id = 1033

An error occurred during upload to the SQL Server utility control point.

Pascal-226920 Old Hand Points: 380 More actions · Answer 3

An error occurred during upload to the SQL Server utility control point.

Ant-Green SSC Guru Points: 113505 More actions · Answer 4

Only thing I can find is that the SQL Agent must be configured for Manual starting when on a fail over cluster. Is this the case on your environment?

Pascal-226920 Old Hand Points: 380 More actions · Answer 5

The SQL Agent is set to manual, but it is running. I'm getting the same error on another non clustered instance I enrolled yesterday and the SQL Agent is set to start automaticaly.

Ant-Green SSC Guru Points: 113505 More actions · Answer 6

I am at a loss.

Out of interest what are the editions and product levels of all servers in the UCP environment?

Mix of 2008 and 2008R2 and 2012 with which SP's and CU's, which one is UCP and which one has the MDW on it?

Anything got FILESTREAM enabled?

Pascal-226920 Old Hand Points: 380 More actions · Answer 7

select @@version

Microsoft SQL Server 2012 - 11.0.2325.0 (X64)

Jun 8 2012 18:54:43

Copyright (c) Microsoft Corporation

Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

These servers are running into a labs and they are all on the same version of SQL SERVER 2012 and Windows 20087

I have a dedicated instance to UCP named TCN00QUBC01103\SQLDBHOPUCP and the MDW reside this server and the filestream is deactivate on all the server.

The servers FCI is raising the error every times that the job run. I have an other server that i used for offsite failover that I configured using Always ON availibility group is failling at every 2 or 3 execution of the job.

Pascal-226920 Old Hand Points: 380 More actions · Answer 8

I just disabled and Reenabled the data collection and the utility control point start working.

Stange but fixed.