Nouvelle publication

検索

Question
· Mai 1, 2024

Parsing a JSON message with

#JSON #InterSystems IRIS for Health

I have the JSON message below. I am struggling with parsing the data in the OtherProcedures section. That section can be null, or have from one to many other procedures. Any help is greatly appreciated. I have tried using/setting an iterator to go thru the data but not having any success with that. 

{
    "Action": "1",
    "CaseNumber": "",
    "MessageId": "",
    "ControlId": "",
    "Patient": "idz",
    "DateOfOperation": "20240401",
    "PrimarySurgeon": "you",
    "AttendingSurgeon": "me",
    "SurgicalSpecialty": "12",
    "PrincipalOperativeProcedure": "Ingenuial Hernia Repair",
    "PrincipalPreOperativeDiagnosis": "Hernia Surgery",
    "LateralityOfProcedure": "2",
    "PlannedAdmissionStatus": "I",
    "PlannedPrincipalProcedureCode": "29848",
    "ICD10Code": "K40.00",
    "HospitalAdmissionStatus": "I",
    "MajorOrMinor": "J",
    "CaseScheduleType": "EL",
    "Palliation": "Y",
    "PlannedPostOpCare": "PACU for 4 hrs",
    "RequestAnesthesiaTechnique": "S",
    "intraoperativeXRays": "Y",
    "ReferringPhysician": "mine",
    "ConsultId": "692",
    "Scheduler": "scheduler",
    "OtherProcedures": [
        {
            "otherProcedure": "Liposuction",
            "plannedOtherProcCPTCode": "15772",
            "otherProcedureCodeComments": "Adding a second procedure."
        },
        {
            "otherProcedure": "colonoscopy",
            "plannedOtherProcCPTCode": "44389",
            "otherProcedureCodeComments": "Adding a third procedure."
        }
    ]
}

5 Comments
Discussion (5)2
Connectez-vous ou inscrivez-vous pour continuer
InterSystems officiel
· Avr 30, 2024

Alert: SQL Query using “NOT %INLIST” fails to return results

#Health Connect #InterSystems IRIS #InterSystems IRIS for Health #InterSystems officiel

Alert: SQL Query using “NOT %INLIST” fails to return results

InterSystems has corrected an issue that can cause a small number of SQL queries to return incorrect results.  See below for the specifics on impacted queries.

This issue exists in the listed versions of the following products:

  • InterSystems IRIS® data platform
  • InterSystems IRIS for Health™
  • HealthShare® Health Connect

As well as:

  • Other InterSystems products based on the above products.

Impacted versions:

  • 2021.1.3, 2021.1.4
  • 2022.1.3, 2022.1.4
  • 2023.1.0, 2023.1.1, 2023.1.2, 2023.1.3
  • 2024.1.0

 

Only queries with the following conditions could return wrong results:

  • The WHERE clause contains a NOT %INLIST
  • There is a NULL value in the list

 

The correction for this defect is identified as DP-430793 and will be included in all future product releases beginning with:  2022.1.5, 2023.1.4, 2024.1.0.267.2, and 2024.1.1.  It is also available via Ad hoc distribution. 

If you have any questions regarding this alert, please contact the Worldwide Response Center.

NOTE:  Edited 5/16 to reflect that this defect has been corrected in the newly released 2024.1.0.267.2 patch.

Discussion (0)2
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Avr 30, 2024

Take advantage of personal training at Global Summit!

#Global Summit 2024 #Portail d'apprentissage

Meet one-on-one with a personal trainer at Global Summit. Discuss interop, integrations, UCR with Sue O'Leary.   

Attending Global Summit 2024? Sign up for a personal training session with one of our technical trainers.

🌟 This week the spotlight is on @Sue O'Leary, Learning Services Training Manager!

Sign up for a 45-minute session to talk to Sue about interoperability/integrations or Unified Care Record. Refresh your memory on previous classroom training, discuss a technical concept, or start learning about InterSystems technologies.

📧 Email GSTechExchange@intersystems.com or visit the Tech Exchange concierge desk at the Summit.

Find more details about technical trainers and their specialties.

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Article
· Avr 30, 2024 2m de lecture

Monitoring InterSystems IRIS environments with Red Hat Insights

#Red Hat Enterprise Linux (RHEL) #InterSystems IRIS #Health Connect #InterSystems IRIS for Health

InterSystems worked closely with the Red Hat Insights team to implement a curated set of recommendations for system administrators to ensure the best experience running InterSystems IRIS on Red Hat Enterprise Linux (RHEL). Included with all RHEL subscriptions, the Insights service proactively identifies potential issues with monitored platforms and applications running on RHEL. Through our joint collaboration, Insights now watches for common scenarios that decrease the performance of IRIS in most cases and offers an InterSystems-approved recommendation for consideration.  

Ten recommendations are currently implemented and can be found under the “InterSystems” topic within the Insights Advisor service.  Advisor recommendations help in areas including:

  1. Performance Tuning Guidance. We provide best practices for configuring HugePages, Transparent HugePages (THP), swappiness, shmmax kernel parameters, and more.
  2. Product Compatibility. Insights highlights which versions of InterSystems products are encouraged to be used to provide the best experience.
  3. Journaling and High-availability Configuration Suggestions, like Write Image Journaling (WIJ) drive mapping, identifying an arbiter to support automatic failure, or enabling FreezeOnError for better integrity and recoverability of InterSystems IRIS database.

Every recommendation contains details about the detected RHEL version, InterSystems IRIS instance information, and system-specific step-by-step instructions to remediate the detected issue.  Links to the InterSystems documentation are also provided for further reference.

Enable Insights with InterSystems today.

Registering your systems with Red Hat Insights is very straightforward and typically requires only a single command to be executed. Alternatively, the Red Hat registration assistant application can be used to complete the necessary steps based on your setup. Analysis of InterSystems IRIS workloads does not require additional steps and is enabled once systems are registered with Insights. Specific recommendations can easily be turned off if they are not applicable to your environment.  

Head to Red Hat Insights to learn more about the service and get started with the registration assistant.

Talk with Red Hat experts at InterSystems Global Summit 2024.

Red Hat will be exhibiting at InterSystems Global Summit June 9-12 and available to discuss Insights and other Red Hat capabilities.

2 Comments
Discussion (2)3
Connectez-vous ou inscrivez-vous pour continuer
Question
· Avr 30, 2024

Error when trying to set up an SSL/TLS configuration

#SSL #Health Connect #InterSystems IRIS #InterSystems IRIS for Health

I'm trying to configure an SSL/TSL configuration in our test environment so we can send ADT messages to an external server. I've verified connectivity/firewall to the external server.

type is set to Client, Server certificate verification is set to Require.

I have received a certificate from the external supplier and linked that in the "File containing trusted Certificate Authjority certificate" field. (I've also imported it into the cert store and tried using %OSCertificateStore).

My client certificate is in PEM format, the decrypted key was extracted using SSLOpen. Protocol enabled is TLSv1.2 (I've tried with the others as well.)

When running a test I get this error:- ERROR #988: SSL connection failed. SSL/TLS error in SSL_connect(), SSL_ERROR_SSL: protocol error, error:14094416:SSL routines:ssl3_read_bytes:sslv3 alert certificate unknown

Is anyone able to assist in deciphering this error, or helping me sort the configuration out?

Many thanks

2 Comments
Discussion (2)1
Connectez-vous ou inscrivez-vous pour continuer