How to read the HL7 V2.5 messages irrespective of message type to Iris database ?
Source system sends HL7 messages of multiple message types to Intersystems through TCP and these messages are to be inserted/read into iris SQL database.
When i tried to print .txt format,data will be coming without space between each row but when I tried to print .xls format mean ,it gives gap of each row.what is the reason behind this?
I have been playing around with the deployment tools from Ensemble (mostly based on this article https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...) , but so far the one thing I still couldn't figure out is how to release the fact that I deleted files/components from my source production and that will get reflected in my target production.
We have a vendor that every couple of days will just stop transmitting messages, but still hold the TCP/IP connection open. No matter how many times we troubleshoot and talk with them, they don't seem to think its an issue with system. Normally if I just restart the service it will get the data flowing again.
For example, I have two timestamp values ('2024-04-01 10:00:00', '2024-04-01 11:30:30'). I would like to find the difference between these two timestamps, and I need the result in hours:minutes:seconds (hh:mm:ss) format.
Expected Output: 01:30:30
Note: I need an SQL query command. I should not use ClassMethod, Function, or Stored Procedure.
Could anyone please provide me with an SQL query for my question?
Tring to Performing following script in IRIS but do not know how to format Date. Normally, I would use TO_DATE or TO_TIMESTAMP in the actual queue statement below, but since I'm using Prepared Statements, I do not know how to format date in 'values' that is being used in the %Execute. It generates errors. I'm updating an Oracle Database via a SQL JDBC Gateway Connection. Does anyone know how to pass in Dates?
When I do $TRACE("message") I can see the message on the message viewer. However, I don't know where to find messages generated from $$$sysTRACE, and I haven't found anything about it in the documentation.
I have some databases in my cache instance that were created from an online backup file (.cbk). I would like to see the information for these databases in the Databases and SQL sections of Management Portal, but they only appear in the Classes section. I can navigate to the files in my cache instance terminal and see the CACHE.DAT files, and a check in the terminal shows that they are mounted.
This is what I see in the terminal for each database when I check to see if the databases are mounted:
The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"
is there a SAFE way I can give him access to our database using an intelligent visual user interface.
I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.
We have in our company a task that use many times a job command, and we receive this message "<LICENSE ALLOCATION EXCEEDED>". I thought that a new license is consumed only when we acess with another IP address the database.
Is there a sensible approach to having a lookup table in Namespace A, and then accessing this from Namespaces B, C, D (etc)?
I'm trying to avoid creating a Global mapping of the lookup table global (^Ens.LookupTable) as I fear that it would then link all other lookups in that global and lead to some unexpected behaviour, but would be open to trying something in this realm if it's the best option.
Prior to IRIS, using ECP to share databases under heavy I/O load has known latency issues (in our environment), which pretty much restricted using shared database with relatively static or slow-changing data. In IRIS, will sharding mitigate the latency issue and allow any table to be shared?
lets have two abstract %Persistent classes A,B with NoExtent keyword (storing data in separate globals for each subclass).
Class A Extends %Persistent [Abstract, NoExtent]
{
}
Class B Extends %Persistent [Abstract, NoExtent]
{
Property Aref As A;
}
Let B class reference the A class. Since the A class has no extent the reference wont work in subclasses. It wont be even usable in SQL. Is it possible to solve this problem? Whats the recommended way to deal with references/relationships using NoExtent?
Hi all, I'm having issues with mounting custom database on top of IRISHealth 2019.1 docker container. Data gets mounted only in Read-only mode. This means read operations are successful but I couldn't make the image with databases mounted in Read/write, both modes. Is anyone having similar issue?
I was wondering if there were any guides, similar to the ones for an upgrade, that walkthrough at a high/medium level the process for migrating an Ensemble Instance.
I am presuming that the general flow would be to install a fresh instance in the target environment, and migrate items over.. but any specific order? gotchas? things to avoid? Some things that should/shouldn't be im/exported (ie, must be manually migrated) ?
I have a complex ZEN PDF report that has multiple tables that essentially are the same but are populated by different global definitions. The code has hardcoded groups for these tables but I would like the number of tables to be variable as many as there are global levels for a particular report.
Is there any way that I could build a report from a variable source of data rather that hardcoding 10 or more exact sections like the code below ?
We have 3 env. using different ports schemes Is there a way to create a rule if msg comes on ports starting 22 then route it to devoperation, if it starts with 33 then route to testoperation, if its 44 route to stageoperation?
I'm looking for a way to programmatic ally add the parameter 'VALIDIFNULL' to classes that extent %SerialObject.
This to hopefully resolve the validation errors I'm getting on webservice request messages, where certain properties are not required, but lower down the tree some properties are.
I have too many classes to do this manually and with the next SOAP wizard run I probably loose the added parameter.
I built my rest api with ^%REST and update with CreateApplication. Postman works fine and I suppose production server will work fine as UI and rest api will be on the same domain, but for now in dev, I need to have access from my local to the Iris rest api. I have a CORS error.
I do not know how to configure my swagger file to have either Parameter HandleCorsRequest=1 or <route Cors=true in the generated displ,cls.
I am trying to adjust my VSCode settings.json to make my repository to Server Side Source Control. When Adding "uri" to the settings.json to change the setting but VSCode is telling me that the Property uri is not allowed.
By views.png)
.png)