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?

00
0 5 29

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)

00
0 0 52

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

 

00
0 2 77

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

00
0 3 102
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

 

00
0 4 209

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.

00
0 2 102
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

 

 

 

 

00
0 4 153