検索

ダイジェスト
· 2025年4月9日

InterSystems Community Q&A Monthly Newsletter #47

#開発者コミュニティ公式 #ダイジェスト
Top new questions
Can you answer these questions?
#InterSystems IRIS
Question about varstrings
By Alan Decourtray
Java Server timing out
By john.smith4237
GENERATE JWT / OAUTH2.0 SIGNATURE
By Sanjib Pandey
2 [Utility.Event] ISCLOG: WebSocket [SendAsyncMessage]
By Lucas Galdino
irisowner getting in the way of irisusr when using $ZF(-100)
By Mauricio Aguirre
comparison library with renderers in IRIS, similar to Python's difflib ("Helpers for computing deltas")
By Mauricio Sthandier
One property crashes IRIS query
By Jerry Petrole
AWS Files
By Touggourt
Validate XML message against XSD schema
By José Francisco Jodar
S3
By Touggourt
VSCode - trying to use tag to call SELECT statement
By Scott Roth
Best Practices for Git Integration with Developer Namespaces in IRIS
By Alex Efa
git-source-control questions
By Fiona Griffiths
IRIS Terminal remote connection
By Touggourt
SLF4J error
By john.smith4237
How to create a custom scheduler
By Saman Marasinghe
How to use class property ot type %Persistent in non persistent class (page)
By PagerianDevelper
"Bad value for type long" on select from PostgreSQL via EnsLib.SQL.OutboundAdapter
By Andrew Sklyarov
Convert HTML to PDF
By john.smith4237
%NOCHECK for Objects
By Matthew Giesmann
"garbled text" due to incorrect character encoding or decoding.
By Fahima Ansari
#Other
#HealthShare
#InterSystems IRIS for Health
#Caché
#47Monthly Q&A fromInterSystems Developers
質問
· 2025年4月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
ディスカッション (3)3
続けるにはログインするか新規登録を行ってください
質問
· 2025年4月9日

HL7 add OBX segment at specific locations - Resolved

#DTL #HL7 #相互運用性 #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
ディスカッション (2)2
続けるにはログインするか新規登録を行ってください
お知らせ
· 2025年4月9日

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

#重要な質問 #開発者コミュニティ公式

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 😉

ディスカッション (0)1
続けるにはログインするか新規登録を行ってください
記事
· 2025年4月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.

ディスカッション (0)1
続けるにはログインするか新規登録を行ってください