go to post Jeffrey Drumm · Jan 4, 2020 I had tried PublicList as well. See my comment on Eduard's answer ... I think it may not be possible to set the "top level" error code returned from the SELECT (which is what I was hoping to do).
go to post Jeffrey Drumm · Jan 4, 2020 Hi Eduard, and thanks! I had already tried that option, but discarded it because the SQL code returned is <-149>:<SQL Function encountered an error>, with my error code and text as a subordinate (child?) error. Is there any way to set the "parent" SQLCODE and associated error text? Or is that effectively the "query" error, with the child error generated by the SqlProc?
go to post Jeffrey Drumm · Jan 4, 2020 Thanks Robert, but setting ProcedureBlock = 0 had no effect. I'm not getting any errors when setting the properties for %sqlcontext, but its properties don't seem to be exposed to the caller in a way that either the SQL shell or the ODBC invocation see as an error. I've tried setting SQLCODE as well with no effect.
go to post Jeffrey Drumm · Dec 30, 2019 Execution details for routing rules are located in Ens.Rule.Log. The available values are ID, ActivityName, ConfigName, CurrentHeaderId, DebugId, EffectiveBegin, EffectiveEnd, ErrorMsg, IsError, Reason, ReturnValue, RuleName, RuleSet, SessionId, and TimeExecuted. In the SQL facility, you can query Ens_Rule.log: SELECT ID, ConfigName, CurrentHeaderId, RuleName, RuleSet, SessionId, TimeExecuted FROM Ens_Rule.Log
go to post Jeffrey Drumm · Dec 29, 2019 Since the class didn't exist before I wrote it earlier today, you can be forgiven for not knowing about it
go to post Jeffrey Drumm · Dec 29, 2019 Assuming the stream contains the normal $C(13) segment delimiters: Class User.HL7.Stream Extends %RegisteredObject { ClassMethod GetCounts(pStream As %Stream.FileCharacter, Output pMsgCount As %Numeric, Output pSegCounts As %ArrayOfDataTypes) As %Status { Do pStream.Rewind() Set pStream.LineTerminator = $C(13) Set pSegCounts = 0 While 'pStream.AtEnd { Set tLine = pStream.ReadLine() // Remove leading control characters Set tSeg = $ZSTRIP(tLine,"<C") // Get the segment name Set tSegName = $EXTRACT(tSeg,1,3) If tSegName '= "" { If '$DATA(pSegCounts(tSegName)) { // We have a new subscript Set pSegCounts = pSegCounts + 1 Set pSegCounts(tSegName) = 1 } Else { Set pSegCounts(tSegName) = pSegCounts(tSegName) + 1 } } } Set pMsgCount = pSegCounts("MSH") Return $$$OK } } Call the classmethod with the stream as follows: Do ##class(User.HL7.Stream).GetCounts(stream,.Msgs,.Counts) Counts will be subscripted by the segment names found in the message stream. In the above example, you'll find the occurrence count of FT1 segments in Counts("FT1") and the number of messages will be in Counts("MSH"). The value returned in Msgs is the same as Counts("MSH").
go to post Jeffrey Drumm · Dec 17, 2019 If you have access to Caché terminal, you can run run queries that won't time out: (the sample below assumes your namespace is "PROD"; just substitute whatever your production's namespace is for that). USER> zn "PROD" PROD> d $system.SQL.Shell() SQL Command Line Shell---------------------------------------------------- The command prefix is currently set to: <<nothing>>.Enter q to quit, ? for help.PROD>>SELECT COUNT(*) AS AlertCount FROM Ens.MessageHeader WHERE MessageBodyClassName = 'Ens.AlertRequest' AlertCount2205 PROD>>Q PROD> So ... if you don't have BodiesToo checked, you most likely have lots of orphaned message bodies taking up database space. And KeepIntegrity is probably retaining a lot of message headers (and associated bodies) that you don't care about anymore. There are reasons you would not want to turn KeepIntegrity off in earlier versions of Caché/Ensemble, like pre-2015 releases. If you're on a release more modern than that and you don't need to worry about messages with parent/child relationships (certain batch types, for example), you can probably turn that off. There are a couple of articles regarding the management of orphaned bodies here on DC. Might be worthwhile to peruse them :)
go to post Jeffrey Drumm · Dec 17, 2019 MAX(ID) isn't necessarily the record count. Try a "select count(*) from Ens.AlertRequest" query and see what you get. Compare that to "'select count(*) from Ens.MessageHeader where MessageBodyClassName = 'Ens.AlertRequest'" If the numbers are in line with the MAX(ID), then my suspicion is that you either don't have "BodiesToo" checked or do have "KeepIntegrity" checked in your purge process configuration. Either of those may be keeping old Ens.AlertRequest bodies around.
go to post Jeffrey Drumm · Dec 17, 2019 If you could provide a little more detail on your use case, there may be a solution that doesn't involve developing a custom service. For example, you could configure the service with a filename pattern that would retrieve all matching files in the target path, but discard, via a routing rule, any that do not meet the date criteria. The name of the file should be available in the Source property of the message object.
go to post Jeffrey Drumm · Dec 16, 2019 printf formatting tokens (%Y, %m, %d, etc.) are not wildcard characters. You'll be limited to legal file naming characters and OS/Shell specific wildcard characters such as * and ? for fetching files.
go to post Jeffrey Drumm · Dec 12, 2019 Select something for the "In files/file types:" field, then enter a search value. You can also do it in reverse order, but both fields are required
go to post Jeffrey Drumm · Dec 5, 2019 You haven't specified an iteration for ORCgrp(). If there's only one ORC group in your messages, you should use ORCgrp(1).
go to post Jeffrey Drumm · Dec 5, 2019 If the layout of each record is identical, a simple record map populated through a BPL/DTL combo would be the preferred solution.
go to post Jeffrey Drumm · Nov 27, 2019 Define them as properties in your task class: Class User.Task.MessageArchive Extends %SYS.Task.Definition { /// Base directory for the archived files Property BaseDir As %String [ InitialExpression = "/hsf/archive/" ]; /// The date of the 24 hour period from which the messages will be selected (midnight to midnight) Property DaysOld As %Integer [ InitialExpression = 23 ]; /// When selected, messages received from services will be archived Property MessagesInbound As %Boolean [ InitialExpression = 1 ]; /// When selected, messages sent to operations will be archived Property MessagesOutbound As %Boolean [ InitialExpression = 1 ]; /// Send Notification Email Property NotifyByEmail As %Boolean [ InitialExpression = 0 ]; These properties can then be referenced in your task's methods with the .. prefix notation.
go to post Jeffrey Drumm · Nov 24, 2019 I've done something similar with COS, but in my case it was the ORC group that was repeating: Class HICG.Process.MultiORC Extends Ens.BusinessProcess [ ClassType = persistent ] { Property TargetConfigNames As %String(MAXLEN = 1000); Parameter SETTINGS = "TargetConfigNames:Basic:selector?multiSelect=1&context={Ens.ContextSearch/ProductionItems?targets=1&productionName=@productionId}"; Method OnRequest(pRequest As EnsLib.HL7.Message, Output pResponse As Ens.Response) As %Status { Set tORCcnt = pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp(*)") For i=1:1:tORCcnt { Set tMsg = ##class(EnsLib.HL7.Message).%New() Set tMsg.DocType = pRequest.DocType // Keep MSH:10 unique Set tMsgCtrl = pRequest.GetValueAt("MSH:10")_"."_i Do tMsg.SetValueAt(pRequest.GetValueAt("MSH"),"MSH") Do tMsg.SetValueAt(tMsgCtrl,"MSH:10") Do tMsg.SetValueAt(pRequest.GetValueAt("PIDgrpgrp(1).PIDgrp.PID"),"PIDgrpgrp(1).PIDgrp.PID") Do tMsg.SetValueAt(pRequest.GetValueAt("PIDgrpgrp(1).PIDgrp.PV1grp.PV1"),"PIDgrpgrp(1).PIDgrp.PV1grp.PV1") Do tMsg.SetValueAt(pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp("_i_").ORC"),"PIDgrpgrp(1).ORCgrp(1).ORC") Do tMsg.SetValueAt(pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp("_i_").OBR"),"PIDgrpgrp(1).ORCgrp(1).OBR") Set tOBXcnt = pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp("_i_").OBXgrp(*)") For j=1:1:tOBXcnt { Do tMsg.SetValueAt(pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp("_i_").OBXgrp("_j_").OBX"),"PIDgrpgrp(1).ORCgrp(1).OBXgrp("_j_").OBX") } Set tSC = tMsg.%Save() $$$TRACE(tSC) For iTarget=1:1:$L(..TargetConfigNames, ",") { Set tTarget=$ZStrip($P(..TargetConfigNames,",",iTarget),"<>W") Continue:""=tTarget Set tSC1 = ..SendRequestAsync(tTarget,tMsg) Set:$$$ISERR(tSC1) tSC=$$$ADDSC(tSC,tSC1) } } Return tSC }
go to post Jeffrey Drumm · Oct 16, 2019 The audit log can provide information on who changed a production configuration, such as adding or modifying a business host configuration. It does not contain information on who modified or created a routing rule, DTL, BPL or other class associated with running a production. For the latter you should consider implementing a Source/Version control system that controls how those components progress from development through QA to Prod and tracks who made those changes. Deltanji from George James Software is a strong contender in that area.
go to post Jeffrey Drumm · Oct 13, 2019 Did you select EnsLib.HL7.Service.SOAPService as your service's class? If yes, then I know the following XML format works: <?xml version="1.0" encoding="UTF-8" ?> <SOAP-ENV:Envelope xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:s='http://www.w3.org/2001/XMLSchema'> <SOAP-ENV:Body> <Send xmlns="http://tempuri.org"> <Input> <![CDATA[MSH|^~\&|... rest of hl7 message here, with <CR><LF> at end ]]> </Input> </Send> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
go to post Jeffrey Drumm · Oct 12, 2019 I'm assuming you don't have "Act on Validation Error" enabled in the router's settings ... in which case the message will be set to Completed status even though it failed validation. If you enable "Act on Validation Error" its status will be set to Error; you'll then be able to select for that status in the Message Viewer and resend. Note that with this setting enabled, you may want to set "Reply Code Actions" to do something other than the default, such as sending the messages to the Suspended Messages facility. Another option would be to specify a Bad Message Handler; this forwards failed validations to a business host where other actions can be taken such as alerting or logging to a file. You'll also have the option of resubmitting those messages to their original destination by specifying a new target in the Message Viewer's Resend facility.
go to post Jeffrey Drumm · Sep 30, 2019 I've found that the MessageStructure component is, more often than not, unvalued. This should do the trick for all cases where there is a minimally compliant MSH:9 field: $REPLACE($PIECE(pRequest.GetValueAt("MSH:MessageType"),pRequest.CS,1,2),pRequest.CS,"")