when doing ETL process from cache database to mysql database(ods) and to another mysql database(dwd).

There are lots of DR columns in one table.

In the first step we need two databases to be totally consistent(ods=cache database)

However, the DR column in another database lost its meaning and become to normal number.

In the last step we do the data governance in ODS to DWD. My question is how to write sql without many `join` in this step.

0 0
0 112
Question
· Dec 4, 2024
Error importing XSD

I'm attempting to import all the FHIR XSD files provided by http://hl7.org/fhir but get the immediate and unhelpful error message:

I've tried different versions of EOLs to no avail. Any idea what this error could mean?

Here's the XSD I'm trying to import:

<?xml version="1.0" encoding="UTF-8"?>
<!--
Copyright (c) 2011+, HL7, Inc
All rights reserved.

0 0
0 100

We've implemented SAML authentication for our application where we are the service provider and various other entities are the identity providers. We've done successful connections with several identity providers including Okta, Duo Mobile, Ping Identity, and Azure. Validating the SAML response with signed assertions has been working great. Now, I am trying implement support for the SAML assertions in the response being encrypted for a new identity provider and struggling to understand procedurally how to go about this.

0 0
0 470

We've just started using Health Connect and I've found that a lot of the messages we get from our patient admin system (System C's CareFlow EPR) don't match the standard 2.3.1 schema (eg 2.3.1 ADT A02 message spec doesn't include NK1 segments, but the ones we receive do)

Does anyone have a custom schema they use for messages from CareFlow EPR that they'd be willing to share?

0 0
0 84

What is the reason for

RUN apt-get update && apt-get install -y \
git \
nano \
python3-opencv \
sudo && \
/bin/echo -e ${ISC_PACKAGE_MGRUSER}\\tALL=\(ALL\)\\tNOPASSWD: ALL >> /etc/sudoers && \
sudo -u ${ISC_PACKAGE_MGRUSER} sudo echo enabled passwordless sudo-ing for ${ISC_PACKAGE_MGRUSER}

I think I get error because I do not have sudo privilege in the environment where I use podman to build the image

podman build --tag oliver3 .

0 0
0 214

Hi everyone

I hope this message finds you well. I am currently working with a database system that allows the configuration of certain options using the SET OPTION statement.

SET OPTION SUPPORT_DELIMITED_IDENTIFIERS = TRUE;

I understand that this setting takes effect at the system level, impacting all sessions and processes. However, I am looking for a way to enable support for delimited identifiers that only affects the current session, without altering the global configuration.

My question is:

0 0
0 85
Question
· Apr 19, 2025
Error in iris-rag-demo

I cloned iris-rag-demo from Open Exchange and issued docker-compose up -d. I went to the front end and type in the chat message:

Who was the 46th President of United States of America?

I got a run time error:

RuntimeError: ERROR <Ens>ErrBPTerminated: Terminating BP ChatProcess # due to error: ERROR #5002: ObjectScript error: <PYTHON EXCEPTION> *<class 'RuntimeError'>: <PYTHON EXCEPTION> <class 'ValueError' > ERROR #5002: ObjectScript error: <PYTHON EXCEPTION> *<class 'RuntimeError'

Traceback:

0 0
0 77

I have set up an ODBC driver for InterSystems and would like to set up a linked server. This all works except I cannot see the columns details. If I access the database from excel I can get the columns and types of the various tables

Any help or instructions would be appreciated

Terry

0 0
0 71

Good morning,

First of all, thank you very much in advance for reading and responding.

Also, thank you for any support, because it is a relief, support, contribution, help to have people with more understanding, knowledge and practice, reading, and thinking this doubt.

There is the following need:

Two 2 circuits are available:

1st DICOM Circuit of "Studio" ( Classic Service ).

Service: class: DICOM.BS.QueryService

Process: class: DICOM.BP.QueryProcess

0 0
0 283

I'm new user learning to use Iris and Ensemble. I'm trying to set up a TCP interface to send delimited data from Ensemble to another interface engine. I created File.PassthroughService to pick up the file and send the data to TCP.Framed.PassthroughOperation. The framing is MLLP and SSL configuration used. It is able to process small files around 50kb. When I drop a larger file such as 5mb, the operation is not getting the ack within the 60 sec timeout.

0 0
0 253
Question
· Mar 26, 2023
Adding Expando to tablepanel

Hi Guys,

How can I include an Expando in a tablepane, I would like that each row have an expando that I can use to include some other things as in the below screenshot

0 0
0 241

I recently created a new foundation namespace in my IRIS for Health instance. I am noticing that Registry entries such as the Service and XUA registries (HS.Registry.Service.SOAP and HS.IHE.XUA.Config) from my previously created foundation namespace are not available in my new namespace. Is there a setting that controls this, or is there a way to map these registry values to my new namespace? Other developers I talked with on my team expected these registry entries available to all namespaces and were surprised when I reported they were not.

0 0
0 190