New post

Find

Question
· Apr 9

One property crashes IRIS query

#Caché #InterSystems IRIS

Hello, 

One of our clients has a 'Notes' class with over 3 million records.   We have a report that pulls data from this table that was taking about an hour to run.   Our test environment (which has a copy of the production database) runs the same report query in 1 second.    

We attempted to purge and rebuild indices which made an improvement (down to 15 minutes) but still not great.

Next we ran tune table through the Mgmt Portal and it timed out.    I then ran tune table via the Terminal and it finished in a couple minutes.   Suddenly our application was hanging anywhere this table was referenced.    We realized there was one boolean property in the WHERE clause causing the problem.   Our only recourse was to remove the offending property from the WHERE clause and filter on that value within the code loop instead.      That works fine but we'd still like to know what is going on.    Has anyone seen behavior like this and if so how did you deal with it?   Thanks very much!!

3 Comments
Discussion (3)3
Log in or sign up to continue
Question
· Apr 9

HL7 add OBX segment at specific locations - Resolved

#DTL #HL7 #Interoperability #ObjectScript #Ensemble #Health Connect #InterSystems IRIS for Health #Open Exchange

I need to add an extra blank OBX segment after a segment containing text, Total Cost:

I get the OBX segment but it is in incorrect location.

It should be after the line containing Total Cost:

It needs to contain:

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|

code:

    //Do pOutput.SetValueAt(tOBXText_"~~","ORCgrp(1).OBRuniongrp.OBXgrp("_i_").OBX:5","set") //
         If (tOBXText[ "Total Cost:") {
             Set tSegmentOBX = ##class(EnsLib.HL7.Segment).%New()
             Set tSegmentOBX.SegType = "2.3:OBX"
             Set tSC = tSegmentOBX.SetValueAt("OBX", 0, "set")
             Set tSC = pOutput.InsertSegmentAt(tSegmentOBX, i)
                                                          }

result

Input message:

MSH|^~\&|GMRC IF CONSULT|757^B1930^DNS|GMRC IF CONSULT|757^^DNS|20250123175341+0000|CRNR|ORM^O01^ORM_O01|Q5808332894T6790522104|T|2.3|||AL|AL|USA

PID|1||1013570973V041977^^^ICN^VETID~2110106796^^^EDIPI^EDIPI||PROSTEST^EHR||19760902|M||||||||||129256619|678235672

ORC|NW|15207778763^757^GMRCIFR|||||^^^20250123175300+0000^^R||20250123175331+0000|1578051652^PCP1^VA-Physician||1578051652^PCP1^VA-Physician|||20250123175341+0000||757

OBR|1|15207778763^757^GMRCIFR||757^PROSTHETICS IFC^757VA1235||20250123175300+0000||||||||||1578051652^PCP1^VA-Physician|||Implant Usage (PSAS)||||||||^^^20250123175300+0000

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|1|Implant Usage (PSAS)||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|2|REASON FOR REQUEST: Item Number: 00801741016608||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|3|REASON FOR REQUEST:      Transaction Date/Time: 01/22/2025 17:45||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|4|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|5|REASON FOR REQUEST:      Item Description: Plug Surgical 1.3in Groin Monofilament ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|6|REASON FOR REQUEST: Nonabsorbable Perfix Polypropylene Medium Taper 1.55in Sterile Hernia ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|7|REASON FOR REQUEST: Repair 0112760||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|8|REASON FOR REQUEST:      Manufacturer: Davol Inc||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|9|REASON FOR REQUEST:      Manufacturer Model Number: 0112760||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|10|REASON FOR REQUEST:      HCPCS: C1781||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|11|REASON FOR REQUEST:      Lot Number: 012220252||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|12|REASON FOR REQUEST:      Expiration Date/Time: 05/22/2025 04:00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|13|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|14|REASON FOR REQUEST:      Source: 757-TrackCore Inv||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|15|REASON FOR REQUEST:      Lot Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|16|REASON FOR REQUEST:      Lot Waste Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|17|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|18|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|19|REASON FOR REQUEST: Item Number: 00888867351288||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|20|REASON FOR REQUEST:      Transaction Date/Time: 01/22/2025 17:45||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|21|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|22|REASON FOR REQUEST:      Item Description: Anchor Suture 2 Swivelock C Closed Eyelet Twist in ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|23|REASON FOR REQUEST: Knotless 19.1mm Blue AR-2324KBCC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|24|REASON FOR REQUEST:      Manufacturer: ARTHREX INC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|25|REASON FOR REQUEST:      Manufacturer Model Number: AR-2324KBCC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|26|REASON FOR REQUEST:      HCPCS: C1713||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|27|REASON FOR REQUEST:      Lot Number: 012220253||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|28|REASON FOR REQUEST:      Expiration Date/Time: 05/17/2025 04:00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|29|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|30|REASON FOR REQUEST:      Source: 757-TrackCore Inv||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|31|REASON FOR REQUEST:      Lot Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|32|REASON FOR REQUEST:      Lot Waste Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|33|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|34|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|35|REASON FOR REQUEST: Item Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|36|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|37|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|38|REASON FOR REQUEST:      Item Description: A female part which is inserted into the acrylic ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|39|REASON FOR REQUEST: overdenture and houses changeable nylon retention inserts.||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|40|REASON FOR REQUEST:      Manufacturer: 0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|41|REASON FOR REQUEST:      Manufacturer Model Number: MOR RC-1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|42|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|43|REASON FOR REQUEST:      Lot Number: 1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|44|REASON FOR REQUEST:      Expiration Date/Time:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|45|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|46|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|47|REASON FOR REQUEST:      Lot Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|48|REASON FOR REQUEST:      Lot Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|49|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|50|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|51|REASON FOR REQUEST: Item Number: 00889024015296||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|52|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|53|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|54|REASON FOR REQUEST:      Item Description: Abutment Dental 4.5mm 3.5mm Indirect Transfer ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|55|REASON FOR REQUEST: Tapered Screw-vent Connection Trabecular Metal HLT3/4||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|56|REASON FOR REQUEST:      Manufacturer: Zimvie Inc||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|57|REASON FOR REQUEST:      Manufacturer Model Number: HLT3/4||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|58|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|59|REASON FOR REQUEST:      Lot Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|60|REASON FOR REQUEST:      Expiration Date/Time:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|61|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|62|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|63|REASON FOR REQUEST:      Used Quantity:           4||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|64|REASON FOR REQUEST:      Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|65|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|66|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|67|REASON FOR REQUEST: Item Number: 00889024015340||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|68|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|69|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|70|REASON FOR REQUEST:      Item Description: Abutment Dental Profile 6.5mm 5.7mm Screw-vent ||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|71|REASON FOR REQUEST: Indirect Transfer Retaining Screw Orange HLT56||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|72|REASON FOR REQUEST:      Manufacturer: Zimmer Biomet Inc||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|73|REASON FOR REQUEST:      Manufacturer Model Number: HLT56||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|74|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|75|REASON FOR REQUEST:      Lot Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|76|REASON FOR REQUEST:      Expiration Date/Time:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|77|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|78|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|79|REASON FOR REQUEST:      Used Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|80|REASON FOR REQUEST:      Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|81|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|82|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|83|REASON FOR REQUEST: Item Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|84|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|85|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|86|REASON FOR REQUEST:      Item Description: Abutment, Gold,  Engaging||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|87|REASON FOR REQUEST:      Manufacturer: Zimmer Biomet Dental||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|88|REASON FOR REQUEST:      Manufacturer Model Number: HLA4G||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|89|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|90|REASON FOR REQUEST:      Lot Number: 1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|91|REASON FOR REQUEST:      Expiration Date/Time:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|92|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|93|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|94|REASON FOR REQUEST:      Lot Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|95|REASON FOR REQUEST:      Lot Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|96|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|97|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|98|REASON FOR REQUEST: Item Number: TC024057||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|99|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|100|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|101|REASON FOR REQUEST:      Item Description: Abutment, Gold, Engaging CEANP31||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|102|REASON FOR REQUEST:      Manufacturer: Zimmer||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|103|REASON FOR REQUEST:      Manufacturer Model Number: CEANP31||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|104|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|105|REASON FOR REQUEST:      Lot Number: 2||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|106|REASON FOR REQUEST:      Expiration Date/Time: 05/31/2025 05:00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|107|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|108|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|109|REASON FOR REQUEST:      Lot Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|110|REASON FOR REQUEST:      Lot Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|111|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|112|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|113|REASON FOR REQUEST: Item Number: TC024076||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|114|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 17:43||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|115|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|116|REASON FOR REQUEST:      Item Description: Abutment, Gold, Engaging HLA3G||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|117|REASON FOR REQUEST:      Manufacturer: Zimmer||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|118|REASON FOR REQUEST:      Manufacturer Model Number: HLA3G||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|119|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|120|REASON FOR REQUEST:      Lot Number: 3||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|121|REASON FOR REQUEST:      Expiration Date/Time: 03/28/2025 05:00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|122|REASON FOR REQUEST:      Serial Number:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|123|REASON FOR REQUEST:      Source: 757-C-DENTAL SEC||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|124|REASON FOR REQUEST:      Lot Quantity:           1||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|125|REASON FOR REQUEST:      Lot Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|126|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|127|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|128|REASON FOR REQUEST: Item Number: 00380650697127||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|129|REASON FOR REQUEST:      Transaction Date/Time: 01/23/2025 16:10||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|130|REASON FOR REQUEST:      Station Number: 757||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|131|REASON FOR REQUEST:      Item Description: Lens SP PmmA 5.25x12.0mm (5) +13.0D||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|132|REASON FOR REQUEST:      Manufacturer: ALCON||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|133|REASON FOR REQUEST:      Manufacturer Model Number: LX10BD 13.0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|134|REASON FOR REQUEST:      HCPCS:||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|135|REASON FOR REQUEST:      Lot Number: 01232025||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|136|REASON FOR REQUEST:      Expiration Date/Time: 02/28/2025 05:00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|137|REASON FOR REQUEST:      Serial Number: 01232025||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|138|REASON FOR REQUEST:      Source: 757-TrackCore Inv||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|139|REASON FOR REQUEST:      Used Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|140|REASON FOR REQUEST:      Waste Quantity:           0||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|141|REASON FOR REQUEST:      Unit Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|142|REASON FOR REQUEST:      Total Cost:           0.00||||||O

OBX|1|TX|2000.02^REASON FOR REQUEST^AS4|143|Special Instructions: ||||||O

OBX|2|CE|^PROVISIONAL DIAGNOSIS|1|R52^Pain, unspecified^I10||||||O

NTE|P|UCID:757_15207778763

2 Comments
Discussion (2)2
Log in or sign up to continue
Announcement
· Apr 9

Perguntas-Chave do Mês: Março de 2025

#Key Question #Developer Community Official

Olá Comunidade, 

É hora do novo lote de #Perguntas-Chave do mês anterior.

 

Aqui estão as principais perguntas de março escolhidas pelos especialistas da InterSystems em todas as comunidades:

📌 Message Count por @Farman Ullah (EN)

📌 Walking a virtual document's structure por @Colin Brough (EN)

Essas perguntas serão destacadas com a tag #Pergunta Principal e seus autores receberão o emblema de Key Question no Global Masters.

Se você achar a(s) pergunta(s)-chave de outras comunidades interessante(s), deixe-nos uma mensagem nos comentários e traduziremos a(s) pergunta(s) e a(s) resposta(s) aceita(s).

Parabéns e obrigado a todos pelas perguntas interessantes. Continuem enviando!

Vejo vocês no mês que vem 😉

Discussion (0)1
Log in or sign up to continue
Article
· Apr 9 3m read

Vous rencontrez des difficultés pour connecter votre Visual Studio Code à votre instance IRIS via WebGateway ? Voici quelques conseils !

#VSCode #InterSystems IRIS

Comme vous le savez peut-être, le serveur web privé fourni avec chaque installation IRIS a été supprimé, rendant nécessaire l'utilisation d'un serveur web externe.

Pour les déploiements Docker, il est courant d'utiliser l'image de passerelle web (disponible ici) avec l'image IRIS pour accéder facilement au Portail de Gestion. Cette image peut être configurée pour un accès via HTTPS sans problème en configurant les certificats.

Problème 1 : Impossible de vérifier le premier certificat

Votre connexion SSL via la Web Gateway peut disposer d'un certificat auto-signé configuré, et Visual Studio Code tente de le vérifier. Supprimons cette vérification :

En accédant au menu Settings et en recherchant http, vous trouverez l'option Proxy Strict SSL. Décochez-la pour l'empêcher de tenter de valider le certificat. Dans Proxy Support, sélectionnez Off.

Problème 2 : application Web /api/atelier introuvable

Vous vous demandez peut-être ce qu'est Atelier… Eh bien, c'est très simple : c'était l'ancien environnement de développement InterSystems basé sur Eclipse, devenu un peu un « héritage » dans la configuration IRIS.

Ce problème ne devrait pas être très courant, mais il est dû à la désactivation de l'application web /api/atelier. Pour ce faire, accédez directement au portail de gestion et recherchez l'écran d'administration de l'application web. Dans le menu Administration > Sécurité > Applications > Applications web, recherchez /api/atelier.

En effet, l'application n'est pas activée. Pour modifier cela, accédez à ses paramètres en cliquant sur sa nom, puis sélectionnez « Enable Application ».

Avec cette activation, le problème devrait être résolu.

Problème 3 : Serveur indisponible

Après avoir tout configuré, le serveur n'est toujours pas accessible, affichant un message comme celui-ci :

Il est fort probable que la Web Gateway ait configuré CSPSystems comme utilisateur d'accès à votre instance IRIS, qui s'affiche par défaut sous le nom LOCAL. Pour accéder à la console de la Web Gateway, vous pouvez le faire depuis le pPortail de Gestion (Administration > Configuration > Web Gateway Management) ou directement via l'URL (https://WEBGATEWAY_IP:WEBGATEWAY_PORT/csp/bin/Systems/Module.cxw). N'oubliez pas que l'utilisateur d'accès est CSPSystem (avec le mot de passe spécifié lors de l'installation).

Le premier écran affiché est le suivant :

 

À partir de là, nous devons accéder à Server Access qui vous montrera l'écran suivant :

Comme vous pouvez le constater, nous n'avons configuré qu'un seul serveur, nommé LOCAL, qui nous permet d'accéder directement au Portail de Gestion (dans mon cas, via l'URL https://localhost/csp/sys/%25CSP.Portal.Home.zen). Voyons la configuration :

En effet, l'utilisateur configuré est CSPSystem et notre configuration Visual Studio Code utilise le superutilisateur pour accéder, modifions la configuration pour utiliser le superuser et voyons ce qui se passe :

Bingo ! Problème résolu. Nous sommes maintenant connectés à notre IRIS depuis la passerelle Web de Visual Studio Code.

J'espère que cela vous sera utile.

Discussion (0)1
Log in or sign up to continue
Announcement
· Apr 9

Sua pergunta é uma #Pergunta-chave?

#Key Question #Developer Community Official

Olá, Desenvolvedores!

Estamos introduzindo um novo recurso no site da Dev Community – Perguntas-chave por Desenvolvedores da InterSystems.

Adicionamos uma nova tag especial #Pergunta Chave para destacar perguntas relacionadas às Plataformas de Dados da InterSystems consideradas como tendo o maior impacto.

A cada mês, os especialistas da InterSystems escolherão essas perguntas, e esses autores serão premiados com todas as honras!

Quais honrarias? Detalhes neste post!

O que é #Pergunta Chave? 

É a tag que destaca questões sobre como desenvolver, testar, implantar, gerenciar, etc. soluções que usam as Plataformas de Dados InterSystems, consideradas as mais esclarecedoras, interessantes, intrigantes, importantes e assim por diante.

Quem toma a decisão? 

Os Especialistas da InterSystems analisarão as perguntas da CD e decidirão se devem considerá-las como Perguntas-chave.

Quais questões serão revisadas?

Todas as perguntas na CD serão levadas em consideração.

Com que frequência você verá novas Perguntas-Chave na CD?

A cada mês, nossos especialistas escolherão as perguntas que receberão a tag #Pergunta-chave.

Que honrarias você receberá?

Um novo emblema especial no Global Masters chamado "Pergunta-Chave".

Um destaque especial na Comunidade de Desenvolvedores: adicionaremos um comentário em um tópico com a pergunta de @Developer Community Admin que foi selecionada como Pergunta-Chave.

Faça suas perguntas, aproveite os pontos em dobro durante o Inquisitive Summer na Developer Community e talvez sua pergunta seja escolhida por nossos especialistas como a próxima Pergunta-Chave!

Inscreva-se para a tag e fique ligado! 

Discussion (0)1
Log in or sign up to continue