?
Solved

SCCM 2012 SP1 SMS_CLIENT_CONFIG_MANAGER Log error

Posted on 2013-01-21
3
Medium Priority
?
1,269 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 1500 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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

764 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