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

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?

set outparm = ""
set pResponse = ##class(Ens.StringResponse).%New()
SET SQLQuery2 = "{call s_sproc (?,?)}"
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,"io*",pRequest.StringValue,outparm )
set pResponse.StringValue  = outparm 

Thanks
 

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)

set sql ="SELECT SCOPE_IDENTITY()"
set tSC = ..Adapter.ExecuteQuery(.tResult,sql)
$$$ThrowOnError(tSC)

set maxID = tResult.Get(1)

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

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

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

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

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

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

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.

the DTL test tools works and builds a XML with the OBX info.

when running the Production i get NULL in the Object.

see attached images

1. Test

2. Message sent.

3. Transformation

Whats my problem?

Thanks!

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

Hi,

 A device is sending me HL7 messages (ORM^O01)

the framing is set to "None"

and i get the following error:

3 Segments
Build 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)

 0b (MSH DATA HERE)  1c 0d  0b  (PID DATA HERE)  1c   0d   0b  (OBR DATA HERE)  1c 0d

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

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'"

"Assuming network disconnect error based on: SQLState: (HY000) NativeError: [0] Message: [Microsoft][SQL Server Native Client 11.0]Connection is busy with results for another command"

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

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.

ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zOnRequest+1^EnsLib.MsgRouter.VDocRoutingEngine.1 *DocType,Test.SQLtoHL7Req -- logged as '-' number - @''

What am i missing

Thanks.

hi,

Product: 

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.

But i am getting error  "No Connection made on port 12123 within interval 5"

The sending application connections to the port happen at no specific interval, what are the recommended setting for call interval?.

Thanks