Announcements

Hi,

We recently updated Ensemble, on our Unix DEV server , from version 2013.x to 2015.2.3 (Build 855U) and when we test our SSL/TLS configuration we get the following error:

ERROR #729: Certificate /qmd/ens_chldev_1/mgr/SILCert/SILCSSSJR-CER.cer is not valid for TLS Web client authentication .

The certificate was working fine before the update in DEV and it is working fine in our PROD Unix server with Ensemble 2012.x.  Any ideas why we are getting this error

Last answer 15 June 2016 Last comment 15 June 2016
+ 1   0 2
685

views

+ 1

rating

Hi All,

I've created a sample implementation of the MQTT protocol, which is now available on GitHub

The project demonstrates MQTT client capabilities and it's written in Caché Object Script.

 

Any comments, bug reports are welcome! Some more enhancements (like SSL / TLS support) are planned for the near future.

+ 4   0 1
0

comments

312

views

+ 4

rating

Introduction

The field test of Caché 2016.2 has been available for quite some time and I would like to focus on one of the substantial features that is new in this version: the document data model. This model is a natural addition to the multiple ways we support for handling data including Objects, Tables and Multidimensional arrays. It makes the platform more flexible and suitable for even more use cases.

Last comment 15 June 2016
+ 13   0 11
1798

views

+ 13

rating

Hello!

Are there any short ways of serializing COS entity to the string? I am searching for something like .$toJSON() , but I need Caché 2013.* support.

The one way I supposed to work is to use $listbuild:

 

set str = $LISTTOSTRING($LB(1,2,3,",",5))
set list = $LISTFROMSTRING(str,",")
zw list
list=$lb("1","2","3","","","5")

 

But the problem is that $listbuild does not escape delimiters, and it is not possible to deserialize serialized string. The structure I need to serialize may contain any characters.

Are there any short ways to do this in Caché to avoid writing custom parser?

Last answer 13 June 2016 Last comment 14 June 2016
+ 1   0 3
1509

views

+ 1

rating

I need to pass multiple values to a FILTER to a DeepSee DASHBOARD via the URL. The documentation seems to indicate this can be done, i.e.: "Where each filterspec is filter_name.filter_values" but there are no examples I can find that indicates what is used to separate multiple values. Say I want to pass the three values 5, 6, and 1395 to a filter. To pass just the 5 I know this works:

&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5

but how do I include 6 and 1395. None of the following seem to work:

&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5.6.1395

&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5,6,1395

What is the proper syntax?

 

Thanks.

Last answer 13 June 2016 Last comment 13 June 2016
+ 1   0 1
201

views

+ 1

rating

this is catching  me all the time, again and again...

Haven't worked with XML VDOC for some time, I can't figure out, what is the correct way of using Property path. Can someone please help me to refresh my memory.

Simple example: I have a class called Body, with Value and Topic properties. I created a XML Schema for this class and imported it into Ensemble. So i have a category called message, with Body as DocType structure and Name and Topic properties of Body complex type ($2:Value and $2:Topic are element names)

My rule looks this way:

However, the rule is ALWAYS evaluated as TRUE. but TRACE element shows null value for "value". 

 

I  also did a programming test using this code

Last answer 13 June 2016 Last comment 13 June 2016
0   0 0
498

views

0

rating

When using the "XML Cache Script" export via the Export context menu option (right clicking on a class in the Atelier Explorer View) sometimes the export dialog is empty.

Other times it is pre-filled with the project selected and the individual class chosen as expected. When it is blank you can choose the project but within the list of all classes there is no package hierarchy making it difficult to find your class.

Anyone know why sometimes you get the empty selection and sometimes you don't? I've tried to reproduce it at will but can't pick up a pattern. And is there plans to include package hierarchy in the selection box?

Last answer 12 June 2016 Last comment 13 June 2016
+ 1   0 1
162

views

+ 1

rating

Order is a necessity for everyone, but not everyone understands it in the same way
(Fausto Cercignani)

Disclaimer: This article uses Russian language and Cyrillic alphabet as examples, but is relevant for anyone who uses Caché in a non-English locale.
Please note that this article refers mostly to NLS collations, which are different than SQL collations. SQL collations (such as SQLUPPER, SQLSTRING, EXACT which means no collation, TRUNCATE, etc.) are actual functions that are explicitly applied to some values, and whose results are sometimes explicitly stored in the global subscripts. When stored in subscripts, these values would naturally follow the NLS collation in effect (“SQL and NLS Collations”).

Last comment 10 June 2016
+ 9   0 0
1586

views

+ 9

rating

I've been in IT since 1986.

I started with Pr1me INFORMATION and Primos on Pr1me hardware.

In the 90s and 00s, I used D3.

I'm giving Caché a try, but I'm kinda having some difficulty getting started.

I've installed Caché on a 64-bit Windows 7 workstation. It was installed under an administrator's account. From a standard users account, I'm trying to access the Management Portal at:

http://localhost:57772/csp/sys/UtilHome.csp

It is prompting me for credentials. Which ones do I use? I've tried several, but nothing is working.

In going through the MultiValue Quick Start Tutorial, but I'm not getting very far.

Any ideas on what I need to do?

Last answer 9 June 2016 Last comment 9 June 2016
0   0 1
218

views

0

rating

In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.

How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?

I tried many things including this:
AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&[190001],[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])

But I don't get the right result because the date in abscissa creates a filter on the first date.

I tried also with %MDX function, but then I loose the context for the CURRENTMEMBER.

Last answer 8 June 2016 Last comment 8 June 2016
+ 1   0 1
450

views

+ 1

rating

I am having a problem when using atelier on my instance, which I just synched from perforce on latest and then did a built

I am getting the error
ERROR #5880: Unable to create source control class: %Studio.SourceControl.ISC [zSourceControlCreate+17^%Studio.SourceControl.Interface.1:%SYS]

every time I want to open any class or routine from %SYS namespace in the Server tab.

Did someone had the same issue?

Mario

Last answer 8 June 2016 Last comment 8 June 2016
+ 2   0 1
231

views

+ 2

rating

Hello,

We are sometimes asked for examples of how to do 3rd party SQL database selects/updates/inserts/stored procedures from an Ensemble SQL Business Operation.

In the attached file there are 4 sample Ensemble Operations that demonstrate four different types of transactions with an external SQL DB:

1:  The "CheckExists" shows how to use an Operation to do a select statement to see if a given patient MRN exists in a DB
2:  The ExecSP Operation shows how to execute a stored procedure from a BO
3:  the Update Operation does an Update
4:  the Insert Operation does an Insert

Given the samples, one can combine updates/inserts/SPs/selects into a single operation as needed.

 

ensemble_sql_operation_examples_0.zip

Last comment 8 June 2016
+ 5   0 4
1011

views

+ 5

rating

We have noticed that when compiling with Atelier (either Atelier itself or sending the code through the REST interface) that the build will fail if all brackets '() {} []' are not closed. This includes brackets opened in comments.

 

For example, this will fail:

class myclass

{

//if someVar {

}

 

I do not know if this issue has been fixed or if this issue has been brought up, but it has been a nuisance over here.

Last answer 7 June 2016
+ 1   0 1
0

comments

197

views

+ 1

rating

Mirroring provides an admin capability to Stop Mirroring on this member, which causes a non-primary member to temporarily disconnect from the primary, stop dejournaling, etc.  While most system administrators may never need or use this function, some employ it for certain kinds of maintenance or other special cases.

The intent is that the administrator uses the Start Mirroring function when they wish the member to reconnect. However, today mirroring also implicitly restarts (reconnects) if the Caché instance restarts. Since this can be unintentional, we intend to change the Stop Mirroring function to persist across instance restarts. This has been requested by some customers. This change is also quite consistent with current documentation, so it might come as a surprise to some of you that it doesn't already work that way

Last answer 7 June 2016 Last comment 7 June 2016
+ 2   0 2
209

views

+ 2

rating

Hello!

I have a WebSocket application which spawns new process using JOB command.

Sometimes WebSocket connection can be terminated, and in the meantime I need to hold spawned process alive until it can be associated with the new WebSocket connection. (Do not suggest serializing process state here instead please)

Technically, in Caché WebSocket connection is represented by the class, which executes in its own process. This process is terminated when the connection is lost. In this case the JOBbed process does not terminates (thanks Edward), but it rely on $ZPARENT variable.

Is it possible to hold JOBbed process alive for a while? If yes, how to change $zparent variable of the spawned process when the new "parent" process will be ready?

Thank you.

Last answer 6 June 2016 Last comment 7 June 2016
0   0 2
174

views

0

rating

On June 7th we'll be releasing two new views of content that will allow you to rapidly see what's new on the site as well as identify content that has gone unanswered. The next step for this (after this release) will be to add in personalization so that you can filter content based on your tag and member "following" preferences.

Last comment 7 June 2016
+ 1   0 2
204

views

+ 1

rating

Sentiment Analysis is a thriving research area in the broader context of big data, with many small as well as large vendors offering solutions extracting sentiment scores from free text. As sentiment is highly dependent on the subject a piece of text is about (financial news vs tweets about the latest computer game), most of these solutions are targeted at specific markets and/or focus on a given type of source data, such as social media content. Also, given that the vocabulary used to express sentiment evolves over time, especially on social media with younger or mixed audiences, sentiment analysis software often needs to be updated or re-trained to stay up-to-date

+ 5   0 2
0

comments

401

views

+ 5

rating

Hello,

Why I don't see the full content of a XML file inside a Ens.StreamContainer Message?

When  I look into the content I only see:

<?xml version="1.0" ?><!-- type: Ens.StreamContainer  id: 5 -->
<StreamContainer><OriginalFilename>C:\Temp\In\aa.xml</OriginalFilename><Stream></Stream><Type>FC</Type></StreamContainer>

How I can see all the content? There is any setting to modify this behavior?

I am using a EnsLib.File.PassthroughService,

Regards

Last answer 7 June 2016
0   0 2
0

comments

542

views

0

rating

Hi, Community!

Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest.

One of the tasks for the final was to solve T9 Spelling problem  with Caché ObjectScript and use the minimum code.

Last answer 1 June 2016 Last comment 6 June 2016
+ 3   0 1
650

views

+ 3

rating