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.

This post is the direct result of working with an InterSystems customer who came to me with the following problem:

SELECT COUNT(*) FROM MyCustomTable

Takes 0.005 seconds, total 2300 rows.  However:

SELECT * FROM MyCustomTable

Took minutes.  The reason for this is subtle and interesting enough for me to write a post about.  This post is lengthy, but if you scroll to the bottom I'll write a quick summary, so if you've gotten this far and think you've already read enough, scroll to the end to get the main point.  Check for the sentence in bold.

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.

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.

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.

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.

What are we missing?

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:

• being logged on as a domain admin, run Local Group Policy Editor (gpedit.

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,

This article explains how Atelier helps you to improve software development productivity. One of the Ensemble features is the VDoc infrastructure. When someone develops HL7 v2.* production, She/ He is in a luxurious situation because Ensemble comes with a HL7 Schema editor. On the other hand this is not the case with XML VDocs. But with some effort you can turn Atelier to a handy XSD editor and close the gap.

Please follow the step-by-step guide to complete the job.

Before you read

Please make sure that you have

n  Ensemble 2016.

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

It has been noticed that some customers running JAVA programs (for example, FOP) on AIX would see the server eventually running low then out of memory. Customer would notice the system pages heavily and user experience becomes bad. And the server would crash when out of memory.

When the problem happens, we can see in ipcs a lot of shared memory segment marked for deletion (Capital D at the beginning of MODE section). This means they will not disappear until the last process attached to the segment detaches it.

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 :

      $("#Table-Alert-ID").val($("#Table-Alert-Alert option:selected").val())
      $("#Table-Alert-Text").val($("#Table-Alert-Alert option:selected").

We at George James Software recently released a new version of Deltanji, the native source code management tool for Caché, Ensemble and HealthShare.

Version 6.1 includes several enhancements, including easy creation of labels. Bulk transfer of large codesets is also now available from the browser UI.

A perpetually free "install and go" Solo Edition of Deltanji is available. Licenses can be purchased for other editions that provide more advanced code management and deployment features.

Deltanji is compatible with Atelier. It can also manage external files.

Please visit http://georgejames.

Hello,

I'm a beginner in HealthShare, and I start to develop with caché some dataflow.

Some of my business process exist in java code.

Is-it possible to call these packages from caché classes ?

If it is, how can I do it in Caché classe ?

Thanx

I had default csp application: /csp/<namespace>  for a namespace.

Later I created another application: /csp2/<namespace>  and  made it default.

Yet all namespace-specific (Ensemble, DeepSee, SQL, etc.) links in management portal still point to/csp/<namespace>.

Is there any way to make the links in management portal point to /csp2/<namespace>?