Posted on 2013-01-21
Medium Priority
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...?
Question by:gacus
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
LVL 31

Accepted Solution

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

Author Comment

ID: 38805856
I am seeing no other errors.  Any specific ideas where to look.
LVL 31

Expert Comment

ID: 38809611
Yes SMS_CCM\Logs\ClientAuth.log and smsdbmon.log
Do you have a Client with a extremly long name?! Check your AD

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