Home
%3CLINGO-SUB%20id%3D%22lingo-sub-339941%22%20slang%3D%22en-US%22%3EThe%20case%20of%20the%20unexplained%20-%20The%20package%20gets%20distributed%20successfully%20but%20does%20not%20show%20in%20the%20Console%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%221%22%3E%3CSTRONG%3E%20%3CFONT%20color%3D%22%23ff0000%22%3EFirst%20published%20on%20TECHNET%20on%20Oct%2002%2C%202014%3C%2FFONT%3E%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Fumairkhan%2F2014%2F10%2F02%2Fthe-case-of-the-unexplained-the-package-gets-distributed-successfully-but-does-not-show-in-the-console%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.technet.microsoft.com%2Fumairkhan%2F2014%2F10%2F02%2Fthe-case-of-the-unexplained-the-package-gets-distributed-successfully-but-does-not-show-in-the-console%2F%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Folks%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELately%20was%20looped%20in%20an%20issue%20where%20we%20target%20a%20DP%20to%20the%20package%20and%20from%20the%20DistMgr.log%20it%20shows%202301%20for%20the%20package%20being%20successfully%20send%20to%20the%20DP%20and%20verified%20in%20the%20ContentLib%20too%20but%20does%20not%20show%20in%20the%20console.%20It%20stays%200.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20497px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F75324i7265812F6C96DDA7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%E2%80%99ve%20a%20key%20created%20before%20on%20the%20info%20of%20the%20flow%20in%20background.%20There%20are%204%20main%20Global%20tables%20which%20are%20responsible%20for%20other%20updates%20on%20other%20tables%20via%20Trigger%20%E2%80%93%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20margin%3A%200px%200px%2010px%3B%20color%3A%20%23333333%3B%20font-family%3A%20'Segoe%20UI'%2C%20Tahoma%2C%20Arial%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20sans-serif%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20start%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E1.%20SMSPackages_G%0A%20%20%20%20%20%20%20%20%20%20%20%7C%0A%5Btr_SMSPackages_ContentNotification%5D%20-%26gt%3B%20ContentDistribution%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7C%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5Btr_ContentDistribution_Notification%5D%20-%26gt%3B%20ContentDistributionNotification%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5Btr_ContentDistributionNotification_Summarizer%5D%20-%26gt%3B%20%20ContentDistributionMessages%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%202.%20%3CFONT%20color%3D%22%230000ff%22%3EPkgServers_G%3C%2FFONT%3E%20%0A%20%20%20%20%20%20%20%20%20%7C%20%0A%5B%20tr_PkgServers_G_ContentNotification%20%5D%20%E2%80%93%26gt%3B%3CFONT%20color%3D%22%230000ff%22%3EContentDistributionNotification%3C%2FFONT%3E%20-%5B%20tr_ContentDistributionNotification_insert%20%5D%20%E2%80%93%26gt%3B%3CFONT%20color%3D%22%230000ff%22%3EContentDistribution%0A%20%0A%3C%2FFONT%3E%E2%80%93%26gt%3B%5BCont%5D%20%3CFONT%20color%3D%22%230000ff%22%3EContentDistribution%3C%2FFONT%3E%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7C%20%0A%5B%20tr_ContentDistributionNotification_Summarizer%20%5D%20%E2%80%93%26gt%3B%20%20%3CFONT%20color%3D%22%230000ff%22%3EContentDistributionMessages%3C%2FFONT%3E%3CBR%20%2F%3E%20%20%20%20%20%20%20%20%7C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5Btr_ContentDistribution_Notification%5D%20-%26gt%3B%20%3CFONT%20color%3D%22%230000ff%22%3EContentDistributionNotification%3C%2FFONT%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E3.%20PkgStatus_G%20%0A%20%7C%20%0A%5Btr_PkgStatus_G_ContentNotification%5D-%26gt%3B%20ContentDistribution%20%0A%20%20%20%20%20%20%7C%20%0A%20%20%20%20%5Btr_ContentDistribution_Notification%5D%20-%26gt%3B%20ContentDistributionNotification%20%0A%20%20%20%20%20%20%20%20%20%20%20%7C%0A%20%20%20%20%20%20%20%20%20%20%5Btr_ContentDistributionNotification_Summarizer%5D%20-%26gt%3B%20%20ContentDistributionMessages%3C%2FPRE%3E%0A%3CPRE%3E4.%20DistributionStatus%20%0A%20%20%7C%20%0A%5B%20tr_DistributionStatus_ContentNotification%20%5D%20-%26gt%3B%20ContentDistributionMessages%3C%2FPRE%3E%0A%3CP%3E-%20Use%20the%202%20%3CSUP%3E%20nd%20%3C%2FSUP%3E%20one%20above%26nbsp%3Bfor%20this%20case%20as%20we%20are%20tracking%20the%20DP%20targeting.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20in%20our%20case%2C%20I%20see%20the%20entry%20in%20the%20PkgServers_G%20table%20for%20the%20DP%20being%20added.%3C%2FP%3E%0A%3CP%3EChecking%20for%20the%20package%3C%2FP%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%26nbsp%3B%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eselect%3C%2FSPAN%3E%20*%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Efrom%3C%2FSPAN%3E%20smspackages%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewhere%3C%2FSPAN%3E%20pkgid%20%3D%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'TX1000AD'%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eselect%3C%2FSPAN%3E%20*%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Efrom%3C%2FSPAN%3E%20PkgServers_G%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewhere%3C%2FSPAN%3E%20pkgid%20%3D%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'TX1000AD'%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eselect%3C%2FSPAN%3E%20*%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Efrom%3C%2FSPAN%3E%20ContentDistributionNotification%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewhere%3C%2FSPAN%3E%20pkgid%20%3D%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'TX1000AD'%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eselect%3C%2FSPAN%3E%20*%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Efrom%3C%2FSPAN%3E%20ContentDistribution%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewhere%3C%2FSPAN%3E%20pkgid%20%3D%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'TX1000AD'%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20So%20I%20see%20the%20ContentDistributionNotification%20has%20the%20value%20but%20ContentDistribution%20table%20does%20not.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20So%20the%20insert%20trigger%20%5B%20%3CI%3E%20tr_ContentDistributionNotification_insert%20%3C%2FI%3E%20%5D%20on%20the%20ContentDistributionNotification%20table%20is%20not%20running.%3C%2FP%3E%0A%3CP%3E-%20Got%20a%20snippet%20of%20the%20trigger%20%5Bsee%20below%5D%20and%20modified%20it%20to%20return%20and%20check%20if%20that%20has%20the%20value%20and%20yes%20we%20do%20see%20the%20value%2C%20so%20if%20this%20trigger%20was%20run%20it%20would%20have%20send%20the%20updates%20to%20the%20other%20tables.%3C%2FP%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%26nbsp%3B%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3ESELECT%3C%2FSPAN%3E%20ins.DistributionID%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Eins.DPID%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Eins.PkgID%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgID%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(ver.AvailableVersionState%2C%200)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgSourceState%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E0%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EPkgServerAction%2C%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23008000%3B%22%3E%2F*%20will%20be%20updated%20after%20this%20trigger%20*%2F%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EGETUTCDATE()%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgServerLastRefresh%2C%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23008000%3B%22%3E%2F*%20will%20be%20updated%20after%20this%20trigger%20%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23008000%3B%22%3E*%2F%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(s.Status%2C%200)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgStatusStatus%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(s.SourceVersion%2C%200)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgStatusSourceVersion%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(s.UpdateTime%2C%20GETUTCDATE())%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20PkgStatusUpdateTime%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(v.DistributedVersionState%2C%200)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20DPReportedState%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(v.DistributedVersion%2C%200)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20DPReportedVersion%2C%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3EISNULL(v.DistributedVersionTime%2C%20GETUTCDATE())%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAS%3C%2FSPAN%3E%20DPTimeLastReported%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EFROM%3C%2FSPAN%3E%20ContentDistributionNotification%20ins%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EJOIN%3C%2FSPAN%3E%20DistributionPoints%20dp%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eon%3C%2FSPAN%3E%20dp.DPID%20%3D%20ins.DPID%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EJOIN%3C%2FSPAN%3E%20SMSPackages_G%20pkg%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eon%3C%2FSPAN%3E%20pkg.PkgID%20%3D%20ins.PkgID%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EJOIN%3C%2FSPAN%3E%20DistributionContentVersion%20ver%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EON%3C%2FSPAN%3E%20ver.PkgID%20%3D%20ins.PkgID%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAND%3C%2FSPAN%3E%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Epkg.SourceSite%20%3D%20ver.SiteCode%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EAND%3C%2FSPAN%3E%20ver.DPNALPath%20%3D%20N%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E''%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EJOIN%3C%2FSPAN%3E%20PkgStatus_G%20s%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EON%3C%2FSPAN%3E%20s.PkgServer%20%3D%20dp.NALPath%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eand%3C%2FSPAN%3E%20s.ID%20%3D%20ins.PkgID%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EJOIN%3C%2FSPAN%3E%20DistributionContentVersion%20v%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3EON%3C%2FSPAN%3E%20v.DPNALPath%20%3D%20dp.NALPath%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Eand%3C%2FSPAN%3E%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Ev.PkgID%20%3D%20ins.PkgID%20%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewhere%3C%2FSPAN%3E%20ins.PkgID%20%3D%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'TX1000AD'%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20Confirmed%20it%20by%20running%20a%20Profiler%20that%20the%20Insert%20Trigger%20never%20ran.%3C%2FP%3E%0A%3CP%3E-%20Ran%20the%20Insert%20Trigger%20Manually.%20And%20now%20the%20Data%20came%20in%20the%20ContentDistribution.%3C%2FP%3E%0A%3CP%3E-%20But%20still%20the%20Data%20is%20not%20reflecting%20in%20the%20Console.%3C%2FP%3E%0A%3CP%3E-%20Upon%20Verification%20found%20that%20the%20'StateGroup'%20for%20the%20working%20is%201%20in%20the%20ContentDistributionNotifications%20Table.%20But%20in%20our%20case%20it%20is%200.%3C%2FP%3E%0A%3CP%3E-%20Found%20that%20there%20is%20Trigger%20for%20the%20ContentDistribution%20table%20%5B%20%3CI%3E%20tr_ContentDistribution_Notification%20%3C%2FI%3E%20%5D%20which%20updates%20that%20in%20the%20ContentDistributionNotification%20table.%20And%20that%20also%20did%20not%20run.%3C%2FP%3E%0A%3CP%3E-%20Ran%20the%20same%20manually%20and%20the%20StateGroup%20changed%20to%201.%3C%2FP%3E%0A%3CP%3E-%20The%20console%20now%20shows%20the%20same%20as%20installed.%3C%2FP%3E%0A%3CP%3E-%20So%20not%20sure%20why%20the%20insert%20trigger%20did%20not%20work%20for%20-%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20ContentDistributionNotification%3C%2FP%3E%0A%3CP%3E2.%20ContentDistribution%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20One%20thing%20which%20is%20now%20known%20to%20us%20is%20that%20only%20the%20first%20trigger%20on%20the%20PkgServers_G%20ran%20and%20after%20that%20none%20of%20the%20triggers%20ran.%20Rings%20a%20bell!!!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20The%20setup%20has%20not%20worked%20from%20August%20and%20upon%20checking%20found%20that%20the%20SQL%20was%20upgraded%20to%20SQL%202012.%20So%20chances%20are%20that%20the%20SQL%20properties%20could%20be%20modified.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20Followed%20the%20link%20-%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms190946(v%3Dsql.110).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms190946(v%3Dsql.110).aspx%20%3C%2FA%3E%20and%20checked%20the%20option%20for%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.)%20Server%20trigger%20recursion%20and%202.)%20Nested%20triggers%20%3CSTRONG%3E%20which%20was%20OFF%20%3C%2FSTRONG%3E%20.%3C%2FP%3E%0A%3CP%3E-%20Set%20it%20on%20by%20running%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Esp_configure%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'show%20advanced%20options'%3C%2FSPAN%3E%20%2C%201%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ereconfigure%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewith%3C%2FSPAN%3E%20override%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Esp_configure%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'server%20trigger%20recursion'%3C%2FSPAN%3E%20%2C%201%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ereconfigure%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewith%3C%2FSPAN%3E%20override%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20%23f4f4f4%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3Esp_configure%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23006080%3B%22%3E'nested%20triggers'%3C%2FSPAN%3E%20%2C%201%3C%2FPRE%3E%0A%3CPRE%20style%3D%22box-sizing%3A%20border-box%3B%20overflow%3A%20visible%3B%20font-family%3A%20'Courier%20New'%2C%20courier%2C%20monospace%3B%20font-size%3A%208pt%3B%20display%3A%20block%3B%20padding%3A%200px%3B%20margin%3A%200em%3B%20line-height%3A%2012pt%3B%20color%3A%20black%3B%20word-break%3A%20break-all%3B%20overflow-wrap%3A%20break-word%3B%20background-color%3A%20white%3B%20border%3A%201px%20none%20%23cccccc%3B%20border-radius%3A%204px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%20direction%3A%20ltr%3B%20width%3A%20823.625px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ereconfigure%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%22%3Ewith%3C%2FSPAN%3E%20override%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChecked%20now%20and%20the%20issue%20got%20fixed!!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20it%20helps!%20Do%20keep%20working%20and%20sharing!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20margin%3A%200px%200px%2010px%3B%20color%3A%20%23333333%3B%20font-family%3A%20'Segoe%20UI'%2C%20Tahoma%2C%20Arial%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20sans-serif%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20start%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%230000ff%3B%20background-color%3A%20%23ffff00%3B%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20calibri%3B%20font-size%3A%20small%3B%22%3EUmair%20Khan%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CBR%20style%3D%22box-sizing%3A%20border-box%3B%22%20%2F%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23ffff00%3B%20background-color%3A%20%23000000%3B%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3ESupport%20Escalation%20Engineer%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSTRONG%20style%3D%22box-sizing%3A%20border-box%3B%20font-weight%3A%20bold%3B%22%3E%7C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20%23ffff00%3B%22%3EMicrosoft%20System%20Center%20Configuration%20Manager%3C%2FSPAN%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20border-box%3B%20margin%3A%200px%200px%2010px%3B%20color%3A%20%23333333%3B%20font-family%3A%20'Segoe%20UI'%2C%20Tahoma%2C%20Arial%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20sans-serif%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20start%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20calibri%3B%20font-size%3A%20small%3B%22%3E%3CEM%20style%3D%22box-sizing%3A%20border-box%3B%22%3EDisclaimer%3A%26nbsp%3BThis%20posting%20is%20provided%20%22AS%20IS%22%20with%20no%20warranties%20and%20confers%20no%20rights.%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-339941%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20TECHNET%20on%20Oct%2002%2C%202014%20Hi%20Folks%2CLately%20was%20looped%20in%20an%20issue%20where%20we%20target%20a%20DP%20to%20the%20package%20and%20from%20the%20DistMgr.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

First published on TECHNET on Oct 02, 2014
https://blogs.technet.microsoft.com/umairkhan/2014/10/02/the-case-of-the-unexplained-the-package-get...

 

Hi Folks,

 

Lately was looped in an issue where we target a DP to the package and from the DistMgr.log it shows 2301 for the package being successfully send to the DP and verified in the ContentLib too but does not show in the console. It stays 0.

 

I’ve a key created before on the info of the flow in background. There are 4 main Global tables which are responsible for other updates on other tables via Trigger –

 

 

1. SMSPackages_G
           |
[tr_SMSPackages_ContentNotification] -> ContentDistribution
                                                |    
                                       [tr_ContentDistribution_Notification] -> ContentDistributionNotification
                                                                                          |
                                                                              [tr_ContentDistributionNotification_Summarizer] ->  ContentDistributionMessages

 

 

 2. PkgServers_G 
         | 
[ tr_PkgServers_G_ContentNotification ] –>ContentDistributionNotification -[ tr_ContentDistributionNotification_insert ] –>ContentDistribution
 
–>[Cont] ContentDistribution                                                                  
                 | 
[ tr_ContentDistributionNotification_Summarizer ] –>  ContentDistributionMessages
| [tr_ContentDistribution_Notification] -> ContentDistributionNotification

 

3. PkgStatus_G 
	| 
[tr_PkgStatus_G_ContentNotification]-> ContentDistribution 
						| 
				[tr_ContentDistribution_Notification] -> ContentDistributionNotification 
											|
 									[tr_ContentDistributionNotification_Summarizer] ->  ContentDistributionMessages
4. DistributionStatus 
	 | 
[ tr_DistributionStatus_ContentNotification ] -> ContentDistributionMessages

- Use the 2 nd one above for this case as we are tracking the DP targeting.

 

Now in our case, I see the entry in the PkgServers_G table for the DP being added.

Checking for the package

 
select * from smspackages where pkgid = 'TX1000AD'
select * from PkgServers_G where pkgid = 'TX1000AD'
select * from ContentDistributionNotification where pkgid = 'TX1000AD'
select * from ContentDistribution where pkgid = 'TX1000AD'

 

- So I see the ContentDistributionNotification has the value but ContentDistribution table does not.

 

- So the insert trigger [ tr_ContentDistributionNotification_insert ] on the ContentDistributionNotification table is not running.

- Got a snippet of the trigger [see below] and modified it to return and check if that has the value and yes we do see the value, so if this trigger was run it would have send the updates to the other tables.

 
SELECT ins.DistributionID,
ins.DPID,
ins.PkgID 
AS PkgID,
ISNULL(ver.AvailableVersionState, 0) AS PkgSourceState,
0 
AS 
PkgServerAction, /* will be updated after this trigger */
GETUTCDATE() AS PkgServerLastRefresh, /* will be updated after this trigger 
*/
ISNULL(s.Status, 0) AS PkgStatusStatus,
ISNULL(s.SourceVersion, 0) AS PkgStatusSourceVersion,
ISNULL(s.UpdateTime, GETUTCDATE()) AS PkgStatusUpdateTime,
ISNULL(v.DistributedVersionState, 0) AS DPReportedState,
ISNULL(v.DistributedVersion, 0) AS DPReportedVersion,
ISNULL(v.DistributedVersionTime, GETUTCDATE()) AS DPTimeLastReported 
FROM ContentDistributionNotification ins 
JOIN DistributionPoints dp on dp.DPID = ins.DPID 
LEFT JOIN SMSPackages_G pkg on pkg.PkgID = ins.PkgID 
LEFT JOIN DistributionContentVersion ver ON ver.PkgID = ins.PkgID AND 
pkg.SourceSite = ver.SiteCode AND ver.DPNALPath = N''
LEFT JOIN PkgStatus_G s ON s.PkgServer = dp.NALPath and s.ID = ins.PkgID 
LEFT JOIN DistributionContentVersion v ON v.DPNALPath = dp.NALPath and 
v.PkgID = ins.PkgID 
where ins.PkgID = 'TX1000AD'

 

- Confirmed it by running a Profiler that the Insert Trigger never ran.

- Ran the Insert Trigger Manually. And now the Data came in the ContentDistribution.

- But still the Data is not reflecting in the Console.

- Upon Verification found that the 'StateGroup' for the working is 1 in the ContentDistributionNotifications Table. But in our case it is 0.

- Found that there is Trigger for the ContentDistribution table [ tr_ContentDistribution_Notification ] which updates that in the ContentDistributionNotification table. And that also did not run.

- Ran the same manually and the StateGroup changed to 1.

- The console now shows the same as installed.

- So not sure why the insert trigger did not work for -

 

1. ContentDistributionNotification

2. ContentDistribution

 

- One thing which is now known to us is that only the first trigger on the PkgServers_G ran and after that none of the triggers ran. Rings a bell!!! :)

 

- The setup has not worked from August and upon checking found that the SQL was upgraded to SQL 2012. So chances are that the SQL properties could be modified.

 

- Followed the link - http://msdn.microsoft.com/en-us/library/ms190946(v=sql.110).aspx and checked the option for

 

1.) Server trigger recursion and 2.) Nested triggers which was OFF .

- Set it on by running:

 

sp_configure 'show advanced options' , 1
reconfigure with override
sp_configure 'server trigger recursion' , 1
reconfigure with override
sp_configure 'nested triggers' , 1
reconfigure with override

 

Checked now and the issue got fixed!! :)

 

Hope it helps! Do keep working and sharing!

 

Umair Khan
Support Escalation Engineer | Microsoft System Center Configuration Manager 

Disclaimer: This posting is provided "AS IS" with no warranties and confers no rights.