#Ensemble

Hello,

I want to know if there is any possible way to use the same query for different ODBC schemas.

Thanks.

Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below)

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
set rs = st.%Execute()
do rs.%DisplayFormatted(type,"C:\Temp\report")

I use rest service on Health Connect and will has utilized HL7 FHIR for get information of external database. But i don't find exemplo in oficial documentation.
Someone to utilize the HL7 FHIR for info request in to external database?

So calling this lookup manually from the console works as expected:

However, calling it from a method with some concatination to build the key is giving me problems:

Hi Guys,

I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field?

Hi

Sometimes I search mesage with inappropriate sql, It caused query hanged long time.

So Is it have way to find these hanged query and kill it?

Tks.

How do I send request on production start?

Here's what I got so far in my production class:

ClassMethod OnStart(pTimeStarted As %String) As %Status
{
    job ..InitialTraining()
    quit 1
}

lassMethod InitialTraining() As %Status
{
    hang 5
    set sc = ##class(EnsLib.Testing.Service).SendTestRequest(...)
    quit sc
}

Is there a better way without hang, etc?

Found one interesting behaviour in one system with Ensemble. Some Request class has a property with type %XML.CharacterStream by design, this class is the heaviest request in the system, and with profiling journal files, it got about 40% of the file. When I counted all the sizes of such streams per one day and found that the real stored data is three times less.

I want to test automatically that HL7 business operation works correctly in error conditions. One is to test CE acknowledgement. I have planned to implement test production which includes business services for different situations (AA, AE, CA, CE, timeout, late response etc).

How should I implement HL7 business service that always returns CE (commit error)? I have tried but it keeps returning "AA".

Now that 2017.1 has been released, any indication when we can look forward to the next Field Test starting?

Update on 27-Apr-2017: the 2017.2 FT for Caché and Ensemble is now available via this page.

Update on 02-May-2017: announcement posted here.

I'm trying to develop monitoring API for the following requirements:

What are the possible causes of the following warning in an Ensemble business process?
"1 open user transaction found; committing before Enqueue"

Hello!

I have created a record map that I am going to use to parse a flat file coming into Ensemble. From there I am trying to send the parsed out data as emails to patients. I am getting this error when the Service tries to locate the file and send it through...it finds the file (as it states in the error message). So why does it say it does not exist?

We're moving an Ensemble production from Ensemble 2010 to Ensemble 2017 and in it we have a ebXML SOAP Service. It extends EnsLib.ebXML.Service.SOAPService and just contains one method with a method keyword of SoapAction = ebXML.

We're receiving a SOAP message with a SOAP action = urn:nhs:names:services:pdsquery/QUPA_IN000011UK02 and this is getting rejected with the error message ERROR #6207: Unexpected SOAPACTION value: urn:nhs:names:services:pdsquery/QUPA_IN000011UK02