Solved

SCCM 2012 SP1 SMS_CLIENT_CONFIG_MANAGER Log error

Posted on 2013-01-21
3
1,233 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
ID: 38804167
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
ID: 38805856
I am seeing no other errors.  Any specific ideas where to look.
0
 
LVL 31

Expert Comment

by:merowinger
ID: 38809611
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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 …

828 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