SCCM 2012 database issue /question

Hi All

We have 2 recurring errors on our Primary Server (SQL locally installed so a local database).

We have recently updated SCCM 2012 RTM -> SCCM 2012 SP1 (no CU), and we have upgraded SQL 2008 R2 (CU6) to SQL 2008 R2 SP2.

 We have exactly the same issue in our TST environment.

Both errors are related to SQL  

We checked the SQL server log,

The fist error:

Warning: Failure to calculate super-latch promotion threshold.

I dont now where to search for this error also google did not provide me with some useful help, I hope someone here can help me with this one.

The second error:

This one has something to do with the stored procedure DRSMsgBuilderActivation

The activated proc '[dbo].[spDRSMsgBuilderActivation]' running on queue 'CM_XXX.dbo.ConfigMgrDRSMsgBuilderQueue' output the following:  'ERROR: Sync of type Configuration Data failed, see previous messages for details.'

And the previous message is the following :

The activated proc '[dbo].[spDRSMsgBuilderActivation]' running on queue 'CM_XXX.dbo.ConfigMgrDRSMsgBuilderQueue' output the following:  'ERROR 3961, Level 16, State 1, Procedure spDRSSendChangesForGroup, Line 1, Message: Snapshot isolation transaction failed in database 'CM_XXX' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction.  It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.'

I did some checking and there is no problem with the tempdb

Also with this error I hope that someone can help me

Perhaps someone has had the same error

Regards and thx in advance

Johan


  • Edited by Johan Erven Tuesday, April 01, 2014 11:31 AM forgot something to metion
March 27th, 2014 4:52pm

Hi All

Perhaps someone has had the same error and found a solution

I am not sure if these errors are harmfull , if so we better log a MS call and post the results here

Regards

Johan

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2014 11:39am

Johan,

Did you ever resolve this issue? I have 5 servers with the same problem.

Thanks,

Andrew

September 10th, 2014 8:09pm

Hi Andrew

No we did not resolve this issue , we cannot find exactly find the cause of this issue

If we have a solution I will post it

Regards

Johan

Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2014 12:10pm

hi, one thing I did not understand is, what is the effect on the non technical side of this error?
On the technical side you can find some information in error logs. This it's what I understood.
Is your sccm server working? Or is it not even possible to finish the sccm installation?


October 5th, 2014 4:18pm

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.

Free Windows Admin Tool Kit Click here and download it now
May 30th, 2015 1:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics