I faced an issue could of month back, deploy list is not
synching with child site,
here is the solution how to resync and update the deploy list.
1-Failed to insert Object 6298a02f-0a6a-4f34-b832-08059b682b63
from replication file d:\Microsoft Configuration
Manager\inboxes\objmgr.box\INCOMING\RetryGL_48796.CID.
On to the resolution, I found that running the following 6 SQL
queries on the effected child sites resolved the issue:
Delete from CI_ConfigurationItems Where CIType_ID in (1, 6, 8);
Update CI_SDMPackages set IsDeleted = 1 where SourceSite = 'CEN';
Delete from CI_ComplianceHistory where isdetected = 1
Delete from CI_Compliancehistory where isdetected = 0
Delete from CI_SDMPackages where is deleted =1 and sourecesite = 'CEN'
Exec sp_DeleteOldSDMPackageData 0;
* Note: replace CEN with the site code of your central site (or the active SUP
which is the furthest upstream’)
Running the above queries will purge Software Updates data from
the effected child site.
You should then wait about 30 minutes and then restart the
following services on the effected child site:
SMS_EXECUTIVE
SMS_COMPONENT_MANAGER
The final step is to initiate a full site replication, this can
be done using the hierarchy maintenance tool (syncchild option) or by place a
file called .SHA * in the objmgr.box on the parent site.
* .SHA – replace with the 3 digit site code of the desired child
site you wish to replicate.
Allow up to 24 hours for the site replication to complete, when
it finishes you should have a fully matching compliment of updates on the
central site and child primary site.
2-If above method is not working then no problem, you would have
to follow following steps as well as you followed first steps,
1. In child site,
delete all files inside objmgr.box, objmgr.box\INCOMING,
objmgr.box\INCOMING\retry & objmgr.box\INCOMING\retry\Bad.
2. Run below SQL query to clean the updates information
from child site DB.
We need to run
a clean-up process using the below SQL query.
================================
BEGIN TRANSACTION
DECLARE @SiteCode varchar(8)
DECLARE @RowCount int, @Err int,
@TotalRowCount int
SELECT @SiteCode=ThisSiteCode
from SMSData
PRINT N'Step 1 - Deleting the
update sources'
delete from CI_UpdateSources
where UpdateSourceName = 'WSUS Enterprise Server'
PRINT N'Step 2 - Deleting rows of
type 1 and 6'
delete CIR from
CI_ConfigurationItemRelations CIR
left join CI_ConfigurationItems
cci on cci.CI_ID = CIR.FromCI_ID
where cci.CIType_ID in (1, 8)
delete CIR from
CI_ConfigurationItemRelations CIR
left join CI_ConfigurationItems
cci on cci.CI_ID = CIR.ToCI_ID
where cci.CIType_ID in (1, 8)
set rowcount 1000
delete from CI_ConfigurationItems
Where CIType_ID in (1) and SourceSite <>
@SiteCode
SET @TotalRowCount=@@RowCount
IF @@ERROR!=0 GOTO exiterror
while (1=1)
begin
Delete from CI_ConfigurationItems
Where CIType_ID in (1) and SourceSite <>
@SiteCode
SELECT @RowCount=@@ROWCOUNT,
@Err=@@ERROR
SET @TotalRowCount=@TotalRowCount
+ @RowCount
IF @Err!=0 GOTO exiterror
IF @RowCount = 0 break
PRINT N'Looping... Rows deleted
so far:'
PRINT @TotalRowCount
end
PRINT N'Step 3 - Deleting rows of
type 8'
set rowcount 1000
delete from CI_ConfigurationItems
Where CIType_ID = 8
SET @TotalRowCount=@@RowCount
IF @@ERROR!=0 GOTO exiterror
while (1=1)
begin
Delete from CI_ConfigurationItems
Where CIType_ID = 8
SELECT @RowCount=@@ROWCOUNT,
@Err=@@ERROR
SET @TotalRowCount=@TotalRowCount
+ @RowCount
IF @Err!=0 GOTO exiterror
IF @RowCount = 0 break
PRINT N'Looping... Rows deleted
so far:'
PRINT @TotalRowCount
end
PRINT N'Step 4 - Running the
SP...'
set rowcount 0
update CI_SDMPackages set
IsDeleted = 1
where SourceSite is not NULL and
SDMPackageName not like 'ScopeID%' and
SDMPackageName not like
'%GLOBAL%'
IF @Err!=0 GOTO exiterror
exec sp_DeleteOldSDMPackageData 0
IF @Err!=0 GOTO exiterror
GOTO exitok
exiterror:
PRINT N'Error:'
PRINT @@ERROR
exitok:
set rowcount 0
if @@ERROR = 0 COMMIT TRANSACTION
else ROLLBACK TRANSACTION
================================
.
1. Stop SMS Executive and Site component manager service
on Child site.
2. On the child
site navigate to <SCCM installation drive\location>\Bin\i386 rename the
DLL -> objreplmgr.dll to objreplmgr.dll.old
3. Start the Site
component manager service on Child site, SMS Executive service will be started
automatically by site comp service.
4. Force a resync of the updates data objects by dropping
a <childsitecode>.sha file into the Central site's
5. Once the SHA
file disappear, wait for 1 – 2 hour and proceed with next step.
6. Stop SMS Executive and Site component manager service
on Child site.
7. On the child
site navigate to <SCCM installation drive\location>\Bin\i386 rename the
DLL -> objreplmgr.dll.old to objreplmgr.dll
8. Start the Site
component manager service on Child site, SMS Executive service will be started
automatically by site comp service
