Question Scott Roth · May 6 Troubleshooting REST Operation I am trying to replicate a REST call that I am able to make via a Postman call within a EnsLib.REST.GenericOperation. It's been a while since I have messed around with trying to make external REST calls. When I execute my REST call, tSC is coming back with an error and I am trying to pinpoint why. I tried turning on ISCLOG = 5 but when calling the REST Operation from the Testing tool it is not logging anything to the ISC log. #ObjectScript #REST API #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 3 0 39
Question Scott Roth · May 5 Task Scheduler - Output to file I have a Task that I am trying to write the output to a file. How do I check for if the Output File has been included in the Task Schedule, so I can direct my output of my class to that output file? Thanks Scott #ObjectScript #System Administration #HealthShare #InterSystems IRIS for Health #InterSystems IRIS 0 3 0 43
Question Scott Roth · Apr 28 Code Tables vs Cache SQL Tables in HealthShare Provider Directory I have a general question about HealthShare Provider Directory using Code Tables on disk vs Cache SQL Tables. Why is Provider Directory not using the Cache SQL Tables within the IRIS platform? #SQL #HealthShare #InterSystems IRIS 0 0 1 22
Question Scott Roth · Apr 28 Struggling with a SQL SELECT that is returning multiple searchable rows I am struggling with returning a SQL Query Result that may have multiple rows that can be searched. #DTL #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 4 0 56
Question Scott Roth · Apr 22 Linked Stored Procedure Call - Need Results to populate further logic I was wondering if someone could help me. In the past I have been able to call external Stored Procedures through a SQL Outbound Connection and have them return me the EnsLib.SQL.Snapshot to use within a BPL to extract data. But this time instead of using a SQL Outbound BO to make the Stored Procedure call, I decided to create a Linked Stored Procedure through the %JDBC_Server to point to the Stored Procedure out on MS SQL. However, I am struggling to get the code just right to return the Column value from the Linked Stored Procedure. #ObjectScript #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 32
Question Scott Roth · Apr 9 Business Rule Editor - Using Foreach Action and how to account for the counter I have a segment within a Group (grp) that needs to be validated that it is populated within the message. When you use a Foreach within a Business Rule how should you account for the counter in the group? For example, Epic sends their MFN message in the following format. MSH~MFI~[~{~MFE~STF~PRA~[~ZPR~]~[~ZLK~]~[~CER~]~[~ZMG~]~[~ZTF~]~[~ZGP~]~[~ZDD~]~}~] #Business Rules #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect 1 1 0 42
Question Scott Roth · Apr 2 ErrException: <INVALID OREF>zOutputToIOStream+^EnsLib.HL7.Message Trying to start investigating an error we are seeing with multiple of the same messages getting sent to the same vendor. We receive an HL7 message with an RTF embedded from our EMR, send it through a DTL to just update the Patient Class, and then send it onto the Operation which is TCP. We are starting to see this error message... #Business Operation #DTL #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect 0 4 0 53
Question Scott Roth · Mar 21 VSCode - trying to use <sql> tag to call SELECT statement I was using VSCode to edit a DTL because it seemed easier to copy/paste code from parts of the DTL I was editing. I tried to add <sql> tag and code to call a SELECT statement, but when I compiled I got the following error... ERROR <Ens>ErrInvalidDTL: Invalid DTL > ERROR #5490: Error running generator for method 'GetSourceDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization' #DTL #ObjectScript #VSCode #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 54
Question Scott Roth · Mar 12 SQL Query not transforming into class structure correctly My query that I am running on my Custom SQL Inbound Service has columns that are larger than the typical string length. How do I enlarge the SQL Snapshot Column limitations #Business Service #ObjectScript #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 4 0 64
Question Scott Roth · Mar 12 SQL Inbound Service write to internal Cache Table I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work? Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block? #ObjectScript #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 46
Question Scott Roth · Mar 4 Using Lists and ListFind within BPL I already mentioned in a Previous post I am trying to build a list from a repeatable field within a HL7 message. I figured out how to build the list by using a context list string variable within the Business Process (BPL) and doing a #Business Process (BPL) #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 1 0 58
Question Scott Roth · Mar 4 Using Lists - LB and LI I have a repeatable field within HL7 that I want to create a List from. Do I have to initialize the List by using $LB, or can I just use $LI to keep adding on to the end of the list as it is looping through the field? #ObjectScript #Caché 0 4 0 63
Question Scott Roth · Jan 28 Default value (initial expression) in HL7 Field Epic had changed some of their logic on their Incoming Radiology Results which now require an Ordering Provider even though it is supposed to account for it within the Epic Interface settings. I was wondering if we are using a custom schema if there was a way to default a value into OBR:16 if it was not valued without having to modify all the DTL's for these Results. Is there a way to set this via the schema editor or in the background so we don't have to create/update DTL's or create a custom TCP Operation Class?? #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect 0 5 0 77
Article Scott Roth · Jan 24 3m read Connecting JDBC to MS Azure SQL through Microsoft Entra and Active Directory Password Authentication Not sure there are many that connect to MS SQL to execute queries, stored procedures, etc, but our Healthsystem has many different MS SQL based databases we use within the Interoperability environment for various reasons. With the push to moving from on-prem to the Cloud we ran into some difficulties with our SQL Gateway connections and knowing how to config them to use Microsoft Entra for Active Directory Authentication. #Azure #Cloud #Databases #Java #JDBC #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 1 0 1 145
Question Scott Roth · Jan 22 Question about using ODBC for SQL Gateway connections I am currently experiencing frustration with trying to Authenticate an Active Directory account through JDBC as the Hospital System moves from OnPrem SQL Server to using Azure SQL Server with Microsoft Entra Authentication. Microsoft cannot give me a straight answer of what is required from a JDBC standpoint to authenticate from a Linux environment. #JDBC #ODBC #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 1 2 0 62
Question Scott Roth · Jan 8 JDBC - Microsoft Entra Authentication We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra. I was given the following URL #JDBC #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 5 0 117
Question Scott Roth · Dec 20, 2024 MaxRowsToGet on EnsLib.SQL.InboundAdapter I have a query that returns around 6000 records that I need to go through and update another MS SQL Table. I would like to execute this once a day. How do you set MaxRowsToGet on a EnsLib.SQL.InboundAdapter service? Thanks Scott #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 3 0 74
Question Scott Roth · Dec 9, 2024 Foreign Server/Table Help I am attempting to create a Foreign Server/Table so I can pull some information in from MS SQL server via JDBC connection, but as soon as I create the Server/Table and logout the Foreign Server disappears. CREATE FOREIGN SERVER Epic.Clarity FOREIGN DATA WRAPPER JDBC CONNECTION 'MS-EpicClarity' logout, then run #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 1 3 0 98
Question Scott Roth · Dec 6, 2024 Foreign Servers - Visibility? First time trying to use Foreign Tables/Servers instead of Linked Tables... Within the SQL Editor inside of the Managment Portal, or connecting through DBeaver JDBC how we can see what Foreign Servers have been defined? Is there a way to query and verify structure of the Foreign Server connection to know that we are building the correct Foreign Tables? I attempted to create my first Foreign table but it failed when I tried to query the tables because it said the table could not be found. But when I sign into the Database via SQL Management Studio, I can see the table. #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 3 0 91
Question Scott Roth · Nov 20, 2024 Iterate through current Row of EnsLib.SQL.Snapshot I am using a JDBC connection to MS SQL server to execute a stored procedure to select data and bring it into InterSystems as a EnsLib.SQL.Snapshot. I loop through the EnsLib.SQL.Snapshot using a while loop, but I also want to iterate through the Columns within that Row to do logic. Is there a way to iterate through the Columns of the current Row of the EnsLib.SQL.Snapshot so I can apply logic/rules for further processing? Thanks Scott #JDBC #SQL #HealthShare #InterSystems IRIS for Health #InterSystems IRIS 0 4 0 71