One of my primary site is not getting application packages replicated. And distmgr.log file is producing below error. "Failed to insert SMS Package <Packge_ID> because SDM Type Content <Unique_ContentID> is not present in the CI_Contents table. Will try later." "Cannot update the package <Packge_ID> in the package source, error = 3" Couple of other errors I have noticed in "objreplmgr.log" ~Failed to insert Object <UNIQUEID> from replication file E:\SMS\inboxes\objmgr.box\INCOMING\Retry\<FILENAME>.CID. $$<SMS_OBJECT_REPLICATION_MANAGER> I have looked into couple of other blogs and I found a number of thoughts and tried most of them however no luck. Please find the details below. 1. Tried run the query from parent site of thee problematic primary site and it retured me some entries. However I tried to run the query in problematic primary site and it didn't return any entries. select * from dbo.CI_ConfigurationItems where 2. 1) Click Start -> Run -> wbemtest 2) Connect to the configuration manager namespace -> root\sms\site_[SiteCode] 3) Click on Query and enter the following query:select PackageType from SMS_Package where PackageID= <PackageID> This also didn't return anything. 3. preinst.exe /Synchild <SITECODE> tried to do a sync that also didn't work. The result was like "<SITECODE> is not a known site. 4. When I compared “CI_ContentPackages” table of one good server with problematic server and I could see there are lot of packges missing from a problematic Primary server. Anoop C Nair

Yes, we have tried the second option on the cetral site DB "Update the "datelastmodified" column to current date in ci_configurationitems table for respective CI unique id. By doing this, you can re-replicate the individual CIs" and it did find really helpful.After updating the CI_COnfiguarationitems table, and we tried re-running the preinst.exe /syncchild <sitecode> command. That fixed the issue.Thank You Very Much.Anoop C Nair

Just a side note: modifying the database is not supported.