Where are the SQL Show History entries for each user stored?

InterSystems has corrected an issue that can cause InterSystems IRIS® and Caché to not take advantage of large pages for shared memory on Windows, even though these products report that large pages are allocated. This can have detrimental effects on system performance.

The issue results from a change in Windows 10 that requires modification of InterSystems IRIS® and Caché. Note that this issue also affects all InterSystems products that are based on InterSystems IRIS® or Caché.

This error I am getting when I am updating cache.dat file:

02/13/23-22:38:11:880 (3444) 3 Error: ERROR #5002: Cache error: <FUNCTION>LoadDLLs+27^STU - Shutting down the system. 

This error I am getting whenever I am compiling any of my production or compiling Enslib.HL7.Adapter.TCPOutboundAdapter

#5002: Cache error: <SUBSCRIPT>ConstructCompileTree+72^%occInherit ^oddCOM("")

Can anyone help me with this ? 

I am unable to open studio. Management Portal is working fine. But facing issue in login into studio. Access Denied. Native Code : 417

How to stop a task plan when it starts incorrectly and continues to execute due to disk space and other reasons, which may cause system failure

Listen to CEO George James chat with Derek Robinson, host of the InterSystems DataPoints podcast talk about source control, developer tools and how our solutions are beneficial for InterSystems IRIS users.

In this short 17 minute episode, George and Derek discuss our work with developer tools, and how choosing the right source control can provide users with a seamless solution - which is why Deltanji is seen as the go-to source control for InterSystems IRIS users.

Listen now on the InterSystems website > https://bit.ly/3Jp5py5
or wherever you get your podcasts - just search for 'InterSystems DataPoints'.

Usualy, if you want to deploy a solution, you need to add the items, configure your lookup tables and default configuration manually. 
It's okay if you have all the permissions and privileges to perform these actions. If you want to deploy to a client's production server, and you don't have the permissions, you need to indicate in a document ALL the steps that the deployment manager has to perform. 

Hello!

Is there a way to call a business of another namespace?

My example:

BS calls BP

BP decides between two BOs – one in the same namespace, and the other one in another namespace

I am finding difficulty in getting ensemble setup.exe file. Can anybody help me out?

Hi Community,

I am configuring new SSL Configuration for Gmail (For sending errors to gmail in ensemble production) by following the below steps.

Step1:

Step2:Giving the server address smtp.gmail.com

Step3:Giving the port number , I have tried giving 465,587,25 as port number still is not connecting 

Can anyone please tell me where i am doing wrong on configuration?

Thanks,

Saroja.A

I have a system that is sending Line Breaks\Carriage Returns within the text of a field that is breaking the parsing of the message. Does anyone have a way to get around this?

here is what I receive... 

ZPR|29|937952|UH|Physician Assistant - Certified|Primary Privileges:  Physician Assistant|Care of simple fractures including extremity, rib and clavicle; including skeletal
immobilization||

as EnsLib.HL7.Service.

Hi Guys,

I have a scheduled task that run every 5 mins to execute a function with 10 things to do, issue that those 10 thing are processed in a loop that takes more than 7 mins to finish, so basically I would like to understand what will happen when the task will run in next 5 mins given that the 10 things to do in my function from the first run didn't finish yet, would it ignore what's left from the 10 things to do and start again or the first run or would the first run  continue to execute in some job # and the new run will run in parallel with new Job#, and if that's the case would this affrect the system performance or is it better to expand my scheduled task eg.

Hi Guys,

Sealy question but I'm between a hard and rock :)

I've a running method that deletes a list of records and its has been running for hrs and did place locks so other processes can't progress, and to what I can see it will still run for a few more hours, so how can I stop this process at this point without losing what already has been deleted?

If I close the terminal all records that has been deleted will roll back as it happened to before ?

Thanks

Hi Guys,

we are having a problem with the Cache.dat file is not expanding anymore since it has reached 2.2TB, we still have extra 260Gb of free disk space in our drive but for some reason it's raising a FILEFULL which is a result or the database not able to expand.

Is there a way to get the list of Business Services from a command line call? We are trying to see if there is a way we can automate bring down our Inbound Business Services during a fail over.

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

Hi Guys

The navigation by default returns the Total records, how can I change that or allow the navigator to only show the number of records in the current page, or is there a property of Tablepane that returns the current page records No?

Thanks

We are upgrading from Health Connect 2018.1.3 to IRIS Health Connect 2022.1, and one thing that we are particularly hesitant about is if our Business Rules will work in the new version.

I am trying to come up with a testing process for bulk testing our rules, and wanted to know if this could be done programmatically instead of having to modify all the Business Operations to have them write the HL7 data to a file. I caught Orlando Health's presentation at GS2022 but I am not sure that will work for my team.

Hi guys, 
I've setup an FTP passthrough service and operation to move two files from one SFTP server to another. 
The files are moved and i can confirm with filezila that the whole operation went well. 
However, i need to raise errors and send email if one the sftp servers is down for whatever reason, and if the trasnfer didn't go well. 
I ticked the alert on error box for the passthrough BS and BO and the errors are indeed forwraded to an alert management system. I have real problems with the check on the SFTP servers.

Hi Community,

I have created a HL7 production in my working environment, Ens.Alert ,EMailAlert, PagerAlert, and  BadMessageHandler are created.

Can anyone explain how Ens.Alert and BadMessageHandler will work when an HL7 message in Passed in Business service and how these 2 are related when any error occurs in the Production envinorment?

This article will describe and include an example of how to embed an external PDF file into an HL7 segment, specifically ADT_A01:2.3.1 OBX().  This can be useful when attempting to insert pictures or other external data into an HL7 message.  In this example, the name of the PDF file to be embedded is provided in the incoming HL7 message in OBX(1):ObservationValue field.

The basic stipulations for this example are as follows:

1. Accept a PDF file
2. Accept an HL7 message
3. Using the name of the PDF file, embed the PDF data into the HL7 message
4. Output the message to file 

 Using EnsLib.File.

Hi community,

I am working on Converting Non HL7 message (Using record maps) into HL7 message.

1.Can anyone share few details how to save Non HL7 message into SQL table and the converted HL7 message into SQL table

2.In Message Viewer is there any SQL tables are linked to the session id or where the information regarding the message will be stored? Will the message trace details are stored in globals or in SQL table,If yes can anyone share the details in which tables or globals will it be stored?

Joe

Hi everyone.

I have a use case where I'm using embedded SQL within a Business Process to interact with a SQL table. However, when it comes to deployment into our production, the table wont form part of the deployment package created from the production.

Beyond manually creating the table on the production system, is there a standard way of ensuring that a table needed for a class is created during deployment?

Hi Community,

I am new to ensemble and cache object scripts ,i am trying to create a business service using Ens.BusinessService

but i have doubt what is the difference or uses between Parameters and property in defining classes in defining business service

Joe

Hi Guys,

we this format of url with port required, and my guess that if we specify port 57772 as the default port in the web server which I'm assuming that would be Apache , we don't have to specify the port in our url, so how can set a default port in Apache?  

http://localhost:57772/us-serenity/MSDS.SelectApplication.UI.SelectAppl…

Thanks

Hi Community,

Can anyone explain how to apply early binding and late binding to a transformation.

Example:

I have DOB value as 12/12/2000

In transformation i need to format  DOB value to 20001212-->this value i can achieve by using  $E(DOB,7,10)_$E(DOB,4,5)_$E(DOB,1,2)

But how can i apply early binding and late binding to the above Data tranformation?

Hi,

Is there a way to insert new Key/Value in an existing  lookup Table via a DTL code?  The only thing I found in the documentation is that we could use the following command SELECT KeyName,DataValue FROM Ens_Util.LookupTable WHERE TableName = 'myTab'. In the meantime I just created a table and  used it in my DTL to insert new values and validate if the Key exist.

Regards

Hi Guys,

I have a scheduled task that run every 5 mins to execute a function with 10 things to do, issue that those 10 thing are processed in a loop that takes more than 7 mins to finish, so basically I would like to understand what will happen when the task will run in next 5 mins given that the 10 things to do in my function from the first run didn't finish yet, would it ignore what's left from the 10 things to do and start again or the first run or would the first run  continue to execute in some job # and the new run will run in parallel with new Job#, and if that's the case would this affrect the system performance or is it better to expand my scheduled task eg.

Has anybody tried to write custom code to empty out queues when Interoperability shuts down? We run IRIS in Kubernetes cluster and we have compute pods scaling up and down. We have Message Bank operation to keep all messages in one place. We want to see all messages in Message Bank.

Hey guys!!!

I finally got some time to organize a set of classes that I've been using for a few years to make it easier and kill the repetitive work of developing intragrations using XDBC.

Access the project repository at https://github.com/cristianojs/interopway

I've already registered on the Open Exchange. I'm wait for approval.

The idea is to increase the project with more components, I already have one that the "dough is rising and is already going to the oven".

Any questions post here.

Big hug.