Sunday, December 5, 2010

SCCM R2 SP1 to SP2 upgrade issue

__________________________________________________________________
Error
__________________________________________________________________
Geeting the follwing error while trying to upgrade the SCCM R2 SP1 to SP2,

<05-26-2010> Succeeded to set watermark to 272535#3#1257#492884#453852#92996#3133#83#
<05-26-2010> End of importing data from CSV files
<05-26-2010> Begin resolving KB data and local KB data
<05-26-2010> ***SqlError: [23000][2627][Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'LU_SoftwareList_Local_PK'. Cannot insert duplicate key in object 'dbo.LU_SoftwareList_Local'.
<05-26-2010> SqlExecute <> hs.SoftwareID
>
<05-26-2010> ERROR: FAILED SQL Script: UPDATE sll SET
sll.SoftwareID = hs.SoftwareID
FROM dbo.LU_SoftwareList_Local sll
JOIN dbo.LU_SoftwareHash hs ON hs.SoftwarePropertiesHash = sll.SoftwarePropertiesHash
WHERE sll.SoftwareID <> hs.SoftwareID

<05-26-2010> SQL error <>
<05-26-2010> Failed to resolve KB data and local KB data
<05-26-2010> Could not import asset intelligence data.
<05-26-2010> Setup cannot upgrade the ConfigMgr database. Contact your SQL administrator.

___________________________________________________________________
Resolution
___________________________________________________________________

The issue is because of "-" in few of our custom table names.