SMS 2003 TO 2007 Migration

Guys I got this error while upgrading SMS to SCCM , SQL is in Windows auth mode and I ran testdbupgrade and it was successful . Can any one help please ..

<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'.
<07-13-2013 00:36:39> SqlExecute < IF EXISTS(select * from SMSData where SMSBuildNumber < 5300) AND OBJECT_ID('CI_UpdateCIs') IS NOT NULL 
 BEGIN 
    IF OBJECT_ID('tempdb..##TempCIUpdateSources') IS NOT NULL 
   BEGIN 
     drop table ##TempCIUpdateSources 
   END 
   EXEC(' CREATE TABLE ##TempCIUpdateSources (CI_ID int,UpdateSource_ID int, MinScanPackageVersion int) 
   insert into ##TempCIUpdateSources (CI_ID, UpdateSource_ID, MinScanPackageVersion) 
   select CI_ID, UpdateSource_ID, MinScanPackageVersion from CI_UpdateCIs where UpdateSource_ID is not null and MinScanPackageVersion is not null') 
 END 
 >
<07-13-2013 00:36:39> Cannot execute sql command  IF EXISTS(select * from SMSData where SMSBuildNumber < 5300) AND OBJECT_ID('CI_UpdateCIs') IS NOT NULL 
 BEGIN 
    IF OBJECT_ID('tempdb..##TempCIUpdateSources') IS NOT NULL 
   BEGIN 
     drop table ##TempCIUpdateSources 
   END 
   EXEC(' CREATE TABLE ##TempCIUpdateSources (CI_ID int,UpdateSource_ID int, MinScanPackageVersion int) 
   insert into ##TempCIUpdateSources (CI_ID, UpdateSource_ID, MinScanPackageVersion) 
   select CI_ID, UpdateSource_ID, MinScanPackageVersion from CI_UpdateCIs where UpdateSource_ID is not null and MinScanPackageVersion is not null') 
 END 

<07-13-2013 00:36:39> Setup cannot upgrade the ConfigMgr database.  Contact your SQL administrator.

July 13th, 2013 12:45am

Hi Guys, though there is no reply. I would still wanted to let know that the issue has been identified as a incorrect custom view in the SQL Database and the SCCM was unable to update that , when corrected the upgrade went successfully . 
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2013 6:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics