#Caché

30 Followers · 4.5K Posts

  

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

Documentation.

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

To be honest, the description of CPUPct was excluded from

0
0 11
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.stream','ABC/803430600001072790112416-19941214-1233287355C-347.pdf') ERROR #7500: Error SSH '-2146426877': SFTP Error [80102003]:
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.
Once you are in the USER namespace, click
Right click on the Classes item in your project window and

0
0 49
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:

/// Class name of application this report belongs to./// the URL parameter, <var>$MODE</var>, is not present.
3
0 31
Edit
Article John Lambert · Apr 5, 2016 1m read

One of the internal changes in Cache 2016.2 is the switch from using Posix asynchronous IO on Linux platforms to native kernel asynchronous IO for improved performance. There is a kernel parameter that controls the maximum number of events that can be handled across the entire system and it is possible to hit this limit on newer versions of the Linux kernel when Cache is setting up disk IO structures in the WD or user processes. To prevent this from occurring we recommend that the kernel parameter 

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

To be honest, the description of CPUPct was excluded from

0
0 5
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,.status)
1
USER>w dataset
3@
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
Article Mike Kadow · Jul 22, 2016 2m read

NewBie's Corner Session 14 Inline Do & Nested Do with Implied Quit and For Loop

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

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

The following concepts of Inline Do, Nested Do, Implied Quit and For Loop is difficult to explain in a manner that everyone understands.However, these concepts work well with each other.

0
0 2
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
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 18, 2018 2m read

For those who are interested, or want to do something different with the cache language, I leave here two codes of animations.

They serve to run on the terminal while executing a routine, or a method.

To escape the monotony of seeing that static code in the terminal.

Examples:

1 - 

S S="",S1="",O="" F L=1:1:40{ S M0=$C(13,10),M1=$C(32,111,13,10,32,124,32,32,O,13,10,32,124),M2=$C(32,32,111,13,10,32,47,32,32,O,13,10,47,124),M3=$C(32,32,111,13,10,32,47,45,124,O,13,10,47,62),S=$S(L<=21:$S(L#4=3:S_" ",1: S),1:S),S1=$S(L<=21:$REPLACE($S(O'="":$S(S1="":"O",1:" "_S1),1:""),"    ",$C(79)_"   "),1:$E("

2
0 25
Edit
Article Alexey Maslov · Nov 12, 2016 14m read

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

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); note that we are referring to “cache”, not “Caché”, here. ECP provides a host of possibilities for horizontal scaling of an application, ensuring high performance and fault-tolerance, 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… The text below is about how I managed to cope with this problem.

0
0 0
Edit
Question Ferran Olle · Nov 23, 2016

Hello,

Our Intersystems Cache database is running in a Windows 2008 R2, and is installed and configured as "UNICODE" .

We are using Apache+PHP with  ODBC to get data but we have some problems with character encoding.

We also have two configurations:

  • Ubuntu 16.04 LTS + Apache2 + PHP 5.6 + UnixODBC
    • using isql command everything works fine, data returned is OK   (all special characters  in Spanish displayed ok).
    • using PHP with  PDO function to connect the database and libcacheodbcu35.so driver
      • with  default_charset=""  in  php.ini
      • Special characters in spanish not displaying   (  like   ü , é , ó , à , .
2
0 63