Question Chris Thompson · Mar 21, 2017

Atelier Auto Indentation (Or lack thereof?)

Is there some setting I'm missing with Atelier when it comes to auto indentation or something not supported yet? I noticed that it won't set the correct indentation when it comes to closing curly braces, as well as no auto indentation when I go to the next line after a beginning curly brace. If it's not something currently supported, is there any ETA on this?

#Atelier
3
0 369
Question sansa stark · Mar 22, 2017

Query

Hi All, In Cache Table i have stored the data value as horlog format ,by query how to retrive the data when i give the data field as date format.

#Caché #SQL
4
0 613
Question Don Rozwick · Mar 22, 2017

How to Search the stream in Message Browser for a EnsLib.HTTP.GenericMessage

Ensemble 2014.1.5

Inbound EnsLib.HTTP.GenericMessage

<?xml version="1.0" ?>
<!-- type: EnsLib.HTTP.GenericMessage id: 349 -->
<HTTPMessage xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Stream>
{ "patient": { "identifier": "E23456778", "token": "PQOIWUE)&!@TT$1234706125" } }

</Stream>

<Type>
GC

</Type>

<HTTPHeaders>
<HTTPHeadersItem HTTPHeadersKey="CharEncoding" xsi:nil="true"></HTTPHeadersItem>
<HTTPHeadersItem HTTPHeadersKey="HTTPVersion">
1.
#Ensemble #Message Search
2
0 882
Question Mack Altman · Mar 16, 2017

Recommendations for server configuration

I have been asked to assist in the planning of the a new server for our database, which we will be changing operating systems from OpenVMS to Linux (RedHat distribution). However, its difficult to find material regarding what would be recommended, which is likely due to the database being proprietary.

In looking at the information provided below and hoping to decrease processing time, would anyone be able to recommend type of configuration we should have for the new Linux server? Please feel free to ask any clarifying questions.

#Caché #Performance #Red Hat Enterprise Linux (RHEL) #System Administration
2
0 1724
Question Susobhan Pandit · Mar 22, 2017

How to create new user for ODBC connection

We are using Cache in our application. We are using default username/password for connecting to the Cache Database through Cache Manege Provider. Can we limit the permission of the user _SYSTEM to access only limited database/namespace.

Can we create new user for ODBC connection? Is there any API provided for creating user with limited access so that the user creation process can be automated.

#Caché #Security
1
0 846
Question Rafael Vergani · Mar 21, 2017

Journal file I/O error

One of my journal spaces has status "IOER" in MSM MUMPS.

I think this is happend during system freeze.

I never seeing a journal file status like that.  I did not find anything about it in the intersystems documentation.

I can simply delete the damaged file, but I'd like to know how to prevent this from happening.

Anyone have some idea about it?

My MSM-UNIX Version is 4.4.0.

Thanks

#Caché #Journaling
2
0 447
Question Don Rozwick · Mar 20, 2017

How to pass SOAP response back to Sender

I have an XML I am sending to an operation from a BPL.  This is a query for Patient information from Epic using a web service.  I created the operation using the add-in in Studio.  I setup the BPL to do a Call and send whatever data I receive from the client.  I get a response back from Epic with a list of matching Patients.  In the BPL I am trying to use the Response Builder to pass the response ID, name, DOB, etc. to matching context items to then pass to the client as a response.

#Ensemble #Beginner #Business Process (BPL) #Error Handling
4
0 1208
Question Oleg Dmitrovich · Mar 12, 2017

Using Atelier REST API

Hi everyone!

From documentation:

... Unless ... you need to provide a username and password to access the API ...

... so the complete URL for GetServer is: http://localhost:57772/api/atelier/

Try this:

curl --user name:password "http://localhost:57772/api/ateiler/"

Response is:

<HTML>...<BODY><H1>Not Found</H1>
The requested URL /api/ateiler/%CSP.Login.cls was not found on this server.<P>
</BODY></HTML>

What I'm doing wrong?

#Atelier
5
0 3167
Question Stella Ticker · Mar 18, 2017

Returning the MAX value of 2 fields in a select statement

I am trying to return the maximum of the value of 2 fields: LastViewed and LastDownloaded  AS a local variable -LastAccessed for each row, using a SQL query . These values are stored as $ H format.  Is there an existing SQL command that compares two column values ? I could not find one, so I tried using a $Select statement . I got an error that said A term expected beginning with either of: identifier, constant, aggregate, $$,(,:,+.

#Caché #SQL
5
0 1188
Question Tom Philippi · Mar 18, 2017

Generating JSON message with attributes containing odd characters

I have a Enslib.REST.operation which I want to use to send a JSON message. In Ensemble I am using the request message to the Business operation as an input for ObjectToJsonStream function so I can send it out (this is the way to go right?). However, I am now running into the fact that one of the attributes (template_name) contains an underscore and that I am not allowed to use the underscore to define the property in my ensemble RequestMessage:

Property template_name As %String;

What's the best way to resolve this?

#Ensemble #REST API
1
0 453
Question Tom Philippi · Mar 15, 2017

Can't get REST operation to work

I am relatively new to ensemble, but I am trying to build a REST operation using the enslib.Rest.Operation but I can't seem to get it to work at all. I am completely at loss here because the errors I am receiving are very unclear. I have tried a few different variants using PostURL and SendFormDataArray but I got errors on all variants. Suggestions are welcome.

The call I am trying to product is a simple ping message to the Mandrill APIat https://mandrillapp.com/API/1.0/users/ping.json (for more details see: https://mandrillapp.com/api/docs/users.JSON.html#method=ping).

#Ensemble #REST API
2
0 1119
Question Rich Taylor · Mar 16, 2017

Telnet in a ZEN page

I need to find a solution for a client that has ZEN based application.  Certain parts of this application remained Terminal based for which a unsigned Java applet was used to embedded this within the application.  The control is old and requires an old version of Java which IT folks are not happy about.  

I am looking for a replacement that will allow a terminal, either telnet or directly use cTerm, window to be embedded within a web application, specifically ZEN, based on Cache.  Any suggestions or success stories would be welcome.

#Caché #Terminal #ZEN
5
0 453
Question Chris Stewart · Jun 9, 2016

REST Services Cataloging

I've been building up a REST services API, consisting of a dozen or so classes referenced from a Dispatch class, which has route mappings for the first piece of the URI.  I'd like to have the Dispatch class be able to output all of the available Services, with some documentation.  Is there something like a %Library resource that I could use to pull this information from each of the classes?

Thanks

Chris

#Caché #Data Model #REST API #Mapping
7
0 958
Question Ravi Akkiraju · Mar 16, 2017

HL7 Service - design question

noob here..(moving from JCAPS to Ensemble)

We are wondering where is the best place to tie the schema category for an incoming HL7 message? Should we do this within the service (via the message schema category setting) or receive everything and validate in the process (DTL) level?

We want to capture everything that will be sent to that HL7 listener service and then decide what to do with bad messages at the process layer.

Does anyone have any recommendation regarding this? Appreciate your input and decision thought process.

Thank You,

#Ensemble #Beginner #Business Service #HL7
3
0 415
Article Carter Tiernan · Dec 22, 2016 2m read

The Polymetric Dashboard

> Customizable System Monitoring. ## Introduction The Polymetric Dashboard is a stand-alone module that provides enhanced monitoring tools for a Caché environment. Equipped with over one hundred sensors that monitor key system metrics, a robust REST API, and a modular AngularJS user interface, the Polymetric Dashboard is fully functional out of the box. However, the Polymetric Dashboard is designed to be customizable; any system metric can be monitored by creating a new sensor, and the visualization of collected data can be tailored to specific requirements and purposes.

#Caché #Tools #Monitoring #Visualization #Caché
20
1 1750
Article John Murray · Mar 11, 2016 1m read

Defining global, routine and package mappings that apply to (almost) all namespaces

In this posting I want to raise the profile of a feature that arrived in 2009.1 but is perhaps not very well known.

It is sometimes useful to make certain packages, globals or routines available to all of your namespaces. Of course you can add the necessary mappings whenever you create a new namespace, but here's a simpler way.

First you need a special namespace definition called %ALL Create it in the same way you'd create any namespace. It doesn't matter which database you set as its default for code and data.

#Caché #Caché #Ensemble #HealthShare #Mapping
6
0 1654
Article Michael Braam · Feb 20, 2017 14m read

Making encrypted datafields SQL-searchable

Overview

Encryption of sensitive data becomes more and more important for applications. For example patient names, SSN, address-data or credit card-numbers etc..

Cache supports different flavors of encryption. Block-level database encryption and data-element encryption. The block-level database encryption protects an entire database.  The decryption/encryption is done when a block is written/read to or from the database and has very little impact on the performance.

With data-element encryption only certain data-fields are encrypted.  Fields that contain sensitive data like patient data or credit-card numbers. Data-element encryption is also useful if a re-encryption is required periodically. With data-element encryption it is the responsibility of the application to encrypt/decrypt the data.

Both encryption methods leverage the managed key encryption infrastructure of Caché.

The following article describes a sample use-case where data-element encryption is used to encrypt person data.  

But what if you have hundreds of thousands of records with an encrypted datafield and you have the need to search that field? Decryption of the field-values prior to the search is not an option. What about indices?

This article describes a possible solution and develops step-by-step a small example how you can use SQL and indices to search encrypted fields. 

#Caché #Encryption #Indexing #Object Data Model #SQL
9
2 1931
Question Leon Duveen · Mar 16, 2017

Help creating Web Methods for a SOAP HL7 Receiver

I am configuring a SOAP HL7 Receiver to handle HL7 Query messages.

I have set up a new class based on EnsLib.SOAP.Service and configured (correctly I hope) the parameters needed.  I have also amended the OnProcessInput Method skeleton provide to send messages on to the Business Process needed.

I am struggling to work out what is needed in the Web Methods and how to create them. 

Any help with this would be much appreciated especially examples that I can adapt for what I need.

Many thanks 

#Ensemble #Business Service
1
0 446
Article Orion Correa · Mar 14, 2017 2m read

Sending Email notifications "On behalf of"

A feature I recently used in working on ISC internal applications is the ability to send emails on behalf of someone. This is useful when generating system notifications from an application when you want some of them to show up as being from a specific person, perhaps posting comments on a work ticket.

In my case I was updating our facilities work order system for tracking requests. Normally all notification emails are sent from the same noreply email address. I wanted to change that so comments added from the original requester would show up as being from them and stand out.

#Caché #Code Snippet #Tips & Tricks #Caché
2
0 1117