I've released a comprehensive, free online training course on the new EWD 3 suite of products that allow the integration of Cache with the burgeoning Node.js world, and allow you to create and run browser-based and mobile applications with all the very latest development technologies from the JavaScript world.

The training course consists of presentation slide decks that you can go through at your own pace and in your own time.  It takes you step by step through all aspects of the EWD 3 technologies, in particular the ewd-xpress platform, showing you how to create applications.  It includes loa

Why we are not using database of join (inner join and outer join) concept. How to we are retrieving the data from different tables in cache. Any Concepts are using in Cache database to retrieve the data.

This short article was motivated by a problem of one of my customers. They use Ensemble to integrate many systems, some of them use just plain files.

So they naturally selected File Outbound Adapter to write into target file. Things were running smoothly for years, until recently, when the volume of data being written to the file reached large size of tens of megabytes. The operation took around half an hour to complete, causing timing problems where subsequent operations within the process had to wait, and third party system was not happy to wait so long.

The customer's code looked somehow

Hi ,

We upgraded cache 5.02 to cache 16.In this version it is having problem with "$$$" macros.

These are the error's eating my time. i tried to figure it out but there is no exact solution .

MPP5610 : Referenced macro not defined: 'CSPSessionTimeout'
MPP5610 : Referenced macro not defined: 'CacheError'

I checked the check list also "These macros will be the only ones displayed by StudioAssist when the sequence, “$$$”, is recognized during program input. The full set of macros and their definition can be displayed via the $SYSTEM.OBJ.ShowMacros method"

there is no definition for this(CSPSe

Wir suchen für ein Unternehmen unserer Firmengruppe

eine/n ERP System Developer / Programmierer/ Software Entwickler

Unser Partnerunternehmen ist ein international agierendes Handelsunternehmen mit Sitz in der Nähe von Wien.

Der zukunftsorientierte IT Bereich entwickelt intelligente innovative Lösungen für die Vielfalt der Herausforderungen, die sich täglich stellen. Die Fülle der abwechslungsreichen Aufgaben und Projekte, sowie die Art und Weise wie zusammengearbeitet wird, bietet hervorragende Wachstums- und Entwicklungschancen.

Für die Entwicklung und ständige Weiterentwicklung der Softwarelösu

NewBie's Corner Session 25 Globals, Variables, and Arrays Part 1

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

Globals, Arrays, and Variables

A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.

A Global may be:

Scalar (a single element), as in a Global Variable

Example of Global Variables

Set ^PERSON = "DAVID – DATA ABOUT DAVID"

Set ^PERSON2 = "MICHAEL – DATA ABOUT MICHAEL"

Aggregate (many elements), as in a Global Array. An Array combines similar elements together.

Example of an Global Array

Set ^PEOPLE("DAVID")="DA

Hi All,

      While upgrade cache 5.02 to cache 16.

     $$$CacheError and $$$CacheError not support in cache 16. 
     We need solution for this?

<csp:CLASS super=%CSP.Error>

A question from Benjamin Linden:

We are looking to upgrade the hardware for our server.

Do we need to buy a new Caché license? Or can we keep using the one we have?
 

Dear Colleagues,

Recently I am working on a Cache project should enable the customer, to update our Cache application independently from us. Our idea is a client (preferred .net) application that will copy all the necessary Cache stuff (classes, routines) into a cache database. For this, we are looking for the appropriate technology – in old times this would be a CacheDirect.

Our question: considering up-to-date technologies there seems to be a bootstrap problem: How could one add classes and/or routines to an empty Cache database without using Cache administration tools like the system manageme

If a user simply closes a tab (running a web application), is there any good way to ensure that the license is released AND the login cookie is destroyed?  

I found that if the tab is simply closed without first logging out of the application, then 1) the license hangs around forever, and 2) if the user then opens a tab, he is already logged in.

For #2, I understand that there might be some grace period to allow the user to log in automatically again using the same session Id (where is that documentation again?) but what about destroying the license?  Who/what is supposed to clean that up?

Than

EnsPlus, the Caché Objectscript plugin for Visual Studio, has now been upgraded to support all versions of Visual Studio 2015, including the free Community edition.

http://www.ensplus.com

Take this course to learn how to use additional features of data transformations beyond creating a simple data transformation. 

Hello, guys.

Is there a way to get all object properties, parameters and so on and put it inside a string. I know that I can use 

zw obj, but this does not work if I want to put it inside a string.

Hi

I do not really have much information yet about an upcoming mission but i know it is about to seal a flatfile and then send it further. I think  SHA256 HMAC will be used. There is a fixed sealkey to be used each time. Does anyone know if the Ensemble supports this ? I have looked in the documentation but not really found anything .

Regards,

Michael Lundberg

UPDATE: Found a reason in my code why this could be occurring. Still it would be interesting to hear what people come back with.

Consider the following MERGE statement.

 M ^WORKDELETED(DAYNUM,WKS,ACC,$H,%logname)=^WORK(DAYNUM,WKS,ACC)

Produces output

^WORKDELETED(64165,366,16090404088,"64165,34201","user001")="SOME DATA"
^WORKDELETED(64165,366,16090404088,"64165,34201","user001",0,"LOG")="64163*11:05*user001*64163,39919*~"
<other sub-level nodes omitted>

^WORKDELETED(64165,366,16090404088,"64165,34202","user001")="SOME DATA"
^WORKDELETED(64165,366,16090404088,"64165,34202","user001,0,"LOG")="64163*11:

I have an application developed in Zen mode. How do I "package" and create an application to run on Android. How do I create the apk file?
Thank you

I want to create a simple Json extract from a database in Cache. Suggestions as to classes, method, etc. are most welcome.

Is there any update on when the RSS feed will be fixed to finally include a Title field. This was reported about 5 months ago. Specifically:

The RSS feed for groups (or communities as the link currently says) does not include a title, e.g. for:

https://community.intersystems.com/group/8081/feed

Starts with:

    <title></title>
    <link>https://community.intersystems.com/group/8081</link>
    <description></description>

So there is no title or description of this feed. Also is there a feed for all content posted to this site, so not filtered by tag/group at all?

Hi ,

we need to upgrade the Cache 5.02 to cache 16 in windows server 12. How to upgrade cache 16 in same cube of cache 5.02.

note:we need to upgrade existing cache 5.02 not new instance.

Thanks, sanasa.

I have found this one line command from the Terminal is the quickest way to backup my routines.

In the Namespace the routines reside:

w $SYSTEM.OBJ.Export("MYRTNS*.MAC","C:\Users\Username\Desktop\MYRTNS.BCK-9-2-2016-8AM")

I was recently troubleshooting a problem on a Linux (RHEL) instance of 2016.1 at a site. For policy reasons their sysadmins wanted to update the Caché installation so it used network accounts for its cacheusr and iscagent users and groups instead of the locally-created ones that had been set up during original install of Caché.

To do this they ran various commands including chown

Afterwards non-root users couldn't obtain a terminal session using the csession command. Instead they receive this message:

cache: Permission denied

It turned out that the chown command cleared important setuid and setgid

Hi All, How to get the only folders (with sub-folder)from the particular drive using cache. We need to create the only folders from some drive using Cache.

Good morning, I have a ZEN application being served up through a CSPGateWay. That ZEN application is made up of two ZEN pages. One ZEN page uses a zenLink to call the other ZEN page(see below #1). The ZEN page that is called contains a tab group with one tab. That tab contains a tif image. I have components on the called ZEN page that execute JavaScript to perform simple image manipulations - zoom and rotate(see below #2). Those simple image manipulations have stopped working. If I load the called ZEN page directly AND use a fully qualified domain name, the simple image manipulations work! Usi

Hi - Trapping onselect and onchange events that occur on layout objects seems to work fine, however, according to the documentation, I should also be able to use onevent, which is defined as follows:

onevent: Defines how the page behaves when another type of event occurs within a documentView (an event other than select or change).

and has the method signature:

ClientMethod onevent(eventType, key, value, docViewId) [ Language = javascript ]

I would have expected that, therefore, on events other than onselect and onchange (for example onkeydown, or onkeyup), this method should be called wit

I've noticed that Management portal somehow manages to allow a single user to be in different namespaces in different tabs in the same application (i.e. Management Portal).  I've looked at my Processes, however, and see that all of my processes using MgmtPortal think I'm in %SYS, even though 2 of them are looking at globals in two different namespaces; NamespaceA and NamespaceB.  

I can even fool MgmtPortal because the first time I try to look at a global in NamespaceA it thinks I'm in %SYS!  After a refresh, however, I can see the global in NamespaceA.  

How does MgmtPortal do this?  

I fire a call of COS method through Java gateway and get the return value whose type is %Status in COS. What is the corresponding class for %Status in Java side? Any existing utility to help me parse this object so I could know this COS call finish with errors or not.

NewBie's Corner Session 20 Parameters and Status Part I

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

Parameters

Parameters are another name for Variables when used in passing data from one Routine to another.

Let us say we have 2 routines (RtnA and RtnB), and we want to pass 3 parameters (Parm1, Parm2, Parm3) from RtnA to RtnB.

RtnA would look like:

RtnA

                Set Parm1 = "Value for Parm1"

                Set Parm2 = "Value for Parm2"

                Set Parm3 = "Value for Parm3"

                Do ^RtnB(Parm1, Parm2, Parm3)               ; Actual Call L

Hi All,

We are doing capacity planning. I want to track the number of rows and size of each table (or at least the top ~10). Any ideas?

Thanks

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

MUMPS verses Caché, what's the difference?

MUMPS was developed at Massachusetts General Hospital during the 1960s. Through a series of experiences and companies over the years eventually MUMPS evolved into Caché. Some deny this but the facts are there. You can read through the various websites with Wikipedia and make up your own mind. The closest way to explain this is that Caché is a superset of MUMPS.

MUMPS is both a programming language and a hierarchical database, that is important to remember.

It is the datab