Using the query below we are able to find the offending application./*** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [CI_ID]
,[PkgID]
,[CI_UniqueID]
,[SecuredTypeID]
,[ModelName]
FROM [CM_CM0].[dbo].[vSMS_CIContentPackage]
where CI_UniqueID like '%2caa%'
CI_UniqueID | PkgID | CI_ID | |
138181 | ABC0018D | ScopeId_EA3D3752-B4D4-453F-B3F3-03C70EAD781A/Application_2caa0766-569b-48c0-91b8-79bb3a22c0d7/1 |
Find the Application and ensure it is distributed to the DP/Secondary.