The issue from my previous post did not resolve itself easily using supported methods to re-sync of pre-inst and creating the SHA file. Some reason a few items was holding things up because it wasn't able to insert them into the DB.
The engineer provided instructions to delete the entire table of the items and to re-sync the SUP items.
The idea behind renaming the objreplmgr.dl in Step 4 is to have all the items copied to the child site to process everything already local instead of as it is received, some items may have dependencies but in my case it didn't seem like it and they never saw the error listed.
Make a backup of the DB and use the instructions at your own risk. Please contact MS Support if you're unsure as you may end up causing more issues than trying to fix modifying the DB directly.
Perform the steps below
1.
In child Primary 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.
SQL script in blue text
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
3.
Stop SMS Executive and Site component manager service on Child Primary site.
4.
On the child Primary site navigate to
\Bin\i386 rename the DLL -> objreplmgr.dll to objreplmgr.dll.old
5.
Start the Site component manager service on Child Primary site, SMS Executive service will be started automatically by site comp service.
6.
Force a resync of the updates data objects by dropping a
.sha file into the Central site's ..\inboxes\objmgr.box. eg. CH1.SHA
7.
Once the SHA file disappear, wait for 4-5hours and proceed with next step.
8.
stop SMS Executive and Site component manager service on Child site.
9.
On the child site navigate to
\Bin\i386 rename the DLL -> objreplmgr.dll.old to objreplmgr.dll
10.
Start the Site component manager service on Child site, SMS Executive service will be started automatically by site comp service.
