I'm looking for any  reference documents on migrating about 3 TB of data from DB2 to IS IRIS Healthshare..  I've looked through the IS  documentation  and SQL gateway, or TSQL are some of the methodologies mentioned , was wondering  if anyone had done this type of migration before, and can provide any pointers.


0 1 149

I am playing with the FHIR Sandbox.

I want to sort the patients returned in the bundle from the Patient search using the _sort (according to FHIR standard the _sort parameter is what should be used to sort), but I get: "Invalid request URL parameter _sort specified"


So I am having to assume that InterSystems did not implement _sort.

0 1 141

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach?



0 1 139

I'm attempting a first-time installation of IRIS for Health on my home Mac for eval purposes. I want to be able to install IRIS and Ensemble. I downloaded the package but it doesn't come with instructions, and I'm running into issues. Is there a straightforward install instruction set online, or does anyone have one you can pass along?


Thanks, Jim Winski

0 2 134

Hi Experts

I am trying to pull the code tables Information and this code table has linked  code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables. 

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered. 

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff. 

1 1 133
Scott Fadden · Oct 27, 2020
Configure IRIS using Python

I am trying to configure IRIS using python. The first task I wanted to do it change the journal directory. I cannot figure out the right way to work with the Config.Journal class with python. I can get the text to query the current setting.

returnValue = dbnative.classMethodValue("Config.Journal","GetList")
print(returnValue )

But I don't see a straightforward way to parse the $List returned by GetList() I was hoping there was an easier way.

How do I

1. Query configuration parameters?

2. Set configuration parameters?

Using python?

0 2 132

I am trying to do package mapping in the %ALL NameSpace.

I create a new Package Mapping entry and select my database bu the "Package Name" combo box never populates the packages in this database so I cannot select it, see screenshot below, the "Package Name" list remains empty. There definately are packages in that database. Why is this happening? Did I miss a setting?

0 1 125

Hi ,

I tried to import Custom schema with 'Z' segment. I executed "Do ##class(EnsLib.InteropTools.HL7.MessageAnalyzer).Interactive()" in IRIS Terminal.

After executed the steps, i am getting below message, So i could not able to add z segment into my customschema 'Test_2.3'
Summary Report for workspace C:\Demo\Migration\Workspace
Schema is Test_2.3
 ALL: 0 matched, 1 unmatched

0 1 125

Hey guys,

I have a problem when creating a remote database (via ECP), when I select the remote directory field it presents the error below:
"There was an error on the server:
ERROR # 179: An unexpected error has occurred:
ORIGIN ELEMENT:% CSP.UI.Component.remoteDatabaseSelect (DirectororySelect)

0 1 122

How do we return a member from a set?  For example if I want a calculated measure to return the NAME of the date with the max transactions, to get the set ordered I might do something like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].[TransactionCount], DESC)

But how do I access the first member in the set as a member so that I can get to the properties such as the member NAME (what I want to return in this case)?

In some MDX implementations like Microsoft there are kind of backdoor functions for this like:

0 4 121
James Keith · Dec 2, 2021
Server Connections

I'm upgrading my laptop, and installed HealthShare 2020.2.  I wanted to import my server connections from my previous laptop, so I exported the Registry Keys (Windows 10) Under Computer\HKEY_CURRENT_USER\SOFTWARE\InterSystems\Cache\Servers from the old machine.  I then imported them into new laptop, but I still don't get the list of connections in my HealthShare Remote System Access list from the HS Cube in my system tray.

Does anyone have a solution for this?  I thought this was more portable.


0 1 120

I am getting this with %RCHANGE:


This routine changes all occurrences of a string in
routines/include files.

1. Change every: Cache to: IRIS
2. Change every:

Routine(s): %*

Then I get these types of messages: 

This routine is mapped to another database, are you sure you want to change it??
 No => yes%DIRFULL.INT


0 5 119

Does InterSystems IRIS will support Visual Studio 6.0 Enterprise Edition (Visual Basic)?

We are in the process of transitioning Intersystems Cache 2017 to Intersystems IRIS 2020 version.

For terminal based applications we can able to use the same DAT file used for Cache with minor changes.

For Web based we are using Visual studio 6.0(Visual Basic). Will IRIS supports Visual Studio 6?

0 2 118

I am looking to create a routing rule that will do the following:

When transaction is not an A03, and discharge date is valued, do not transform. 

What I am having trouble with is with the conditional for the discharge date {PV1:45}.  Not sure if I can use length here or if I can use HL7.{PV1:45}>0.  I did try that, but its not working.  Not sure what I am doing wrong.





0 2 110

Before I run down the "overengineered solution" path, I wanted to throw this out to the group.

We will be receiving HL7 messages via TCP/MLLP that have a PDF document stored in a single OBX segment. As the volume is expected to be somewhat high and the documents could be megabytes in size, it would be preferable to save the PDF payload to disk and replace it with a filesystem path before IRIS does it's first Save%. The idea being that we would than implement an OnDelete that would remove the file when the HL7 message is purged.

0 4 107