Hi, Community!

Please see the digest of Articles and Questions published in February 2017.

Most viewed

Part II – making community package manager  250

Converting documents with Caché and LibreOffice  160

Using InterSystems Caché and Apache Zeppelin  132

Making encrypted datafields SQL-searchable   131

How Intersystems Caché fits in the Graph Database Arena !  117

Can you keep a secret?  109

Creating custom SNMP OIDs  104

Notepad++ Language Pack for COS?  103

Scripted/Automated Production Deployment?

Hello. New to the forum and was hoping I could get some expert help here. I have one data set that is using CHD Logic to combine Procedure and Diagnosis codes to define Sensitive data and flag the record for additional protected filtering. The files coming in define what is flagged and the Clinical Info Rule and Clinical Info Type are tied to the flag in the file which identifies it as a additional protected record.

Hi, Community!

We have a new release here!

What has been introduced:

1. Better notifications

With this release I hope you will turn on back the email notifications because every new notification today in the beginning of itself will tell first, why did you get it describing the exact reason you got this particular notification.  And if you don't want this type of notification to be delivered anymore click unsubscribe link in the notification and it will lead to the settings of this very type to alter.

Also, I can indeed recommend digest mode (Use Subscriptions/Overview to turn it on).

Hi!

Consider I have a class Package.Data with Property UniqueStringValue as %String.

I introduced the Index for this property:

 Index ValueIndex on UniqueStringValue [Unique];

It works well.  But if I try to check if there is an object with the certain value in code like this:

if ##class(Package.Data).ValueIndexExists(value)  

this expression fails, if value="value", even if there is an instance with instance.UniqueStingValue="Value"

How can I set the index to prevent saving case sensitive values in this class?

I am having a problem getting pair key authentication to work on my local PC. I am using freeSShd as the SFTP server. I generated private and public keys using putty gen . I used these keys to successfully log into the root directory using both Winscp and Putty. But this is not working with an FTP Operation. Below is the error that results. freeSSHd server log shows that I log in but immediately disconnect.

I am working on HS2015.1.1 Please help !!

failed for

Hi!

There is an option to introduce Named filters in Analyser and save it with the pivot.

How can I make the Named filter available in a dashboard?

The recent announcement of a collision for the SHA-1 hash algorithm has caused some consternation:

https://shattered.io/

Here is some background to help put this in perspective.

Cryptographic hash functions can have a variety of properties.  The property at issue here is:

"Collision resistance - it is computationally infeasible to find any two distinct inputs x, x' which hash to the same output, i.e., such that h(x) = h(x')."

(Menezes, van Oorchot, and Vanstone, "Handbook of Applied Cryptography", section 9.2.

As well as participating in DC I continue to monitor the Google Group at https://groups.google.com/forum/#!forum/intersystems-public-cache

Since yesterday the Google Group has started receiving postings from a user called intersystems.dc. These postings look like they're trying to replicate DC postings, though images don't appear. Nor are there any links leading across to DC, which is where the follow-up comments and answers are likely to appear.

Is this feed something that the DC software is now doing? Or is it some independent person's initiative?

In my country we speak in spanish. My developing machine uses windows 8.1

I made a nice looking html mock-up using angular material (in Atom, writing in UTF-8). I just moved that mock-up to the CSP folder inside Ensemble and it shows the typical weird characters of character encoding problems.

Have you had an issue like this before?
My temporal solution for the html files: I just configured Atom to read the files in Windows 1252 encoding.

However I still see weird characters on a query to the DB (I made a rest service that returns a json than in turn I use to fill a select input in the html)

I created an outbound FTP File Adapter operation and I need to duplicate it to like 10 namespaces.  I went to tools and clicked "Export" and saved it to the filesystem as an XML file.  Now... how on God's green earth do I import it into another namespace?  I'm cursing and throwing things over here...

(Note: I thought I had already posted this, but I think it was the other day when you were having hosting issues. Sorry if it is a duplicate)

Lots of comments really screws up the layout.

Hi everyone, I have and Zen Mojo application, it's all working but I have some doubts about what is recommended to use: There is some reports of employees, for example, and actually I'm using some plugins : "Excelent export" to generate Excel reports and "jspdf" to generate PDF reports in client side.

I have an REST service, that receives the request, process and returns JSON, after client side receive the response it's processed.

- This can be slow/bad in applications with large data?

- It's better/recommended to use ZenReports even with ZenMojo applications?

While I can see the benefits that $ZSTORAGE could have if used properly, I have not seen it used in the environments I have worked in. I was wondering if there are any developers that promote its usage.

If used properly, I would imagine it could be highly effective in maximizing free memory since some processes will never go over X amount, while others may very well need much more.

I'm new to learn Rest Services in Cache.

I have REST.DocServer class file in local system. When I tried to run this file I have the error as HTTP ERROR 403. 

Can anyone help me to run this sample Rest Services program?

Thanks in Advance.

If you had to choose Angular 1 or 2 for a new web project using Caché/Ensemble as a backend, Which one would you choose?

Hi!

I'm trying to implement %OnAfterDelete ClassMethod for persistent class. As a parameter it gets oid As %ObjectIdentity for the deleted object.

ClassMethod %OnAfterDelete(oid As %ObjectIdentity) As %Status

My question is: how to get ID value from %ObjectIdentity ?

I am pleased to announce that Caché and Ensemble 2017.1 Release Candidate versions are now available for all platforms.

We appreciate the many customers who have downloaded, tried it, and given us feedback over the past few months.

Some things not in the original field test that you may want to check out include:

• Ubuntu is now a full production platform.
• OpenID Connect now supports JWKS with OpenID Connect Discovery and OpenID Connect Dynamic Client Registration.

There have been over 300 additions and corrections since the beginning of Field Test.

I have one Ensemble EnsLib.File.OutboundAdapter which has several methods, each writing a different file. In my Ensemble Production I have configured this FileAdapter to write to a certain directory, but i'd rather have each method write to a different (sub)directory instead of writing all files to the same directory. How can I achieve that without splitting the methods into different business operations?

The current code just sets the filename and the output:

set tSC = ..Adapter.PutString(filename,output)

I have a business operation in an ensemble production to which I can send a test message which requires a date input. However, I can not seem to find out how I write the date in the test message. 1980-01-01, 01-01-1980, 50000 (cache integer encoding). But I constantly get an error:  <ZODAT> zDateOfBirthDisplayToLogical+1^Ckey.Customer.1

Hi,

I am trying the following command in order to freeze the instance before backup is done:

    csession CACHE -U%SYS "##Class(Backup.General).ExternalFreeze()"

The command requires user name and password to be supplied when prompted. Is there any way that this command can be run where it doesn't query the credentials? I am wondering if it can use OS level permissions (root or effective user who owns Cache processes etc) .

My test is on a CentOS 6 machine if that helps. 

Thanks,

Raghu

Please Give a simple program for how to export data to Xls format in Cache Objects.

Hopefully this is a simple questions to respond to.  Can you do Delegated Authentication for SOAP web service calls.  I ask as I am not seeing this work as expected.  I have this authentication turned on and enabled in for he CSP Web Application yet I keep getting a "Security Token could not be Authenticated.  And a global I was setting to capture some of the available data is not being loaded.

I use the HS_IHE_ATNA_Repository.Aggregation table a lot.  Someone just referred me to the HS_IHE_ATNA_Repository.Document table, which has an AggregationId column.  

I assume that column references the ID column in the .Aggregation table.  If so, does this mean that if the same document was requested 1,000 times that there will be 1,000 entries for it in the .Document table?  This seems inefficient to me.  Why not have one record in the document table and have a DocumentId column in the Aggregation table?

Just curious...

I work for an HIE and it just feels like I'm on an island most of the time.

I mean, there's not even a tag here for HIE or Information Exchange :)

Hi,

First of all, do Cache instance and databases have UUIDs? If so, is there a simple way to obtain these from command line? 

Thanks,

Raghu

I have a property, Emails, that needs to contain a list of comma-delimited values, or "". Is there a benefit to making this property a list of %String, a Collection[list] (or however you do it), an array, or anything other than a simple %String type?

I just  need to store some values, and return these values in SQL -- so it needs to be SQL compatible.  I don't need to index the values or use individual values in the SQL statement (e.g. Select * from table where emails [ "email@co.com"  -- I don't need to do this, although maybe this would work anyway if it's of type %String).

Hi, is possible rewind results of %SQL.StatementResult?

I not find a solution.

Hi,

I have Healthshare/Ensemble version 2015.2.1.

I created Business Operation in my ENSDEMO namespace that will connect to an external REST endpoint to send data to this external REST Service.

I also created an http service in Home>Healthshare>Service Registry, under the Service Type: http. I entered the REST endpoint Name, Host, SSL Configuration, and URL.

In my ENSDEMO production, the Business Operation is using EnsLib.HTTP.OutboundAdpater and my custom Rest business operation class. In the Basic Settings, for HTTP Server, I entered #NameofRegistryService.

Hi!

How can I show a number of rows in a given DeepSee pivot?

Amongst the large fonts and chunky icons of Portal's pages, the Menu button in the top left corner is easily overlooked:

When clicked, it often produces the following menu:

When I remember it's there, I find the "View Console Log" option particularly handy.

I wrote "often" above because I've also noticed that the Menu contents change when I'm on a page within the Ensemble section of Portal:

Maybe the contents are context-sensitive elsewhere too and I just haven't noticed yet.