I've seen a few reports of issues for Mac users where every relaunch of Atelier throws errors related to Secure Storage . Trying to save a server connection displays the error:

 Secure storage may be corrupted: see Help section on troubleshooting.

The server connection also has a red X with a corresponding message in the Error Log:

Secure storage was unable to retrieve the master password from the OS keyring. Make sure that this application has access to the OS keyring. If the error persists, the password recovery feature could be used, or secure storage can be deleted and re-created.

We just faced an issue of the Atelier main menubar being disabled (greyed out) after upgrading the macOS development machine to High Sierra. I would like to share my findings about the issue and how to fix it.

This seems to be a known problem affecting several Java applications including Eclipse if the macOS user's primary language is not English: https://www.eclipse.org/org/press-release/20170925criticalbug.

I'm simply trying to evaluate what is available in terms of JSON projection of registered objects within Caché.

If you have an app that uses some Caché client Windows components that are not included into CacheODBC distribution (e.g. CacheActiveX.dll), you need to proceed Caché client installation on end user's client computers and/or MS Terminal Servers. Being a part of Caché client's installation, Caché Cube is installed along with other components and is autostarted with every user's session. So, it becomes visible to every user.

To make it completely invisible, you can just move CACHE.

Is there any Test Driven Development tool for Cache for the web development. If so can any one help me on this.

Thanks in advance.

One of the most important features during application development is the ability to debug your code easily. Because of the asynchrnous nature, a standard Node.js application server works single-threaded by default. When you are developing applications using an IDE like Visual Studio Code, you can very easily debug your Node.js process:

First, download the free Visual Studio Code IDE (@code) and install it on your development machine.

We will start with basic debugging using a very small test.

Hi, Community!

How can I manage to show in MDX query months where every month shows the value of the last month?

Say, in HoleFoods the query:

SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]

will show me the sum of revenue per month.

This query:

SELECT NON EMPTY [Measures].[Amount Sold].MAX ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]

will show the Max revenue in a day for the given month.

But what MDX will show the months with the revenue for the last day in a month?

 how to set some specific value for the variable if the user enter that specific value then only it will go to next step  

When i tried to print .txt format,data will be coming without space between each row but when 
I tried to print .xls format mean ,it gives gap of each row.what is the reason behind this?

Hi, Community!

It's October and we have new DC release here. What's new?

1. InterSystems Single Sign-On for Global Masters

As you maybe heard about InterSystems Global Masters (GM) program. With this release, we introduced InterSystems SSO support for GM. So now everyone who has active WRC account can join GlobalMasters and no special invitation needed. You are welcome! 
How it works:

You can use your previous credentials as well. And you can get the invite also - just comment here or in this post.

2.

Hi, Community!

I'm pleased to announce that we deployed a new release of Developer Community.

With this release we introduce:

1. New post type is introduced: Announcement

Choose Announcement as a post type if you want to say about a new product or feature release, about some new services in your company, if it is event announcement or there is a new job position open in your company.

E.g. here is an announcement, this is another example of event announcement and this very post is an announcement too.

Announcement post has "loudspeaker" sign in the post feed. See the examples:

2.

Hi world, i work on my business process and i meet a problem:

i want to send mail alert to the patient  when he misses  take  his temperature measure

in the method for checking if the measure is missed or no , i want to integrate my code wich allows me to trig an alert an send a mail reminder to the patient .

Do you have any idea how doing it .

thank's

How to show alert message on ZEN when user closing window?

Standart js way to add listener is not working.

I tried this

 ClientMethod onloadHandler() [ Language = javascript ]
{

zenPage.window.addEventListener('onbeforeunload', function(e){
   
        return 'Are you sure you want to leave?';
});
    
}

and this, but both are unsuccessfully .

 ClientMethod onloadHandler() [ Language = javascript ]
{
    
    
   zenPage.window.onbeforeunload = zenPage.myClientMethod;
}

Hi All,

    I need some clarification on web service (Soap Service). For each Soap request, system consuming 1 license and it is not releasing until CSP session timeout and extra grace period 5.10 minutes(310 seconds).
    Due to this, at some time license consumption is full.
    If i use with Login credential (i.e password authenticated web service), it consumes one license for 25 connections(request).
    But i need to use it as anonymous user(Unauthenticated).
    Please advice.

Thanks,
Sabarinathan M

Hi, Community! 

This week we have two videos. Check all new  session recordings from Global Summit 2017:

 1. Containers for InterSystems Technologies

Hi, Community Members!

The goal why we are posting questions on Developer Community is to get the answer.

Here is very simple guidelines document on how to ask questions which would get answers.

When you post a question you need to feel 3 fields: title, body, and group. And tags.

1. The Title

A good title should contain the brief description of your problem - it should not be longer than 80-90 symbols.

But brief doesn't mean one word. These are not very good titles for questions: Cache, Ensemble, Peace, World.

Hi,

We are having a problem where sometimes a websocket connection started from a CSP page does not share the same SessionId as the CSP page itself. We are also using ECP and can see that both sessions are often even on different application servers.

Trying to connect Ensemble to RabbitMQ following this article I'm using Java Gateway and encountered the following problem - in all my calls I need to pass connection object, which is always the same but it takes a long time to create. Here's java code:

package com.myorgname.rabbitmq;

import com.rabbitmq.client.ConnectionFactory;
import com.rabbitmq.client.Connection;
import com.rabbitmq.client.Channel;
import com.rabbitmq.client.

When server-side source control such as Deltanji is being used with Atelier we sometimes want to re-sync the local Atelier copy of a class or routine by pulling the copy from the server.

Hello!
We want an Integration that should be moving files from a FTP server in a DMZ zone into another FTP server on our local network.
I tried using EnsLib.FTP.PassthroughService(EnsLib.FTP.InboundAdapter, EnsLib.FTP.OutboundAdapter)
Using this approach ensamble write data to the database, causing the CACHE.DAT to grow for every file that is moved.
Looks like the entire file is written to the database, is this the case?
We are not really interested in storing any file content information in ensamble in this particular case.

I have a class that has a list property, which contains a list of other objects, and I want to join against it in SQL.

Class Foo Extends %Persistent
{
Property MyBars As list Of Bar;
}

Class Bar Extends %Persistent { Property Name As %String; }

Simply querying the Foo table, I see that MyBars looks like a $LIST, so I tried using a query with the %inlist operator but that didn't seem to work as expected. The following query produces zero results:

select bar.name from foo join bar on bar.id %INLIST MyBars

Is there some convenient way to do this sort of join?

I have implemented a csv record mapper to read files into the production in ensemble but it errors every time I read a file with headers on the columns as these are not recognised as the specified data types .Is there a way to ignore the headers when reading in values from a file with headers. Please note this have been built using the pre built components.

Hello,

we have to implement some application logic using either Java or .NET. Which should we choose? Given that all other considerations are equal, which is in your experience better way performance-wise to interact with external components in Caché: .NET Gateway or Java Gateway?

Thanks.

Hi

Reading through the installation guide I found a fairly stern warning in the robustness checklist not to use the inbuilt apache web server.

>Use a robust web server. Do not use the limited Apache server installed with
>Ensemble. It is provided as a convenience for use on development systems and
> is not a fully capable web server.

We only have a few users, the Interface team (3), an integration consultant(1) and an interface monitoring/development vendor.

Do we need a 'robust web server' for using HealthShare Health Connect Integration engine?

Hi

Please can someone send me an example of how to auto refresh a table pane. 

Thanks

Nigel

Hi-

I have an IP address (or hostname) and a port (in this case a super server port #) and I want to try to verify that network communications can be established between the host I'm on and the given hostname and port number of a remote server.

Is there any way pragmatically to do this within Cache?

Hi

We have a need in our Ensemble production to take HL7 ver 2.3 and provide an XML representation of it to provide to non-HL7 consumers.

What would be the prefereed way to do it.

Are there are pre-defined XML schemas in Ensemble that could be use ?


We are currently on Ensemble 2015.2

When I create a project and pull in files from the server, certain files (BPLs and DTLs) aren't synchronized, and when I try to sync them (without making any changes) I get a Resolve Version Conflict screen, with differences between the local copy and server copy. Sometimes the Parameters are in different places,  or the Storage will be on top of one and on the bottom of the other, and sometimes the server copy will flat out have lines that aren't in the local copy at all.

I am trying connect DB using Oracle DB link (ODBC).  I am getting the following error. Please help me fixing this error.

I am using Oracle 12 c.

Thanks,

Raj

Hi, Community!

This post is a digest of the Developer Community postings in September 2017.

Most viewed

DeclarativeCOS — Declarative Programming in Caché  503

New Programming Language - Discussion  318

InterSystems IRIS Data Platform  253

? Where/How can we touch IRIS ?  207

InterSystems Global Summit 2017 Key Notes Live Stream  199

Filtering non-printable characters  188

Double dot?  172

Search InterSystems documentation using iKnow and iFind technologies  168

SPOOL - the fogotten device  167

InterSystems Cloud Manager and Containers at GS2017 XP-Lab  166

Vue.js: getting started with a basic HTML/REST/JSON example  162

Pro Tip: Controlling your SysTray Cube icon appearance   155

Widgets Direct  141

Horizontal Scalability with InterSystems IRIS  138

UnitTest : A Mocking Framework for InterSystems objectscript classes.  13