Scott Roth · Jun 11, 2025 go to post

[HealthConnect:3.5.0-1.m1]

it was a group permission issue with the directory. However, once I created the DB, added it to the mirror on the Primary, I cannot get it to Sync with the others in the mirror. I removed it from the mirror for now till I have time to look at it again.

Scott Roth · Jun 11, 2025 go to post

While I have applauded the updates, I have given feedback to the UX design team, as at times it seems clunky if we have big namespaces.

Scott Roth · Jun 10, 2025 go to post

I need to take the Encoded Stream and send it as an Encoded String. How would I take a Stream and send it as a String?

Scott Roth · Jun 6, 2025 go to post

I dismounted, secure copied the IRIS.dat to my backup/DR and mount the Database, but when I attempt to Activate Mirror Database on the backup, I am getting the following error...

sc="0 "_$lb($lb(2073,"/ensemble/TEST/DB/TESTING/",,,,,,,,$lb(,"%SYS",$lb("e^ActivateMirroredDatabase+3^SYS.Mirror.1^2","e^^^0"))))/* ERROR #2073: Mirrored Database '/ensemble/TEST/DB/TESTING/' is not found on this system */
 

but it shows that the database has been mounted in the Terminal.

Scott Roth · Jun 2, 2025 go to post

Still not working right..

Class osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port Extends Ens.BusinessOperation [ ProcedureBlock ]
{

Parameter ADAPTER = "EnsLib.SOAP.OutboundAdapter";Property LocalInterface As%String(MAXLEN = 255);Parameter SETTINGS = "LocalInterface:Connection:selector?context={Ens.ContextSearch/TCPLocalInterfaces}";

Method OnInit() As%Status
{
	If 'IsObject(..Adapter.%Client.HttpRequest) {
		Set..Adapter.%Client.HttpRequest=##class(%Net.HttpRequest).%New()
	}
	Set..Adapter.%Client.HttpRequest.LocalInterface=$ZStrip($P(..LocalInterface,"("),"*W")
}

Terminating Job 819984 / 'NutritionCBOARDNetMenuSOAP' with Status = ERROR <Ens>ErrException: <SUBSCRIPT>OnInit+1^osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port.1 *IsObject("") -- logged as '-' number - @' If 'IsObject(..Adapter.%Client.HttpRequest) {', %QuitTask=

Scott Roth · Jun 2, 2025 go to post
Class osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port Extends (Ens.BusinessOperation, EnsLib.SOAP.GenericOperation) [ ProcedureBlock ]
{

Parameter ADAPTER = "EnsLib.SOAP.OutboundAdapter";Property LocalInterface As%String(MAXLEN = 255);Parameter SETTINGS = "LocalInterface:Connection:selector?context={Ens.ContextSearch/TCPLocalInterfaces}";

Method OnInit() As%Status
{
	set interface = $ZStrip($P(..LocalInterface,"("),"*W")
    Set ..%Client.HttpRequest=##class(%Net.HttpRequest).%New()
	set ..%Client.HttpRequest.LocalInterface = interface
	QUIT$$$OK
}

I tried using ..%Client but got..

ERROR: osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port.cls

ERROR:  osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port.1(4) : MPP5376 : Method or Property '%Client' does not exist in this class.

 TEXT:   Set ..%Client.HttpRequest=##class(%Net.HttpRequest).%New()

ERROR:  osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port.1(5) : MPP5376 : Method or Property '%Client' does not exist in this class.

 TEXT:  set ..%Client.HttpRequest.LocalInterface = interface

When I tried to compile.

Scott Roth · Jun 2, 2025 go to post

I ended up doing..

Class osuwmc.Nutrition.OSU.CBOARDNetMenuOperation.CBORDHL7Port Extends (Ens.BusinessOperation, EnsLib.SOAP.GenericOperation) [ ProcedureBlock ]
{

Parameter ADAPTER = "EnsLib.SOAP.OutboundAdapter";Property LocalInterface As%String(MAXLEN = 255);Parameter SETTINGS = "LocalInterface:Connection:selector?context={Ens.ContextSearch/TCPLocalInterfaces}";

Method OnInit() As%Status
{
	set interface = $ZStrip($P(..LocalInterface,"("),"*W")
	set HttpRequest = ##class(%Net.HttpRequest).%New()
	set HttpRequest.LocalInterface = interface
	$$$LOGINFO("CBORDHL7Port OnInit: LocalInterface="_interface)
	QUIT$$$OK
}

The $$$LOGINFO is showing the correct address, but I am still having issues connecting. But thanks

Scott Roth · Jun 2, 2025 go to post

This has been presented in each of the previous Global Summit's conferences. We will be reviewing it again at this years InterSystems READY 2025. Orlando Health has been the mainstay in the Development work of this tool. Please see previous session recordings via You Tube.

Integration Production Tools: HealthShare Health Connect & InterSystems IRIS Health
https://www.youtube.com/watch?v=61Nduu5UyS0&ntb=1&msockid=232752513fc511f08781af03632c4a64

 

Scott Roth · May 30, 2025 go to post

I am not sure I quite understand the question, but I just recently wrote EnsLib.SQL.InboundAdapters that will query MS SQL Server and write the data directly to IRIS Cache Tables I built, so in that sense it is possible. But if you have a service that is listening for a connection to query IRIS Tables, then I think you would want to build like an API listener that then queries the tables.

Scott Roth · May 28, 2025 go to post

Hello Community,

  • My name is Scott Roth
  • I am from the United States, and currently live in Columbus, Ohio.
  • I am a Sr Application Development Analyst for the The Ohio State University Wexner Medical Center
  • I have been in Health Care Integration for 21 years and have been using InterSystems HealthShare Health Connect since 2015. I became a Developer Community Moderator in 2016/2017
  • I’m a Health Care Integration Developer with hands-on experience in HL7. Beyond standard interface development, I focus on enhancing our integration capabilities by exploring new tools, technologies, and architectural approaches to improve interoperability and streamline workflows.
  • Currently working with and on developing the Health Share Provider Directory with Managed Services to hopefully one day replace our homegrown built Provider Master Solution.
  • I can be found on Linked In
  • I will be presenting at InterSystems Ready 2025 on Tuesday afternoon at 2:30  
Scott Roth · May 28, 2025 go to post

Thanks responseData.items.%Get(0).titles.%Get(0).value.%Get("en_US") did the trick

Scott Roth · May 14, 2025 go to post

After talking with the vendor, they mentioned they had a .wsdl that could be used to send the HL7 message via a SOAP connection. I took the wsdl and ran it through the SOAP wizard to create the basic classes. Now we are waiting on a firewall request to allow us to communicate with the vendor over port 443.

Scott Roth · May 7, 2025 go to post

 If the Response you get from a REST call is a %DynamicAbstractObject, how do you know how many levels to go through? 

I tried using JSON2Persistant however the naming convention of the tree that it is building it too long for me to upload it into github, so since I have two values that I need to only retrieve I am attempting to iterate through the JSON and just extract those two values

for example, if I only want to pull the pureId and the portalURL from the response object, how can I iterate through the JSON response to get those values only? 

{
  "count": 0,
  "pageInformation": {
    "offset": 0,
    "size": 0
  },
  "items": [
    {
      "pureId": 0,
      "uuid": "196ab1c9-6e60-4000-88cb-4b1795761180",
      "createdBy": "string",
      "createdDate": "1970-01-01T00:00:00.000Z",
      "modifiedBy": "string",
      "modifiedDate": "1970-01-01T00:00:00.000Z",
      "portalUrl": "string",
      "prettyUrlIdentifiers": [
        "string"
      ],
      "previousUuids": [
        "string"
      ],
      "version": "string",
      "startDateAsResearcher": "1970-01-01",
      "affiliationNote": "string",
      "dateOfBirth": "1970-01-01",
      "employeeStartDate": "1970-01-01",
      "employeeEndDate": "1970-01-01",
      "externalPositions": [
        {
          "pureId": 0,
          "appointment": {
            "uri": "string",
            "term": {
              "en_GB": "Some text"
            }
          },
          "appointmentString": {
            "en_GB": "Some text"
          },
          "period": {
            "startDate": {
              "year": 0,
              "month": 1,
              "day": 1
            },
            "endDate": {
              "year": 0,
              "month": 1,
              "day": 1
            }
          },
          "externalOrganization": {
            "uuid": "196ab1c9-6e60-4000-8b89-29269178a480",
            "systemName": "string"
          }
        }
      ],

when I attempted 

set itr = responseData.%GetIterator()
    while itr.%GetNext(.key, .value) {
      if key = "pureID"{
        set pResponse.pureID = value
      } elseif key = "portalURL" {
        set pResponse.portalURL = value
      }
    }

both the pureID and portalURL came back blank.

Scott Roth · May 6, 2025 go to post

Typically, it would only be one message schema, but I understand what you mean by creating a copy of the EnsLib.HL7.Operation.TCPOperation. I'll keep that in mind if I want to explore this further.

Scott Roth · May 6, 2025 go to post

How do we take the JSON response, iterate through it to put it into a data class structure that could be used? Using JSON2Persistent, I took a JSON response and converted it into a Data Class Structure.

Scott Roth · May 5, 2025 go to post

Adding a Pre-Processing Router on top seems like it would work, but it's not really efficient when you are struggling with processing, cpu, memory etc... it adds another process on top of everything else.

Scott Roth · May 5, 2025 go to post

My task class is calling another Method in another class file that is set to write, but when the Task ran, I got was a blank Output File.

Scott Roth · May 1, 2025 go to post

I just had a similar issue, where there were 25 sessions open with my name. We hit our limit of licenses, so I ended up killing what I was not using so it did not interrupt my team. I did not capture the Timeout (UTC) before I did it, but should of.

After I freed up sessions, I did notice that if I opened VSCode that /api/atelier sessions still opened after I had closed out VS Code. We have the CSP Inactivity Timeout on the Web Gateway to 24 hrs, so I don't know if those sessions were over that timeframe or not.

Scott Roth · Apr 28, 2025 go to post

I have an Identifier that I receive in an HL7 MFN message, I need to take this Identifier and find the Locations that the Identifier is associated with, so I can set the Sending Facility value within the HL7 message to help filter out specific locations from being sent to the Health Share Provider Directory.
for example... ID1 might be associated with Site 1, Site 3. IF site 1 is valued and equals xxx, then send on else do not send on.

Scott Roth · Apr 22, 2025 go to post

I was able to get it to work. I found that in Cache I need to call %Get("<column>") name vs what I am doing in a BPL.

s Loc = ""s tStatement = ##class(%SQL.Statement).%New()
 s execall= "CALL osuwmc_Utils_EnterpriseDirDb.InterfaceCheckConnectMedCtrID(?)"s qStatus = tStatement.%Prepare(execall)
 if$$$ISERR(qStatus) {write"%Prepare failed:"do$SYSTEM.Status.DisplayError(qStatus) quit}
 set rset = tStatement.%Execute(pInput)
 while rset.%Next() {
 set Loc = rset.%Get("OSUguestRoleDTL")
 }
 if$Length(Loc) = 0 {
    set Loc = "OSUWMC"
 }
Scott Roth · Apr 14, 2025 go to post

The Class name is osuwmc.Epic.Clarity.DepartmentMaster and it is storing data in 

  • Data - ^E2C8.D9IS.1
  • BitmapExtent Index - ^E2C8.D9IS.2
  • IDIndex Index - ^E2C8.D9IS.3
  • IDKey Index - ^E2C8.D9IS.1
  • Indexes - ^E2C8.D9IS.I
  • Stream - ^E2C8.D9IS.S

I am not sure what to put in as the Global Name, would that be E2C8? and then the subscript to be mapped would be D9IS.*?

Scott Roth · Apr 14, 2025 go to post

I am also trying to map a Database table from one namespace to another. When I enter the following into the %ALL namespace as the global map, when I select from that table in the second namespace I get no results.

Scott Roth · Apr 3, 2025 go to post

The rule was just routing the message through a DTL and sending it to two places in the same line.

The message size was 12661.

My team member just ended up splitting up the send line into multiple send lines instead of a single send line with two destinations.

Scott Roth · Apr 2, 2025 go to post

interesting theory to try, someone on my team changed it to cover it to stream, and put it back into the message before this answer. the Physician memory usage went down, the virtual memory usage went up. However, the error seemed more at the Routing than the DTL. It may have something to do with Locking and trying to send to multiple locations in a single send.

Scott Roth · Apr 1, 2025 go to post

With the way that we built our namespaces, I had to create a smaller namespace that included all of our nuances that we do like... BPL making JDBC MS SQL Stored Procedure calls, making internal cache calls, making linked table/store procedure calls.

Larger namespaces will cause the comparison run to take longer to run.

So, my mini namespace is used to test new versions of HealthShare Health Connect.

Scott Roth · Mar 17, 2025 go to post

I ended up doing a BS for each query that I was pulling into an Internal Cache Table. Adding a Service and BP would cause more overhead system resource wise.

Scott Roth · Mar 13, 2025 go to post

The issue was with the query I was using. Those that wrote the query were renaming columns with ' ' but putting spaces in the new names. 

SELECT A AS 'ABC CDE' FROM TableName

I think there was the Typo in my service code, because I never use spaces and assumed that the column names did not have spaces.