Honestly,  I'm trying to figure out under what conditions the Production gets recompiled.  The only fix is to stop and restart the Production, which obviously is not ideal in a live environment...

Thanks!   I think this would have gotten me there too!

Thanks!   I was almost there...  I think this will work nicely!

I think this has the same problem I describe in my reply above.  

Unfortunately, Vendorname is just a placeholder for the section of the String I need to extract.  I'm trying to find a way to pull that section (i.e. the 2nd Capitalized word) from the string without naming it.

i.e.:

FromEpicADT  > "Epic"

ToHealthshareNorthADT  > "Healthshare"

Thanks.  Didn't like the "set RawContent = ##class(EnsLib.HL7.Message).%OpenId(pID).OutputToString()" piece for some reason, so ended up with a seoncd SQL statement to pull the data.  Here is my custom function code:

ClassMethod CHNwGetRawMessageForAlerts(
pSessionID As %String = "",
pTargetName As %String = "") As %String
{
    set HL7RawContent= "Message Not Found: Contact Interface Team"
    set pID = ""
    
         &sql(
            SELECT TOP 1 MessageBodyId INTO :pID
            FROM Ens.MessageHeader
            WHERE (TargetConfigName=:pTargetName AND SessionId=:pSessionID)
            OR (SourceConfigName=:pTargetName AND SessionId=:pSessionID)
        )
        if SQLCODE '= 0 {
            set HL7RawContent = "SQL1 Message Not Found: Contact Interface Team"
        }
        else
        {
            &sql(
            SELECT RawContent INTO :HL7RawContent
            FROM EnsLib_HL7.Message
            WHERE ID=:pID
           
        )
        if SQLCODE '= 0 {
            set HL7RawContent = "SQL2 Message Not Found: Contact Interface Team"
        }
        }
    
       Quit HL7RawContent
}