Sccm status messages not updating

: sp_Ins Content Distribution Status SMS_STATUS_MANAGER 2/19/2016 AM 4648 (0x1228) exec sp_Ins Content Distribution Status N'', N'RTM00405', 0, 72057594038182832, 2361, '02/18/2016 .240', N'\myserver.com\dfs\Packages\Microsoft\Updates\Windows 7 Server 2008 R2 Office 2010 Patch Tuesday Updates 2015289d79-38a1-44a3-a2a7-5f54febcb70b', N'95289d79-38a1-44a3-a2a7-5f54febcb70b', N'95289d79-38a1-44a3-a2a7-5f54febcb70b', N'30', N'69', N''; As I looked through the files containing the problem transactions, I noticed a pattern appear.

Each file contained a stored procedure named “sp_Ins Content Distribution Status”, and each of these stored procedures involved the source path to a Microsoft update in one of my Software Update Deployment Packages.

If you can explain the cause of the problem, please do post a comment.

Nothing about the arguments to the stored procedure looked out of place, and in fact matched very closely to stored procedures that ran successfully once the jam in Microsoft Configuration Manager\inboxes\statmgr.box\retry\ was cleared.

I did some Googling and formulated a course of action to restore most of the missing log entries until I had time to troubleshoot the root cause.

As a first step to attempt to resolve the problem, I deleted the Software Update Deployment Package and then rebuilt it from the source path.

The files did not build up in Microsoft Configuration Manager\inboxes\statmgr.box\retry\, and the problem where the component status messages stopped being display did not recur.

So, unfortunately, I seem to have fixed the problem by going straight to the nuclear option, and missed out on any opportunity for finding the root cause.While I don’t have an explanation about why the stored procedure errored out, I’m posting this description of my experience in hopes of helping others.The odd thing about this was that the icons and status seemed to be updating correctly, suggesting that the data for the logs was still being collected and processed, but SCCM could not display the logs.The events written to looked something like this (in part): *** exec sp_Ins Content Distribution Status N'', N'RTM00405', 0, 72057594038182832, 2361, '02/18/2016 .240', N'\myserver.com\dfs\Packages\Microsoft\Updates\Windows 7 Server 2008 R2 Office 2010 Patch Tuesday Updates 2015289d79-38a1-44a3-a2a7-5f54febcb70b', N'95289d79-38a1-44a3-a2a7-5f54febcb70b', N'95289d79-38a1-44a3-a2a7-5f54febcb70b', N'30', N'69', N''; SMS_STATUS_MANAGER 2/19/2016 AM 4648 (0x1228) *** [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.Something was preventing new logs from being created.

sccm status messages not updating-62sccm status messages not updating-22sccm status messages not updating-4

The Component Status logs are found under the Monitoring node, by expanding System Status and then selecting Component Status.

Join our conversation (71 Comments).
Click Here To Leave Your Comment Sccm status messages not updating.

Comments:

  1. 1
    Steve

    Mature women need attention, love and sex just like any others.

  2. 1
    Steve

    They made the game so addictive and almost fun to play until you get into it.

  3. 1
    Steve

    As Radar has previously reported, the twice-married Carrey and Mc Carthy broke up last April after five years together.

  4. 1
    Steve

    Although adults use these apps both for casual hookups and for scouting out more long-term relationships, they're risky for teens.

  5. 1
    Steve

    The next generation would grow up surrounded by paganism and immorality. And throughout the ages, Jewish parents have prayed that their children should be able to withstand the temptations of exile, and keep a strong, proud Jewish identity.

  6. 1
    Steve

    Grid View Update Event Args) Handles gv Business Hours.

Leave a Reply

Your email address will not be published. Required fields are marked *