When running the built in Ensemble Purge task (Ens.Util.Tasks.Purge) there are three parameters DaysToKeep, BodiesToo, and KeepIntegrity.  This article focuses on the KeepIntegrity boolean parameter, but more information about running this task can be found here:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

KeepIntegrity determines which Ensemble Messages are marked for deletion within the time specified by DaysToKeep. 

This post is meant to provide a quick possible explanation for a very perplexing problem.

Scenario:  You’ve just created your own administrative user in your 2014.1 (or later) instance of Caché.  You gave it every possible security role (including %All), so it should in theory be able to do anything within the instance.

You’ve written a very advanced routine with a break command in it for debugging:

MyTestRoutine
            set ^MyInitGlobal = 1
            write "Hello, my name is..."
            break
            write "Steve"
            quit

Don’t use Python built into Mac.  Because of System Integrity Protection (SIP) you will not be able to access the libraries that the InterSystems Python binding requires.  The Python build into the MAC has baked in what libraries it can use.Install another Python.  Don’t put this other ahead of Mac Python on path since this could break things.  Apple regards its Python as part of the its OS, and may use that Python in its system operations.This Python will not be installed into the protected area.  Mac does not want you messing with its Python.Use explicit path to invoke this other Python.  

How can we make sure that the Cache userid passwords are encrypted on storage? We want to make sure that the Cache passwords cannot be decrypted - how can we ensure that?

The topic of reflection hasn't been raised in Caché forums or blogs too often. Perhaps, it happened because the notion of reflection is not explicitly defined in Caché. However, it exists in Caché and can be a very useful development tool.

Hi,  

In Cache Studio under the View/Find in Files.  Anyone knows how to search multiple words in the string?   For example,

In my routines 1, it has "Patient Name   Test Name    Provider    Address   Status  " and

In my routine 2 , it has "Patient Name   Test Name    Provider    Address "

In my routines 3, it has "Patient Name      Address "

 When I search, I want to search all the routines, it has the words  Provider and Status which I want it returns only routine 1 because it has both words "Provider and Status".   Thank you very much for your help.

Hi, We have been upgrading our application to ensemble 2016.1.1. I have moved my data to a particular namespace which i have created and now in management portal i have been getting an error message "namespace does not support Ensemble". Please give solutions to resolve this issue.

Thanks and regards

I implemented a WebService in edge of HeathShare but it is asking for user and password, so it isn't possible to publish.

How can I grant permission for that service?

PS. When I type the user and pass the WSDL shown is correct.

Hi, Community!

Here is the digest of Articles and Questions published on InterSystems Developer Community in October 2016.

Most viewed

Internal Structure of Caché Database Blocks, Part 1  407

Caché and Ensemble 2016.2.0 Release  306

How to execute terminal commands from a webpage  214

How to Parse a URL in Caché  196

Internal Structure of Caché Database Blocks, Part 3  191

Tips & Tricks - SQL to Excel  188

Internal Structure of Caché Database Blocks, Part 2  184

Data Platforms and Performance - Part 7 ECP for performance, scalability and availability  180

Lines of Code  147

I am looking for samples for integrating Ensemble and RabbitMQ. Any pointers appreciated.

Best,

Harish

See 

http://www.datasciencecentral.com/profiles/blogs/ten-top-nosql-databases

What will it take before Cache begins to appear on (or at the very least be considered for) such lists?

hi,

1. Created a class(test) and added a classmethod(checkdata).

2. Assigned a object with xml.

3. Created a new class for response and initialized in classmethod(checkdata). 

4. Created a new class for request parsing with list of object parameter.

5. While parsing xml in request for list of object,  the  result count is "0". But the xml has value for "2" object list.

6. XML has follow:

<Request>
    <party>
        <to name=""mohan"" address1=""India""  />
        <to  name=""sujay"" address1=""USA"  />
    </party>
</Request>

Hi, Community!

We deployed the new update on DC and it brings:

• The new post subscriptions/favorites model
• Some menu changes
• Bug fixes.

The new post subscriptions/favorites model:

with every post you now see the star in the left bottom corner of the widget in the feed or of the post.

Click on it and it turns to yellow which means that you store it in your "Favorites" tab which you can find later in your member's page like it is shown in my one.

Also, that means you automatically subscribed to email notifications on all the changes in this post.

Click it again to unfavorite/unsubscribe the article.

I used the Members option from the Community button to look up Evgeny's profile. Above the tabs ("View", "Mentions", "Posts (53)" etc) his name was displayed (correct).

Then I clicked on the "Posts (53)" tab. It showed his posts, but displayed my name above the tabs.

I create the NewBie posts.

And as directed I use the Beginner tags.

However, a lot of people are using the Beginner tags for other posts.

Is there a way for separating the NewBie posts from the other Beginners?

Failing that, can I in someway make the Newbie Index more visible?

I am doing a lot of work on the NewBie Index to make it more useful.

I have a post I have published.

Now I need to do some substantial work on it.

I cannot do it all at one time, so I save it after I do some work.

Trouble is, each time I save it, it is published and sent out in mail, which is not what I want.

How can I save a post and not get it sent out?

Is there any method or routine available to export and import the user roles and the sql table and sql procedures associated with each role?

NewBie's Corner Session 22 Parameters Part III

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Parameters

In Sessions’ 20 and 21 on Parameters we saw how to call one routine from another with parameters as well as calling one Label from another with parameters. In these examples, the data was passed through the parameters from the calling routine or label to the called routine or label.

Now suppose you wanted the called routine or label to pass data back?

There are two ways** of doing this.

1) Returning a Status through a User-Supplied Function

We are finally planning to migrate some ancient Caché applications that are run on Caché 5.0.21 to a new server with Caché 2016.2.0 or so.

I wonder if we could use Shadowing between those to keep the data on the new server up to date?

We would copy the Caché backup from the old environment to the new and do a RESTORE there and then start shadowing.

I know than 5.0.21 is no more officially supported by ISC.

Hi,

We have created a dll with .Net that generates a MS Word document with a template. The .Net method works, we have tested it with Visual Studio and it generates the document.

But once we have created the dll and embebed it in Ensemble through the Wizard, when we try to execute the method that generates the document, it doesn't work. It doesn't throw us an error, it simply doesn't open the template.

We have seen that MS Word program is opened, but that's all.

We are using Microsoft.Office.Interop to generate the Word document. It must be Word 97 version document.

After reading Stephen Wilson's article "Windows 7 performs shutdown too fast for Cache to close and so it gets forced down" I've recalled another solution that was based on Local Group Policy, which allows to control extra actions that should occur on computer startup or shutdown. How to add a computer shutdown script is well documented in MS Technet article. In short:

I'm working with a custom code in Studio and I'd like to know where a Class is being used.

The standard ctrl+f  search only in current file.

Hi-

I was wondering whether or not the Ensemble Event Log was accessible using SQL?  If so, what schema and table would that be contained in?

Thanks

Hi-

I was wondering if there was a DeepSee overview document available for a non-technical user.  Something short and concise describing what DeepSee is and its key features.

I've looked at the documentation and although there are parts of what I am looking for there it is much too technical for my needs.

Thanks

Hi - If you want to embed Ensemble's Workflow Inbox, (that offers workflow task items to workflow users) inside of your application - you can access the URL directly without necessarily giving users access to the Management Portal - but more importantly, you can strip away the Titlebar, Worklists and Borders that make up the page by default.

You do this by using the same URL parameters you would use, if embedding a regular DeepSee dashboard into your application.

For example, adding &EMBED=1 at the end of the URL as depicted below:

Hi,

I have an Ensemble DTL which is suppose to translate the inbound XML document to an outbound XML document.

I need to test if a particular XML element exists, to perform some translation.

In the DTL I have the following,

<if condition='source.{element1.element2.element3}'>

<true>

    // do something

</true>

</if>

How do you use if statement to test the source XML document to see if a particular element exists in the source doucment.

Thanks,

Explain Class(set) Operators and the `(Grave) Operator in Normal and Pattern Expressions? With Example.

Hi, Community!

This place is getting bigger and today we reached 2.000 of registered members on InterSystems Developer Community!

Recently we introduced online analytics (build on InterSystems DeepSee) of main figures regarding Developer Community. 

You can find the analytics in the menu Community->Analytics:

So you can click on the dashboards and cells and drill down to the daily posts, tags or examine the current leaderboard of the most active and helpful members.

Thanks for your participation and contribution! 

Hi All,

            I have a general query in regards to developers experience on extracting data from cache databases and the most efficient way to do so. I work with a number of clients who have applications with cache databases and require the data off the host system and onto data warehouse platforms for research and analysis. Often they require the data in source state which means the extracts are often simply a table scan of the entire database table without any aggregation or manipulation.

Hi All

When using a select :

  {type:'$input',id:'Table-Alert-Alert', key:'Table-Alert-Alert', inputType:'select', children: [
              { type: '$loop', value: '=[AlertTList]',children: [
              {type:'$option', value:'=[id]', selected: '=[selected]', $content: '=[AlertText]'}
              ]}
         ]},
I can get only value & text of the selected object :