Custom Business Operating - SQL Outbound Adapter Troubleshooting

Question 1

Pergunta

Scott Roth · jan 19, 2024

#Operação de negócios #Processo de negócio #Regras do negócio #JDBC #Health Connect #InterSystems IRIS #InterSystems IRIS for Health

Ran into an issue this morning, that I am having a hard time trying to track down what might have caused the issue. We have a Business Rule that sends HL7 ADT to a Business Process that inserts the data into a MS SQL Server using a Custom Business Operation (SQL Outbound Adapter).

Early yesterday morning the Custom Business Operation reset its connection through the Java Gateway Server to the MS SQL Database, when it reconnected to the Java Gateway/MS SQL Database it stopped processing. So, the Business Rule had over 40,000 queued up to process. There was no indication of an issue by looking at the Namespace, all Rules, Processes, and Operations associated with this workflow were Green.

When I look at the visual trace for the message in question, I see that all the responses were sent back to the Business Proces, and the Business Process showed it sent a Response to the Business Rule. However, after that nothing was processing through the Rule, Process, or Operation.

While I will be setting alerting on the Rule process to notify if there is a significant queue backup or inactivity alert, I would like to still know why the workflow hung. Currently the Rule does not have a "Response From" value set which I will be updating next week, any idea on why it would cause it to hang?

No other connections to that same Java Gateway had the issue.

2 Comments

Discussão (2)2

Entre ou crie uma conta para continuar

Question 2

Pergunta

Flávio Lúcio Na... · jan 19, 2024

#Analytics #FHIR #InterSystems IRIS #InterSystems IRIS for Health

Hello everyone,

I am working with InterSystems IRIS and seeking guidance on how to perform specific tasks related to the FHIR SQL Builder using commands or code, rather than the graphical user interface (GUI). The specific tasks I am trying to accomplish are:

Creating Analyses: What is the recommended method or class in ObjectScript to analyze data in the FHIR repository?
Transformation Specifications: How can I programmatically create transformation specifications? Is there a specific class or a series of commands for this?
Creating Projections: Is there a standard procedure or a set of commands to create projections from transformation specifications?

Now, I am only using the GUI interface to create the Analyses, Transformations, and Projections. However, a method to export and import these configurations through code would also be suitable for me:

I am looking for an approach that doesn't rely on the GUI, but is effective for FHIR data manipulation in the context of InterSystems IRIS. Any code examples, relevant documentation, or practical guidance would be greatly appreciated

Thank you in advance for your assistance!

4 Comments

Discussão (4)5

Entre ou crie uma conta para continuar

Question 3

Pergunta

Michael Wood · jan 19, 2024

#Processo de negócio #FHIR #InterSystems IRIS for Health

I have this response, which is a FHIR location resource in a bundle. I would like to load the entry(0).resource into a context property defined as HS.FHIR.DTL.vR4.Model.Resource.Location so I can use it as a source in a DTL. Any help would be greatly appreciated. Thanks.

{"entry":[{"fullUrl":"https://dev-api.hosp.org/idkl/fhir/r4/v1/Location/ATH-1375-PRV-a-1375.De...","resource":{"extension":[{"url":"https://api.hosp.org/idkl/extensions/StructureDefinition/is-messaging-en...","valueBoolean":true}],"id":"ATH-1375-PRV-a-1375.Department-2","identifier":[{"system":"urn:asc:idkl:ATH:1375:location:department-id","value":"2"},{"system":"urn:asc:idkl:clt:1375:location:base-id","value":"2"},{"system":"urn:asc:idkl:clt:1375:sourceid","value":"a-1375.Department-2"},{"system":"urn:asc:idkl:clt:1375:location:id","value":"a-1375.Department-2"}],"managingOrganization":{"identifier":{"system":"urn:asc:idkl:clt:instance:id","value":"1375"},"reference":"Organization/SYM-DEV-ATH-1375-PRV","type":"Organization"},"meta":{"lastUpdated":"2024-01-17T02:19:09.889639+00:00","source":"ATH-1375-PRV","tag":[{"code":"UNMASTERED","display":"Unmastered Location"},{"code":"HC-Reltio-API","system":"https://api.hosp.org/idkl/value-sets/data-sources"},{"code":"IDKL-EHR-API","display":"IDKL from EHR's API"}],"versionId":"MTcwNTQ1Nzk0OTg4OTYzOTAwMA"},"partOf":{"identifier":{"system":"urn:asc:idkl:rlt:ahnat:location:id","value":"07vMu2k"},"reference":"Location/RLT-DEV-07vMu2k","type":"Location"},"resourceType":"Location"},"search":{"mode":"match"}}],"link":[{"relation":"search","url":"https://dev-api.hosp.org/idkl/fhir/r4/v1/Location?identifier=urn%3Aasc%3..."},{"relation":"first","url":"https://dev-api.hosp.org/idkl/fhir/r4/v1/Location?identifier=urn%3Aasc%3..."},{"relation":"self","url":"https://dev-api.hosp.org/idkl/fhir/r4/v1/Location?identifier=urn%3Aasc%3..."}],"resourceType":"Bundle","total":1,"type":"searchset"}

4 Comments

Discussão (4)4

Entre ou crie uma conta para continuar

Question 4

Pergunta

Mathew Rimmington · jan 18, 2024

#VSCode #InterSystems IRIS

In VSCode using the InterSystems extensions, I now have an almost working environment where routines can be created or modified on disk and these are pushed to the developer's IRIS instance.

One issue I'm finding whilst testing is that if I rename or delete a routine from disk, the change isn't pushed to IRIS and I can't work out how to make this happen.

This means that a developer can have renamed or deleted a file on disk, but can still call functions within the renamed/deleted routine within the IRIS instance and not experience any NOROUTINE errors. The developer might well spot the mistake, but that relies on developer brilliance. I'd much prefer to reflect the rename/deletion within IRIS. Otherwise, the first time a developer will see any NOROUTINE errors is after a new build is made from the contents of the repo.

I'm wondering if there is a setting I can change to make VSCode send renames/deletions via the atelier APIs.

Discussão (0)3

Entre ou crie uma conta para continuar

Pesquisar

Custom Business Operating - SQL Outbound Adapter Troubleshooting

How to Create Analyses, Transformation Specifications, and Projections in FHIR SQL Builder Using Commands?

FHIR payload to FHIR message class

Starting developer preview #1 for InterSystems IRIS, IRIS for Health, & HealthShare Health Connect 2024.1

Highlights

Early Access Programs (EAPs)

Availability and Package Information

VSCode Deleting or Renaming Files