#Caché

30 Followers · 4.5K Posts

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Edit
Question Soujanya Naganuri · Jun 20, 2017

In Oracle sql Developer, you can still listing the records in a desk the use of the statistics tab when viewing a desk. there where can add, delete, edit or just viewing facts of desk currently viewd

the trouble is that we regularly actually need to view a couple of table immediately, then we want more than one tab opened, issue that i dont recognise how to do that, any sugestion. tq earlier

0
0 30
Edit
Article Gevorg Arutiunian · Jul 17, 2018 1m read

The following code snippet contains a class method "test" that determines the value of a specified property for an instance of its class:


/// get property value within class by indirection
Class objectscript.getPropOfThisClass Extends %RegisteredObject
{
	// extra code to help test
	Property myProp as %Integer;
	
	// need to instantiate an object to access property value
	method test() {
		// extra code to help test
		set .
0
0 0
Edit
Article Alexey Maslov · Nov 11, 2016 14m read

The technology of load balancing between several servers with relatively low capacity has been a standard feature of Caché for quite a while. It is based on the distributed cache technology called ECP (Enterprise Cache Protocol). ECP provides a host of possibilities for horizontal scaling of an application, and yet keeping the project budget fairly low. Another apparent advantage of ECP network is the possibility to conceal its architecture in the depths of Caché configuration so that applications developed for the traditional (vertical) architecture can be fairly easily migrated to a horizontal ECP environment. The ease of this process is so mesmerizing, that you start wishing it was always this way. For instance, everybody is used to having a possibility to control Caché processes: the $Job system variable and associated classes/functions work magic in skilful hands. Stop, but now processes can end up being on different Caché servers…

This article is about how to gain as much transparency in controlling processes in ECP environment as in traditional (non ECP) one.

0
0 6
Edit
Article Jon Jensen · Jan 19, 2016 1m read

A quick announcement about the upcoming Global Summit 2016 -  April 10-13, 2016.

InterSystems Global Summit 2016 is an unparalleled opportunity to meet with your peers and with InterSystems’ executives and experts, discussing the technologies, strategies, and methodologies that lead to success.

All InterSystems Global Summit 2016 sessions will be held at the Arizona Biltmore in Phoenix, Arizona on April 10-13, 2016

Learn more about Global Summit 2016 and register today!

(Early bird discounts end soon!)

0
0 21
Edit
Article Eduard Lebedyuk · May 9, 2017 6m read

Introduction

If you manage multiple Caché instances across several servers, you may want to be able to execute arbitrary code from one Caché instance on another. System administrators and technical support specialists may also want to run arbitrary code on remote Caché servers. To address these needs, I have developed a special tool called RCE.
In this article, we will discuss what are the typical ways of solving similar tasks and how RCE (Remote Code Execution) can help.

0
0 34
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert?

0
0 11
Edit
Question Stella Ticker · Jul 7, 2017

There is a need to send a SAML token from a local cache web application to an external web application in order to grant these cache web app users access to the external web app. Is it possible to use SOAP SAML token functionality to do IDP initiated authentication with Cache acting as the IDP server? The example in this online course shows a code snippet of the service web method that adds  the token to the outbound SOAP message. So I am assuming , this would be returned to the client in response to a client request of some sort.

0
0 38
Edit
Question PILAR GUERRERO · Jun 26, 2017

Hello,

I have a problem when i take the adapter: EnsLib.FTP.OutboundAdapter. 

I want to write a file, but if the file already exist using the method ..Adapter.PutStream(name,file) and in my setting "overwrite" is true. FTP response me this message:

<descripcion><![CDATA[ERROR <Ens>ErrFTPPutFailed: FTP: error al colocar archivo '803430600001072790112416-19941214-1233287355C-347.pdf' (mensaje='Error in SFTP Put('D:\Ensemble\ABC\NAMEAPP\NAMEAPP_G\stream\HnhZ32Fb1WDatA.
2
0 21
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 14, 2018 3m read

Let's create a class in Caché that will represent a teacher registry of a
University:

The name of our class will be Professor. Let's create it on
university package. To do so, make sure that your Caché
is in the Air (the small cube in your System Tray should be blue) and
right-click it, then click the
Studio, as shown in Figure 4.
When Caché Studio opens, make sure that you
is in the USER namespace. Just go to the File menu, and select the
Change Namespace option. Choose the USER namespace and press
OK.

0
0 49
Edit
Question prabakaran a · Feb 14, 2017

Hi All,

          while i configure the shadowing.i got following error.         

ERROR #1043: Shadowing is unavailable for current license

 

Thanks,

Prabakaran A. 

3
0 37
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert?

0
0 5
Edit
Article Peter Cooper · Mar 18, 2018 1m read

Index to Articles

Hi All 

In this article I will showcase one of my clients applications built in ZEN.  It is what I need to replace with a new UI as ZEN is no longer being developed

This application has been created for a single client who has unique business requirements - hence the bespoke development based on Caché ZEN
It is:-

  • Large(ish)
  • Supports and Implements Complex Business Processes
  • Secure
  • Multi Lingual
  • Reasonable size of development stack
0
0 0
Edit
Question Pravin Barton · Nov 7, 2017

Hello,

I have some code that reads an %XML.DataSet object that gets returned from a web service. I'd like to unit test this code by importing an XML data set from a test file. How can I do this?

I created the test file by calling WriteXML on the data set, and copying the output into the file:

do result.WriteXML(,,,,,1)

I tried to import the file using the XML reader, but the resulting data set doesn't have any rows:

USER>set reader = ##class(%XML.Reader).%New()
 
USER>w reader.OpenFile(filename)
1
USER>do reader.Correlate("SQLResult","%XML.DataSet")
 
USER>w reader.Next(.dataset,.
0
0 0
Edit
Question sansa stark · Nov 28, 2016

hi all,

        how to configure the crystal report in iis?

        how to generate the crystal report via intersystem cache ?

 

info :

  sap crystal report 2011

  iis 6 and windows 3 server

cache 5.02

 

Thanks,

sansa.

0
0 22
Edit
Question Theunis Pretorius · Nov 5, 2016

How do I call an excel report class from another class and name the report from the call class in cache?

This is the Report Class:

/// ProjekCin.Cinema.report.report
Class ProjekCin.Cinema.report.OLSQL16REP Extends %ZEN.Report.reportPage
{

/// Class name of application this report belongs to.
Parameter APPLICATION = "ProjekCin.report.Browse";

/// Specifies the default display mode used for this report if
/// the URL parameter, <var>$MODE</var>, is not present.
3
0 31
Edit
Article Jose Ruperez · Dec 16, 2016 1m read

The first step when dealing with performance is the ability to measure it. In this article, we will show you a way to measure the performance of your CSP and/or ZEN applications. You will be able to answer questions such as: Which pages of my application are hit the most? or Which pages in my application are the slowest?

1
0 21