All
Accepted answers
Scott Roth · Dec 30, 2025 go to post

Worked with WRC and Product on how we could capture this and send the Data Mapping issues within Provider Directory to a Worklist Task.

Scott Roth · Dec 30, 2025 go to post

I worked with WRC and found out how to create a Template for the ncessary fields.

Scott Roth · Dec 26, 2025 go to post

I have updated the structures so both Request and Response have different %Persistent classes, but I am still running into the same issue.

"

Event Text

Warning 808842808

  
 

Warning on Message body 18@osuwmc.Epic.FHIR.DataStructures.PatientSearch.Request'
/ 17 because Status 'ERROR <Ens>ErrException: <INVALID OREF>Transform+3 ^osuwmc.Scott.FHIR.DemoOutboundHL7Message.1 -- logged as '-'
number - @'
Set:""=source.DocType tBlankSrc=1, source.DocType="ORMORUPDF:MDM_T02"''
matched ReplyCodeAction 1 : 'E=W'
resulting in Action code W"
Scott Roth · Dec 26, 2025 go to post

Great tip, for connections that go through our Firewall to outside of our network using a VPN we typically use a setting of 3600 to ensure we are getting a fresh connection after a period of inactivity.  I have found especially with some of our applications that use AWS, that they are not respecting the Disconnect, so we have to ensure our settings match theirs.

Scott Roth · Dec 17, 2025 go to post

When you say pNewTarget, does that mean the Object that the message should be sent to?

Scott Roth · Dec 16, 2025 go to post

Congrats to all of DC, it has been an honor not only contribute but to learn from everyone as well.

Scott Roth · Dec 16, 2025 go to post

Thanks everyone for contributing so much to make this Developer Community so successful.

Scott Roth · Dec 4, 2025 go to post

@Timothy Leavitt, I had to create a custom business process to ingest the data from JSON into a Record Map I built for the request to FHIR. The JSON FHIR structures don't really work within the Data Transformation tool. 

Our use case is the following: An EMS squad brings in a Trauma Case into our Emergency Room. The Trauma Case is Registered within Epic as Trauma. Until registration or Medical Records updates the Patient record within our EMR, the name will remain Trauma.

However, the EMS folks send a Result for the Medical Record which is Trauma... in our EMR, but they might send an updated name and demographics. Which causes the Result to fail based on Patient Validation errors in the EMR.

So, the design I came up, was to send a Patient Search FHIR query to the EMR to get the demographics that are currently assigned to that Medical Record, use that information to update the Result from the EMS vendor, and send the Result to the EMR to have it post in a timelier manner instead of waiting for a user in the EMR to work the error to post the result to the Patient's Chart.

We have not fully tested the workflow as of yet, but just getting the Request to be sent via FHIR to the EMR, and interpreting the result was the difficult part.

Scott Roth · Nov 24, 2025 go to post

I updated the Record Map to the following...

Now that I included PATTERN and got it to compile how do I get the BS FTP Record Map Object enforce the Patterns. For example, this morning the system still sent blank First Name, and Last Name after I made them required and added the Pattern.

Scott Roth · Nov 10, 2025 go to post

Since the first line contains the column headers, I am using that to key off of.

Scott Roth · Nov 5, 2025 go to post

Epic is moving to using JKU and not individual JWT, has there been any discussion about how to incorporate a JKU (JSON Web Key URL) within Intersystems IRIS?

Scott Roth · Oct 15, 2025 go to post

@John Murray 
When will it be available to 64 bit VS Code? I am getting the following warning...

 The 'gj :: configExplorer' extension is not available in Visual Studio Code for the Windows 64 bit. 

Scott Roth · Oct 7, 2025 go to post

I have selected the results in the past and pasted them into Excel but then you have to update the formatting.

Scott Roth · Sep 9, 2025 go to post

Stay Connected is set at 60, messages are sent to the BO in batches depending on when we receive the HL7 message that it requires a lookup. 

Because this is going through a Java Gateway Business Service it seems like there is a disconnect on when the BO loses connection and pipe that it uses through the Java Gateway Business Service. The BO loses the connection, but the Java Gateway Business Service still thinks it is connected to the Database.

I have tried adding Connection Attributes to the BO, but it has not help.

Business Operation Settings

  <Item Name="PatientBillingDBPoll" Category="PatientBilling,SQL,PROD,CC,VANW,PatFeeder" ClassName="osuwmc.PatientBilling.PatientBillingDBPollOperation" PoolSize="1" Enabled="true" Foreground="false" Comment="Is used to lookup items against clarity tables" LogTraceEvents="true" Schedule="">
    <Setting Target="Adapter" Name="Credentials"></Setting>
    <Setting Target="Adapter" Name="DSN">MS-PatientBilling</Setting>
    <Setting Target="Adapter" Name="JGService">PatientBilling.JavaGateway</Setting>
    <Setting Target="Host" Name="FailureTimeout">20</Setting>
    <Setting Target="Host" Name="ReplyCodeActions">E=R</Setting>
    <Setting Target="Host" Name="AlertOnError">0</Setting>
    <Setting Target="Adapter" Name="StayConnected">60</Setting>
    <Setting Target="Adapter" Name="ConnectionAttributes">"queryTimeout = 30";"socketTimeout = 60";"cancelQueryTimeout = 45";"connectRetryCount = 100";"connectRetryInterval = 5"</Setting>
    <Setting Target="Host" Name="ArchiveIO">1</Setting>
  </Item>

Java Gateway Settings

<Item Name="PatientBilling.JavaGateway" Category="PROD" ClassName="EnsLib.JavaGateway.Service" PoolSize="1" Enabled="true" Foreground="false" Comment="" LogTraceEvents="true" Schedule="">
    <Setting Target="Host" Name="Port">55558</Setting>
    <Setting Target="Host" Name="JavaHome">/usr</Setting>
    <Setting Target="Host" Name="Logfile"></Setting>
    <Setting Target="Host" Name="ClassPath">/nfs/data/drivers/java/*</Setting>
    <Setting Target="Host" Name="JVMArgs">-d64 -Xss512k -Xmx1024m -XX:+DisableExplicitGC -XX:+AggressiveOpts -XX:+ExplicitGCInvokesConcurrent -XX:+UseStringDeduplication -XX:MaxHeapFreeRatio=10 -XX:MinHeapFreeRatio=5</Setting>
  </Item>
Scott Roth · Sep 2, 2025 go to post

d ##class(EnsLib.HL7.SearchTable).BuildIndex()

d ##class(OSU.HL7.SearchTable).BuildIndex()

Scott Roth · Aug 26, 2025 go to post
  • Went to the sea or a lake
    • No
  • Hiked/enjoyed nature
    • No
  • Traveled somewhere new
    • No
  • Attended a concert or festival
    • No
  • Watched a movie or series
    • Yes
  • Read a book
    • No
  • Earned points and redeemed a reward on Global Masters 🏆
    • Yes
  • Joined READY 2025 🎉
    • Yes
  • Spent time with family or friends
    • Yes
Scott Roth · Aug 11, 2025 go to post

I have many examples of doing this, as we have Operations that write and read data from MS SQL using stored procedures.

You said your problem is with the email, how is the email defined within the Message Data Class?

Typically I create a Message Data Class for the Parameters of the Stored Procedure and use that Message Data Class to send to my EnsLib.SQL.OutboundAdapter which is using the Message Class to map to the Class Method that sends the Execution call to the Stored Procedure on MS SQL.

If you need more help, feel free to reach out.

Scott Roth · Aug 7, 2025 go to post

When I had originally tried executing the POST request, it came back blank, but now it is coming back populated

Scott Roth · Aug 6, 2025 go to post

Thanks, but when I try that I am getting nothing in return when I know the query should be returning something.

{
    "status": {
        "errors": [],
        "summary": ""
    },
    "console": [],
    "result": {}
}
Scott Roth · Aug 4, 2025 go to post

I don't believe I built it within that table. It is a simple table to reference Epic Department information that I query from Epic Clarity.

Scott Roth · Aug 4, 2025 go to post

I just realized the Document I was looking at was for 2025.2 not 2025.1 that I am on. I think I will ahve to go down the route of building the API manually.

Scott Roth · Aug 4, 2025 go to post

When I reformat the request to

{
"query": "SELECT ID, Name FROM osuwmc_Epic_Clarity.DepartmentMaster WHERE ID = 300000000",
"index": "IDKEY",
"option": 1,
"debug": true
}

I am not getting any results back when I should be

Scott Roth · Jul 24, 2025 go to post

I was never able to get this figured out. It happens because our Business Process sends to a Business Rule that is disabled and started from our cron. 

We just make sure to go check for suspended messages after a fail-over.

Scott Roth · Jul 17, 2025 go to post

Is there a way to make the file, pipe delimited vs comma delimited?

Scott Roth · Jul 14, 2025 go to post

Even though the vendor is stating it, I don't think my name.list is SequenceOfHumanName