Question Yakov Berger · Nov 21, 2023 Configure SQL.OutboundAdapter to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Hi, DBA has asked me to configure a working Business Operation using a SQL.OutboundAdapter (connecting to external MSSQL server) to run as TRANSACTION ISOLATION LEVEL READ UNCOMMITTED. I would like help with an example of how this is done. Thanks #SQL #InterSystems IRIS 0 4 0 191
Question Yakov Berger · Nov 28, 2021 How To Get Stored Procedure Output? I have a stored procedure (MSsql) which has one input and one output parameter. and a Business Operation calling the SP The following code executes the stored procedure successfully , but does not return the output. what needs to be fixed? #InterSystems IRIS 0 5 0 381
Question Yakov Berger · Nov 21, 2021 Getting SCOPE_IDENTITY() from SQL SERVER Hi, In a Business Operation i have the following code. I need the identity of the latest row inserted in a table in MSSQL. i Have the following code: --------------------------------------------------------- set insertmaster= "INSERT INTO dbo.dataMasterArchive(deviceToPatientLogID) values (?)" set tSC = ..Adapter.ExecuteUpdate(.nrows1,insertmaster,pRequest.deviceToPatientLogID) $$$ThrowOnError(tSC) #InterSystems IRIS 0 2 0 508
Question Yakov Berger · Oct 4, 2021 Business Process Designer Error - You must specify a response message class in order to build call response actions. I added a Response Message Class to a call in the Business Process Designer. When i click on Response Actions or on Response Builder i get a message "You must specify a response message class in order to add or edit response actions." no matter which response message i choose i always get the above warning. how do i fix this? Thanks #InterSystems IRIS 0 2 0 166
Question Yakov Berger · Aug 25, 2021 TCPInboundAdapter - AllowedIPAddresses Error After setting AllowedIPAddresses with a valid IP address i get the following errors. ERROR <Ens>ErrException: <READ>zOnTask+44 ^EnsLib.TCP.InboundAdapter.1 -- logged as '-'number - @'' what am i doing wrong? and question: where in the message viewer can i see the source IP of the message? Thanks #InterSystems IRIS 0 3 0 130
Question Yakov Berger · Aug 17, 2021 $ZF(-100) to run Windows batch file (*.bat) Hi, i am trying to run a windows batch file using $ZF(-100) $ZF(-100,"/ASYNC /LOGCMD","C:\batch_files\ab_bat.bat") doesn't seem to be working (no error just the batch files contents no executed). should this work? Thanks #InterSystems IRIS 0 4 0 559
Question Yakov Berger · Dec 13, 2020 How to Parse TCP Inbound XML Hi I have a medical device (Nipro Surdial Dialysis ) which sends XML messages by TCP. I would like to insert some of the info into a SQL SERVER table. Is there some sort of TCP Inbound Adapter for XML ? Thanks #InterSystems IRIS for Health 0 3 0 377
Question Yakov Berger · Dec 6, 2020 Copy GatewayResultSet To Another Table Hi, in a Business Operation I have a Gateway ResultSet obtained by ..Adapter.ExecuteQuery() from table A (MS SQL) which i would like to copy to table B (MS SQL). what would be the best way to do this ? Thanks #InterSystems IRIS for Health 0 1 0 171
Question Yakov Berger · Oct 29, 2020 Reply with custom ACK Hi,i have created a simple production with: Business Service-EnsLib.HL7.Adapter.TCPInboundAdapter Business Process - EnsLib.HL7.MsgRouter.RoutingEngine Business Operation - EnsLib.SQL.OutboundAdapter the sending application requires a ACK wich is different than the ACK i choose from in the AckMode settings of the Business Service. How do i create a custom ACK? Thanks #InterSystems IRIS for Health 0 4 0 643
Question Yakov Berger · Oct 27, 2020 Newbie - DTL Test Tool Works - DTL Doesn't Newbie Warning... I have a DTL which accepts HL7 2.3:ORU_R01 And Transforms to Custom Request Target the target request contains an array of a custom class named OBXobj with some %string properties which Extends (%RegisteredObject, %XML.Adaptor) in the DTL i have a for each loop which should copy OBX segments to the the request. #InterSystems IRIS for Health 0 2 0 337
Question Yakov Berger · Aug 19, 2020 SQL To EXCEL Hi, I have some SQL querys i would like to run using an Outbound SQL Adapter and save the returned rowsets in excel format (each rowset in a seperate excel file). What is the best way to do this? Thanks #InterSystems IRIS 0 4 0 354
Question Yakov Berger · Jul 21, 2020 Problem With Message/Segment Terminators Hi, A device is sending me HL7 messages (ORM^O01) the framing is set to "None" and i get the following error: 3 SegmentsBuild Map Status = 'ERROR <EnsEDI>ErrMapRequired: Missing required PID element at segment 2 (PID)''ERROR <EnsEDI>ErrMapRequired: Missing required OBR element at segment 2 (PID)''ERROR <EnsEDI>ErrMapSegUnrecog: Unrecognized Segment 2:'PID' found after segment 1 (MSH)' i seems that there framing chars in at the beginning and end of each segment (in Hex) #InterSystems IRIS for Health 0 3 0 688
Question Yakov Berger · Mar 12, 2020 How to populate and then then query a staging table in a Business Service Hi, Newbie Question. I have a Staging table i want to populate by running a Stored Procedure and then query the same table with some sort of SQL inbound Adapter. is this possible or do i need to create a separate service for this? Thanks #InterSystems IRIS for Health 0 1 0 285
Question Yakov Berger · Mar 1, 2020 SQL Inbound Adapter Errors Hi, I created a BS with a SQL Inbound Adapter. Query = "SELECT rowid, fname ,lname,datesent FROM labs WHERE datesent IS NOT NULL" DeleteQuery = " update labs set datesent = Getdate() where rowid = ?" KeyFieldName = "rowid" i am getting the following errors. "NOT assuming network disconnect error based on: Gateway failed: DropStatement." "Skipping previously errored row '235'" #Interoperability #SQL #InterSystems IRIS for Health 0 1 0 303
Question Yakov Berger · Feb 17, 2020 Refresh Source Request in DTL Hi, i have a DTL with generic source request (Inbound TCP). i have added a parameter in the request class and compiled. how do i now refresh or resync the DTL so that i see the new added field in the source. Thanks #InterSystems IRIS for Health 0 3 0 184
Question Yakov Berger · Feb 11, 2020 <PROPERTY DOES NOT EXIST> Hi, I am using IRIS for Windows (x86-64) 2019.1.1 I have. 1. Created a BS with SQL Inbound Adapter which successfully connects and gets rows from DB . 2. Created a request message is populated with results of SQL query. 3 Created a BP with HL7 Router + Routing Rule + Transformation + Send to Target (BO). 4 . Created BO sending HL7 to file. i am getting the following error. #Interoperability #ObjectScript #InterSystems IRIS 0 8 0 866
Question Yakov Berger · Jan 21, 2020 TCP Inbound Adapter - Call Interval Error hi, Product: IRIS for Windows (x86-64) 2019.1.1 (Build 612U) Mon Oct 28 2019 11:29:24 EDT [HealthConnect:1.1.2] i am using a TCP Inbound Adapter with call interval set to 5. To my understanding this means that the adapter check to see if there any connections to the port every 5 seconds. #Health Connect #InterSystems IRIS for Health 0 1 0 423