InterSystems FAQ rubric

For volatile tables (tables with many INSERTs and DELETEs), storage for bitmap indexes can become inefficient over time.

For example, suppose that there are thousands of data with the following definition, and the operation of bulk deletion with TRUNCATE TABLE after being retained for a certain period of time is repeatedly performed.

3 0
0 311

hi,I meet a problem,i want to move huge data from ensemble to oracle.it`s about 3years business data.i have tried some case!

1. EnsLib.SQL.OutboundAdapter

i parse the data one by one,and translate it into inser or update sql statement then write to Oracle,it·s most slowly,and take more disk space。

2.save the data to a new table,and then use dbeaver transport data to oracle。

3.user linktable. save object as insert,but,i can·t user %openid method.

0 1
0 310

Hi

we are trying to call a Webservice that is hosted on a Ensemble production from a .net program.

The web application in ensabmle is defined with password authntication

we can't get to set the security header in the .net program (<soapenv:Header> ... <wsse:Security ... <wsse:UsernameToken ... ) in SoapUI we added the Wss usertoken and it worked like a charm.

Doe's anyone have a idea to guide us? (links, ,samples, etc. )

Thanks

Gadi

0 1
0 310

Usualy, if you want to deploy a solution, you need to add the items, configure your lookup tables and default configuration manually.
It's okay if you have all the permissions and privileges to perform these actions. If you want to deploy to a client's production server, and you don't have the permissions, you need to indicate in a document ALL the steps that the deployment manager has to perform.

2 0
0 310

Hi all, My first post. I hope I have created it correctly.

Our team is looking to increase the number of characters in our Ensemble 'Categories' for Services, Processes and operations.

We are doing this to better identify things like Vendor, Message type and integrated application names...

One of our team members thought his might increase processing overhead and a discussion ensued that was not resolved.

my thoughts...

0 2
0 309
Question
· Apr 10, 2022
SQL query confusion

Hi Guys,

I'm a bit confused where if I run a query trough SMP I don't get any result which should be true but if I run the same query from a classmethod I get a query result which shouldn’t be even if I pass any gibberish parameter into my class method because I'm sure there should be any data? see attached

0 7
0 309
Question
· Mar 3, 2024
base64 data to pdf

hi there , when i convert a pdf to base64 data, and then restore the data to pdf,i find that ,i must read the same as length of base64 data every time convert ,or i can't get the right pdf. the code is:

1 3
0 308

I have a production that takes in an HL7 message thru a business service. The business service passes the incoming HL7 message to a business process that calls a transform to transform the HL7 message to a message class. After the transform is finished, the business process uses a code block to pass the object created by the transform to a method class that processes the data in the object. What would be the correct syntax for passing in the object to the class method?

0 2
0 308
Question
· May 13, 2021
Incoming http messages setup

I need some help. I have a requirement where HL7 messages will be sent through http. I am trying to read through the documentation & want some guidance.

The client is asking for a URL. So should I simply send the Ensemble url to them? Does the message structure change? How does Ensemble handle incoming http messages? Do I just create a http business service and it should come across fine?

Has anyone done a project with http? Would love some information on how it worked for you

0 1
0 307
Question
· Jun 9, 2020
Cache SQL question

I have a table with 4 column: MRN (primary key), Name, DOB, and Gender. I want to bring in the values on all of the columns into a DTL. Currently, I declare variables for each of the columns and using 3 select statements.

0 4
0 305

Hello ALL!

I am having trouble fining a way to derive (a list, an array, a file doesnt matter yet how it returns) ALL of the targets of a routing rule.

For example lets say I have:

  • a router of class: EnsLib.MsgRouter.RoutingEngine
  • Business Rule: HappyRRN
  • 1 rule set having 5 rules that each send to 1 DTL and 1 Operation (5 targets total)

My intent is to use some utlities we have created to disable all of the target operations of this router if the router errors out.

To do that I need the list of target operations.

1 2
0 304

Hello community!

I'm creating a script to remove an item (component) from the Ensemble production, I know there is a manual way to do it but as there are several components the idea is to use a script to be faster.

I tried using %Delete() and doing a select on Ens.Config.Item, but this ends up generating several errors in production. Does anyone have any idea how I can do this simply?

0 2
0 304
Question
· Jun 21, 2021
SIMPLE FTP PRODUCTION

Hello developer community, I'm looking for Ensemble production sftp examples. I need to copy hl7 files hourly from several servers to a central server. The local documentation is no longer as good as it used to be. I remember several years ago, the documentation would take you step by step doing this. Any information would be appreciated.

thanks,

Rob S

0 2
0 304

Hi all.

A long time ago I enabled Activity Monitoring to be able to save myself headaches in the future when looking at the performance of various message routes through our productions. It's served it's purpose of answering questions on how many messages we process a week etc but I had not had the chance to really dig down into the stats for specific message types or destinations to pin point issues.

0 3
0 303

We have a set of some fairly standard HL7 interfaces that usually end up doing about 90% of the same thing as every other interface. I'd really like to be able to write a script that I can modify some text, and have it create Services, Processes, Operations, DTL and Business Rules.

So, let me provide a more concrete example: I feel capable of a writing to and replacing variables within a text file, different process. This is obviously going to be pseudo-code, but my thinking is this

Create "Memorial Hospital Process"

Create "Memorial Hospital

0 3
0 303

Hi All,

I have configured Business Operation with EnsLib.HTTP.OutboundAdapter and set properties.

In the BusinessOperation method I am trying to create %Net.HttpRequest

Set httpRequest= ##class(%Net.HttpRequest).%New()

to post REST Service.

I am able to access HTTPServer ,URL details form Adapter using below code

Set httpRequest.Server = ..Adapter.HTTPServer
Set httpRequest.Location = ..Adapter.URL

How to read SSLConfiguration from Adapter properties?

2 3
0 301