Written by Brian Mason.

CM07 - Package Name Hates Quotes

Here's a new one we ran into this morning.

All ads as of yesterday afternoon never made it to clients.

We checked the site status and found many warnings in the SMS POLICY PROVIDER.

Checking the policypv.log we could see lots of this:

CPolicyProvider::UpdatePeerDPPkgPolicy: could not execute SQL cmd select PolicyID, PolicyAssignmentID, PADBID from PeerDPPkgPolicy where PkgID = "ABC00BE5" and PkgCRC <> "AE242F23"  12/15/2011 11:25:32 AM
Failed to update policy and policy assignment based on package ABC00BE5           12/15/2011 11:25:32 AM
Looking for software policy and policy assignments that should be updated because of changes in package ABC00CCB.            12/15/2011 11:25:32 AM
*** select TSRefProg.PkgID, TSRefProg.Name from PkgPrograms as TSRefProg inner join TS_References as TSRef on TSRefProg.ProgramID = TSRef.TS_ReferenceID inner join TS_TaskSequence as TS on TSRef.TS_ID = TS.TS_ID where TS.TS_ID in (select TS.TS_ID from TS_TaskSequence as TS inner join PkgPrograms as PkgProg on TS.TS_ID = PkgProg.ProgramID where PkgProg.PkgID = "ABC01133" and PkgProg.Name = "ABC - Fix "P" Drive" );~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC25702" and OfferCRC <> "FEF13A34";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2614A" and OfferCRC <> "FA853646";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2614B" and OfferCRC <> "79A5D9C7";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2614D" and OfferCRC <> "A4164F36";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2614E" and OfferCRC <> "8047877D";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26150" and OfferCRC <> "A0FAED93";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26155" and OfferCRC <> "3F6D373D";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2615B" and OfferCRC <> "54CCE29F";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2615D" and OfferCRC <> "3014E2B7";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2615E" and OfferCRC <> "5980ABAD";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2615F" and OfferCRC <> "56C2CCFA";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26162" and OfferCRC <> "BA0A4FBE";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26163" and OfferCRC <> "F43818DA";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26166" and OfferCRC <> "361DFEC8";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26167" and OfferCRC <> "3EDA1B7B";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26168" and OfferCRC <> "CB40F5A5";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC26169" and OfferCRC <> "A4F67E24";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616A" and OfferCRC <> "118DFEC8";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616B" and OfferCRC <> "8E47F5D8";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616C" and OfferCRC <> "42EB5F9C";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616D" and OfferCRC <> "9F255570";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616E" and OfferCRC <> "959294F";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID = "ABC2616F" and OfferCRC <> "760BCEAF";~select PolicyID, PolicyAssignmentID, PADBID, PkgID, ProgramName, ParentPolicyID from SoftwarePolicy where OfferID     12/15/2011 11:25:32 AM

We found an article mentioning that advertisements with forward slashes could cause this. But that wasn't our issue. We found a package with quotes in the name.

ABC - Fix "P" Drive

We deleted the package and the provider log cleared up instantly and clients received their ads again. I think the quotes were enough to through SQL off which normally likes single quotes.

Best to just avoid any punctuation in a name which are SQL reserved characters: > < " & %

Created on 15 December 2011.