SCCM 2002 Messaging Folder Growth

Question

Hi all,

Hope someone can shed some light on this for me...

I recently inherited an SCCM server that serves 4500 people/devices. I'm having an issue where the D: (SCCM Install) Partition is filling up which causes software center issues and some other problems. What I've noticed is that when I browse from D:\Program Files\SMS_CCM\ServiceData\Messaging\OutgoingQueues That's where I get a ton of .msg files and SCCM files. The server is constantly writing at 3 Mb/s.

When I browse task manager I see that Host Process for Microsoft Configuration Manager or SMS Agent Host is running at 13-15% CPU and all the data under resource monitor is from the CcmExec.exe.

Version is 2002 on 2016 server

Answer 1

@matthew wolf

Thank you for posting in Microsoft Q&A forum.

What I've noticed is that when I browse from D:\Program Files\SMS_CCM\ServiceData\Messaging\OutgoingQueues That's where I get a ton of .msg files and SCCM files.

Based on my research, many situations may cause this issue. Generally speaking, the state message files are supposed to automatically copy files from the state system to MP(D:\SMS\MP\OUTBOXES\statemsg.box\folder) for every 15mintues(by default). The workflow completes after the state messages arrive at the management point are processed into .smx files by the MP Relay component. Please refer to this Microsoft article for more details.

The detailed workflow may like the image shown below:

For troubleshooting "a ton of .msg files" issue, we could check the SMSProv.log(site server side) and the ccmmessaging.log(client side) to track if there is any error during the process.

Have a good day!

---

If the response is helpful, please click "Accept Answer" and upvote it.
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.

Answer 2

@Fiona Yan-MSFT

Thank you for the detailed explaining regarding message processing.

I might have to break these issues out into different threads but I believe they are all related to the messages filling up on the D:\

1. Component Status Issues
   • Monitoring > Overview > System Status > Component Status > Critical
     
   • Monitoring > Overview > System Status > Component Status > Warning
     
     2. Distribution Point won't process applications

I've already attempted to clear the package from MECM and rebuild the deployment by hand rather than copy from continuous update applications. I've distributed the content again to the DP which we only have one on the same site server.

3. RBAC issues when logging into MECM via my administrator account
4. SMSProv.log (All within a 10 minute period)
   • Execute SQL =select all stat.Component,stat.MachineName,stat.MessageID,stat.MessageType,stat.ModuleName,stat.PerClient,stat.ProcessID,stat.RecordID,stat.ReportFunction,stat.Severity,stat.SiteCode,stat.SuccessfulTransaction,stat.ThreadID,stat.Time,stat.TopLevelSiteCode,stat.PartOfTransaction,stat.Win32Error,att.AttributeID,att.AttributeTime,att.AttributeValue,att.RecordID,ins.InsStrIndex,ins.InsStrValue,ins.RecordID from vStatusMessages AS stat LEFT OUTER JOIN vStatusMessageAttributes AS att ON stat.RecordID = att.RecordID LEFT OUTER JOIN vStatusMessageInsStrs AS ins ON stat.RecordID = ins.RecordID where ((stat.Time >= '2021/02/08 16:53:15.000' AND stat.SiteCode = N'XXX') AND stat.MachineName = N'SCCM01.XX.XXX.XX') order by stat.Time desc OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:53:16 AM 20620 (0x508C)
     *Execute SQL =select all SMS_ComponentSummarizer.AvailabilityState,SMS_ComponentSummarizer.ComponentName,SMS_ComponentSummarizer.ComponentType,SMS_ComponentSummarizer.Errors,SMS_ComponentSummarizer.HeartbeatInterval,SMS_ComponentSummarizer.Infos,SMS_ComponentSummarizer.LastContacted,SMS_ComponentSummarizer.LastHeartbeat,SMS_ComponentSummarizer.LastStarted,SMS_ComponentSummarizer.MachineName,SMS_ComponentSummarizer.NextScheduledTime,SMS_ComponentSummarizer.SiteCode,SMS_ComponentSummarizer.State,SMS_ComponentSummarizer.Status,SMS_ComponentSummarizer.TallyInterval,SMS_ComponentSummarizer.Type,SMS_ComponentSummarizer.Warnings from vSMS_ComponentSummarizer AS SMS_ComponentSummarizer where (SMS_ComponentSummarizer.SiteCode in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (6)))) AND SMS_ComponentSummarizer.TallyInterval = N'0001128000100008') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:53:05 AM 20620 (0x508C)
     *Execute SQL =select all stat.Component,stat.MachineName,stat.MessageID,stat.MessageType,stat.ModuleName,stat.PerClient,stat.ProcessID,stat.RecordID,stat.ReportFunction,stat.Severity,stat.SiteCode,stat.SuccessfulTransaction,stat.ThreadID,stat.Time,stat.TopLevelSiteCode,stat.PartOfTransaction,stat.Win32Error,att.AttributeID,att.AttributeTime,att.AttributeValue,att.RecordID,ins.InsStrIndex,ins.InsStrValue,ins.RecordID from vStatusMessages AS stat LEFT OUTER JOIN vStatusMessageAttributes AS att ON stat.RecordID = att.RecordID LEFT OUTER JOIN vStatusMessageInsStrs AS ins ON stat.RecordID = ins.RecordID where (((stat.Time >= '2021/02/08 16:52:12.000' AND stat.Severity = -2147483648) AND stat.SiteCode = N'XXX') AND stat.MachineName = N'SCCM01.XX.XXX.XX') order by stat.Time desc OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:52:13 AM 7136 (0x1BE0)
     *Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:51:42 AM 7136 (0x1BE0)
     *Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:50:56 AM 20620 (0x508C)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_a4686daa-fa6c-463a-95a8-1af2a7591a84') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:48:57 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ApplicationLatest.CI_ID,SMS_ApplicationLatest.LocaleID,SMS_ApplicationLatest.ApplicabilityCondition,SMS_ApplicationLatest.CI_ID,SMS_ApplicationLatest.CI_UniqueID,SMS_ApplicationLatest.CIType_ID,SMS_ApplicationLatest.CIVersion,SMS_ApplicationLatest.ConfigurationFlags,SMS_ApplicationLatest.CreatedBy,SMS_ApplicationLatest.DateCreated,SMS_ApplicationLatest.DateLastModified,SMS_ApplicationLatest.EffectiveDate,SMS_ApplicationLatest.EULAAccepted,SMS_ApplicationLatest.EULAExists,SMS_ApplicationLatest.EULASignoffDate,SMS_ApplicationLatest.EULASignoffUser,SMS_ApplicationLatest.IsUserCI,SMS_ApplicationLatest.Featured,SMS_ApplicationLatest.HasContent,SMS_ApplicationLatest.IsBundle,SMS_ApplicationLatest.IsDeployable,SMS_ApplicationLatest.IsDeployed,SMS_ApplicationLatest.IsEnabled,SMS_ApplicationLatest.IsExpired,SMS_ApplicationLatest.IsHidden,SMS_ApplicationLatest.IsLatest,SMS_ApplicationLatest.IsQuarantined,SMS_ApplicationLatest.IsSuperseded,SMS_ApplicationLatest.IsSuperseding,SMS_ApplicationLatest.IsUserDefined,SMS_ApplicationLatest.IsVersionCompatible,SMS_ApplicationLatest.LastModifiedBy,SMS_ApplicationLatest.Description,SMS_ApplicationLatest.DisplayName,SMS_ApplicationLatest.CIInformativeURL,SMS_ApplicationLatest.LocaleID,SMS_ApplicationLatest.LogonRequirement,SMS_ApplicationLatest.Manufacturer,SMS_ApplicationLatest.ModelID,SMS_ApplicationLatest.ModelName,SMS_ApplicationLatest.NumberOfDependedDTs,SMS_ApplicationLatest.NumberOfDependentTS,SMS_ApplicationLatest.NumberOfDeployments,SMS_ApplicationLatest.NumberOfDeploymentTypes,SMS_ApplicationLatest.NumberOfDevicesWithApp,SMS_ApplicationLatest.NumberOfDevicesWithFailure,SMS_ApplicationLatest.NumberOfSettings,SMS_ApplicationLatest.NumberOfUsersWithApp,SMS_ApplicationLatest.NumberOfUsersWithFailure,SMS_ApplicationLatest.NumberOfUsersWithRequest,SMS_ApplicationLatest.NumberOfVirtualEnvironments,SMS_ApplicationLatest.ObjectPath,SMS_ApplicationLatest.PermittedUses,SMS_ApplicationLatest.PlatformType,SMS_ApplicationLatest.SDMPackageVersion,SMS_ApplicationLatest.SedoObjectVersion,SMS_ApplicationLatest.SoftwareVersion,SMS_ApplicationLatest.SourceCIVersion,SMS_ApplicationLatest.SourceModelName,SMS_ApplicationLatest.SourceSite,SMS_ApplicationLatest.SummarizationTime from fn_ListLatestApplicationCIs_List(1033) AS SMS_ApplicationLatest where (SMS_ApplicationLatest.ModelName not in (select all Folder##Alias##810314.InstanceKey from vFolderMembers AS Folder##Alias##810314 where Folder##Alias##810314.ObjectTypeName = N'SMS_ApplicationLatest') AND (SMS_ApplicationLatest.ModelName in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ApplicationLatest.IsHidden = 0)) order by SMS_ApplicationLatest.DisplayName OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:48:56 AM 20620 (0x508C)
     *Execute SQL =select all SMS_StatusMessage.Component,SMS_StatusMessage.MachineName,SMS_StatusMessage.MessageID,SMS_StatusMessage.MessageType,SMS_StatusMessage.ModuleName,SMS_StatusMessage.PerClient,SMS_StatusMessage.ProcessID,SMS_StatusMessage.RecordID,SMS_StatusMessage.ReportFunction,SMS_StatusMessage.Severity,SMS_StatusMessage.SiteCode,SMS_StatusMessage.SuccessfulTransaction,SMS_StatusMessage.ThreadID,SMS_StatusMessage.Time,SMS_StatusMessage.TopLevelSiteCode,SMS_StatusMessage.PartOfTransaction,SMS_StatusMessage.Win32Error from vStatusMessages AS SMS_StatusMessage where (((SMS_StatusMessage.Component = N'SMS_REST_PROVIDER' AND SMS_StatusMessage.SiteCode = N'XXX') AND SMS_StatusMessage.MachineName = N'SCCM01.XX.XXX.XX') AND (SMS_StatusMessage.MessageID = 11609 OR SMS_StatusMessage.MessageID = 11610)) order by SMS_StatusMessage.Time desc OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:48:53 AM 20620 (0x508C)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:41 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:40 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:40 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_103ae33f-73e0-4de1-9193-30e689da7336') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:40 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_48384E39-B596-4330-8B1D-11C8D09FE2C6/Application_62da0729-7b21-4ac2-a7b4-aa1763de0617') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:39 AM 30600 (0x7788)
   • Execute SQL =select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo where ((((SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (2,23,24,21,18,19,14)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (2,23,24,21,18,19,14)) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (31)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (31))) OR (SMS_ObjectContentExtraInfo.ObjectID in (select all SUIP0.ObjectKey from RBAC_InstancePermissions AS SUIP0 where (SUIP0.AdminID in (16777227) AND ((GrantedOperations&1) = 1 AND SUIP0.ObjectTypeID in (16)))) AND SMS_ObjectContentExtraInfo.ObjectTypeID in (16))) AND SMS_ObjectContentExtraInfo.PackageID = N'PR3000B3') OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION')) SMS Provider 2/15/2021 11:43:30 AM 30600 (0x7788)

Answer 3

@Fiona Yan-MSFT

I'm also getting this error every minute under distmgr.log

ERROR: Still waiting for SMS_INBOX_MANAGER to create the "Site Control Manager (Master Site Control File)" inbox. Sleeping for 60 seconds. The operating system reported error 5: Access is denied. SMS_DISTRIBUTION_MANAGER 2/15/2021 12:25:59 PM 6044 (0x179C)

Answer 4

That sound like someone reset the file permissions. I would preform a site reset, this should reset permission back to what they should be.

Answer 5

In a nutshell nothing will "change" it just reinstalls all the roles and reset security setting on files, folders, regkeys etc.

And yes his blog look fine.