Article Eyal Levin · Apr 9 1m read ODBC / JDBC data truncation Hi, I hope this post helps. The bottom line: MAXLEN is relevant mostly for odbc/jdbc connections and you need to specify an appropriate value within your tables (classes), otherwise the data might be truncated when you query it, or even fail when you try to insert data. Long story: #JDBC #ODBC #InterSystems IRIS 2 7 0 328
Article Eyal Levin · Apr 8 1m read using Procedure Parameters with ODBC/JDBC Hi, I was struggling with a procedure that was meant to receive a string and use it as a filter, I've found that since I want the procedure to do some data transformation and return a dataset, I needed to use objectScript language. I've created the procedure using the SQL GUI in the portal, and everything works fine when calling the procedure from the SQL GUI but not through a JDBC connection here is the call "call spPatientOS('2024-04-07T12:35:32Z')" #JDBC #ObjectScript #ODBC #SQL #InterSystems IRIS 3 2 0 224
Question Eyal Levin · Feb 25 How can I transer data from one patient to another? Hi, I have a scenario where I recognize that I have a duplicate patient in FHIR , both have a different set of data attached to them (Specimens / Observations / Conditions) and I want to transfer all the data from patient X to patient Y, and maybe mark patient X as not relevant or delete it IDK yet. since Patch currently supports only single patch, "The Conditional Patch query identified more than one resource." #FHIR #JSON #InterSystems IRIS for Health 1 5 0 230
Discussion Eyal Levin · Feb 6 FHIR interoperability Hi everyone, I was discussing the interoperability side of FHIR as part of a discussion about the best resource/s that should be used in order to represent Antibiotic resilience, and although we've reached an agreement, that got me thinking of two thing, and I'd love to know your thoughts on those matters. #FHIR #Interoperability #Global Masters #HealthShare #InterSystems IRIS for Health 1 4 1 295
Question Eyal Levin · Jan 28 External backup - exceeding the maximum duration specified Hi, I was wondering if anyone already dealt with this issue:"System has been suspended for over X seconds, exceeding the maximum duration specified. Allowing system activity to resume. Any ongoing backup has presumably failed. Next InterSystems IRIS backup must be a full one" our backup system "Commvault" is automatic, how do you tell it once you get this message that the next backup should be full? thanks, Eyal #Backup #Kubernetes #InterSystems IRIS #InterSystems IRIS for Health 1 11 0 233
Article Eyal Levin · Jan 21 1m read Debugging a crashing container I have been struggling with a docker run command that kept crashing, the error message was too generic to point me to the right direction. Since the container is shut down after the failure, I was unable to login to it in order to figure out the problem. I had to run the container in a way that I'll be able to log into it before it crashed, so I found the adding -u false prevents the docker run command to run the iris session IRIS and the container stayed up and running. then I was able to log into it using: #Containerization #Docker #Namespace #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 4 0 0 149