Hi,

I tried to join my local DB table with link table. but I am getting below error.

5475 5475 reporterr2+40^%occRoutine Error #5475: Error compiling routine: %sqlcq.HSANALYTICS.cls483. Errors: %sqlcq.HSANALYTICS.cls483.cls(%OnNew+5) : SQLCODE=-161 : References to an SQL connection must constitute a whole subquery

I tried to execute below query in Managementportal

select dg.ID from HSAA.Diagnosis dg
left join LinkTableData.FacilityFullList la on dg.ID=la .ID

0 1
0 33

I'm testing an HL7 2.4 -> HL7 2.3.1 set of transformations. For the time being the source (service) and sink (operation) are file adapters. What I'd really like is to be able to save the output file with a name matching/containing the input file name - but as the DTL transformation in between uses "new" rather than "copy" it looks like I'm losing (some of?) the metadata, including the "Source" field (Body tab, message viewer).

Is there any way of preserving the Source field so the OutboundAdapter has access to it?

0 2
0 158

Hello Developers.

I have a question regarding X12 834 file for Payers.

We have a client thats sending X12 834 file with single ST SE block and has thousands of members in one single block and X12 process is throwing STORE error when processing this file.

Has anyone ran into this issue and has a way of splitting 834 file into single <ST> <SE> block?

Thank you in advance

Sheetal

0 2
0 96

Hi Guys,

Our system admin has installed a new SSL certificate to replace the old one in our Windows server 2016.

So should it be ok to just then remove the old Certificate given that we installed the new one, knowing that the old one has been used previously or do we need to do something in existing SSL/TLS configurations ?

0 2
0 103

Hi Community,

I am configuring new SSL Configuration for Gmail (For sending errors to gmail in ensemble production) by following the below steps.

Step1:

Step2:Giving the server address smtp.gmail.com

Step3:Giving the port number , I have tried giving 465,587,25 as port number still is not connecting

Can anyone please tell me where i am doing wrong on configuration?

Thanks,

Saroja.A

0 5
0 282

Hi Guys,

My understanding is that SQL gateway connection is a way where you can have two ensemble instances where in instance A you can have a class and then you create a connection from instance B and you can run queries for that table from instance A into B?

But as I checked the doc, it says that SQL gateways is a way to just import data from an instance to another?

Thanks

0 1
0 163

I was able to run the Cache terminal from the command prompt with the following command, in the namespace that I provided in the brackets:

cterm /console=cn_ap:ENSEMBLE[TEST_1]

But the command suddenly stopped opening the terminal in the correct namespace. It just opens it in the default namespace. I tried it with different namespaces or invalid namespaces, it always opens the terminal in the default namespace now.

I cannot figure out what is causing this behaviour.

0 5
0 814

We have a handful of cases where we get reflex orders in an interface that contain multiple OBR segments. These are rare but when we get them, they are causing errors in down stream systems because we are unintentionally excluding OBR segments.

Questions:

At the DTL level - is it possible to iterate over this segment WITHOUT altering the underlying schema? If so what would that look like?

0 1
0 62

Hi Guys,

This link (https://github.com/CassiaNetworks/CassiaSDKGuide/blob/master/node_exampl...) uses Javascript request to open a a steam and collect data in an array (screenshot below) and I'm trying to replicate this with Cache script with HTTP request which is connecting Ok but don't know how can I collect data because the code is hanging at Set tSc=Httprequest.Get(HttpURL) and cannot execute S BLEConnect=Httprequest.HttpResponse.StatusLine or any line after it.

0 9
0 107
Question
Smythe Smythee · Sep 28
Ens.DataTransform

Hi ,

I am Converting HL7 message into SDA3 format by using Ens.DataTransform Class but transformation is not happening while using this class and throwing the below error

ERROR <Ens>ErrException: <UNDEFINED>zTransform+1^Hosiptal.SDA3.DataTrans.1 *target -- logged as '-' number - @' Set target.Patient.Name=source.GetValueAt("PID:5")'

Let me know if any mistake please refer the below code

0 15
0 143

I'm trying to send a message into a production on change a persistent object.

And when I change an object using SQL - I get an error,
when change the object using objectscript - I get a message (but not an error or exception)
But the most interesting - everything works fine (the object has been changed, and business service receives data)

Persistent class

1 2
0 67