Solved

SCCM 2012 SP1 SMS_CLIENT_CONFIG_MANAGER Log error

Posted on 2013-01-21
3
1,245 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn the different options available in the Backstage view in Excel 2013.
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 …

738 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