#Caché

InterSystems is pleased to announce that Caché and Ensemble 2016.2.1 are now available as maintenance releases.

For a complete list of the corrections in 2016.2.1, please review the release notes.

Caché and Ensemble 2016.2.1 are available for the same platforms as 2016.2.0.  The complete set of supported platforms, including specific point releases and patches, is detailed in the Supported Platforms document.

The HealthShare team will announce availability of its products separately.

The build corresponding to this release is 2016.2.1.803.0

I try to run the cmd command in the studio terminal, but i am getting the <NOTOPEN> Error.

Even ZF(-1) also not working. Any help, Please!!!

Note: i restart the Cache instance service with full privilege

Code:

Set Path="mkdir E:\Sample\New"

Open Path:"QR":10

Error:<NOTOPEN>

This command working on my PC, but on server throws error.

Many Thanks

Hello,

I'm sending http request through %Net.HttpRequest and I have html page in response. Is there any built-in tool for beautify html for printing in terminal?
Thanks.

Can somebody explain this behaviour of Cache (and many other calculating machine as well) :

WRITE 1/3*12

4

WRITE 1/3*5

1.666666666666666667

W 1/3*18

5.999999999999999999

W 1/3*21

6.999999999999999999

W 1/3*24

7.999999999999999999

How can we make more occurate caculations in Cache ?

Hi All,

     How to create a .xlsx or .xls (Activate.Excel ) file using cache.

Thanks, Sansa.S

There is an interesting discussion in the Russian forum going. 

What is the best solution for the function which returns the max for the set of parameters?

From the listed solutions I like this one:

ClassMethod max(args...) {
  for i=1:1:args {  s max(+$g(args(i))) = i }
  s i="", max=$o(max(i),-1, i) Q $lb(max, i)
}

A group of students at the Chalmers University of Technology (Gothenburg, Sweden) tried different approaches to automatically rating the quality of emergency calls, including iKnow.

Excerpt: "The most impressive results produced by iKnow is its ability to correctly classify 100% of the calls using the Average algorithm. This is quite surprising since iKnow only compares low-level concepts, how words relates to each other."

Full story: http://publications.lib.chalmers.se/records/fulltext/244534/244534.pdf

Hi,

I'm working on a project that integrates the Subversion source control tool with Intersystems Cache Studio. I realize that Atelier has come out with 2016.2 developer edition which has built-in support for source-control, but it needs Cache version 2016.2. We don't work on that as yet. My question is simple. I've built a menu, interfaced with Subversion, validated my globals, and built a fully functioning source control system. However, I need to authenticate the user before every commit to the master repository.

Hello Everyone.

Sorry if it is a dumb question, but I'm new.

First: I have to create a Excel MultipleSheet Report. That I'm fine with doing.. but they want me to give every Workbook that is created it's unique reportName, that is generated with the user input on the page. Is it possible to do so?

Second: I saw when creating the report. Everything is placed in it's own column. Is it possible to have some of the values next to each other and some Beneath each other.

I am using OAuth2 Cache framework, acting as a client to an authorization server. My setup is based on this excellent previous post [Caché Open Authorization Framework (OAuth 2.0) implementation – part 1].

I'm facing ‘Authorization Server Error: Error Processing Response - No match between server name 'googleapis.com' and SSL certificate values google.com…’

It looks like I should set SSLCheckServerIdentity to false but I can’t figure out how. Has anyone had the same issue?

Hey guys

We have a need to mount remote databases using ECP, but with the Application servers mounting some of the remote databases as Read Only.  The Data servers will keep them R+W as normal.

From what I can gather this isn't possible using a "Mount Read Only" option, it looks like ECP just inherits the Database servers settings.  My reading seems to require roles/access/permissions to enforce Read Only on these remote mounts.  Does anyone have an easy guide/cheat sheet to set up read only ECP Application server read-only mounting using roles/permissions?

Has anyone ever used the LogoutAll method in the %CSP.Session class successfully? I'm wondering what I need to do to use it.

Thanks,

Laura

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.

1. 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.
2. 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.
3. This Python will not be installed into the protected area.  Mac does not want you messing with its Python.
4. 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

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>

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.

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.

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

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.com/deltanji

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>?