Solved

SCCM 2012 SP1 SMS_CLIENT_CONFIG_MANAGER Log error

Posted on 2013-01-21
3
1,204 Views
Last Modified: 2013-12-11
SCCM 2012 SP1 on Windows Server 2012
SQL Server 2008 R2 10.50.4270.0

I have started to migrate SCCM 2007 clients over to SCCM 2012 SP1..Clients appear to be upgrading properly and talking properly, but
Now I see my SMS_CLIENT_CONFIG_MANAGER log is full of:
Microsoft SQL Server reported SQL message 537, severity 16: [42000][537][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid length parameter passed to the LEFT or SUBSTRING function. : sp_CP_CheckNewAssignedMachine

Any idea of what this means...?
0
Comment
Question by:gacus
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
Comment Utility
First of all check all your Log files on the Server for further errors.
sp_CP_CheckNewAssignedMachine is a Stored Procedure on your SQL Server
0
 
LVL 1

Author Comment

by:gacus
Comment Utility
I am seeing no other errors.  Any specific ideas where to look.
0
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
Yes SMS_CCM\Logs\ClientAuth.log and smsdbmon.log
Do you have a Client with a extremly long name?! Check your AD
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now