#Caché

30 Followers · 4.5K Posts

  

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

Documentation.

Edit
Question sansa stark · Dec 1, 2016

Hi All, I configured the crystal report SAP 2011 with IIS 10 in windows server 2012 r2 standard,when I tried to open it shows failed to open the connection error .database is Cache.how to recover that problem.

0
0 15
Edit
Question Chris Thompson · Dec 20, 2016

Currently we have a setup where we have an external IIS webserver that our CSP Gateway sits on that routes requests to our ensemble server. When working with soap everything was routed to the CSPms module since the site's handler mappings have *.cls going to this module. However, now that we are working with rest services that don't have a file extension we will have to have all traffic on the IIS box be routed through the CSPms module. 

I was curious if anyone has encountered this type of issue, and if so, what steps did they take to resolve it?

0
0 4
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
Article Cameron LaHart · Nov 22, 2016 2m read

Configuring Java with InterSystems Technology

Regardless of what InterSystems technology you use to design your applications, it is likely that some of our product functionality will require that Java be installed on the operating system, and subsequently be configured properly with your InterSystems based application. There are many ways that this can be accomplished depending on your operating system, as well as the specific InterSystems technology you are integrating with.

0
0 0
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
Article Thomas Carroll · Sep 17, 2016 2m read

Embedded SQL is a tool that allows us to execute SQL statements in Caché Object Script. For example, to select the name of a person with a particular SSN from the Sample.Person class

&SQL(

Select Name into :tName

From Sample.Person

Where SSN = :tSSN

)

The colon syntax is used to identify local variables, in this case tName and tSSN. &SQL indicates to our compiler that this is SQL syntax. At compile time, this statement will be optimized to executable Object Script code. More about this syntax can be found here.

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?

0
0 0
Edit
Question Peter Kopp · Oct 11, 2016

Good morning, I am using a <Image/> tag, in a <Tab/> tag, of a <TabGroup/> to render a tif image. I would like the tif file to be rendered full size. However, I have not been able to achieve this using the height="100%"  and width="100%" parameters available. All I get is an envelope with scroll bars, with perhaps a quarter of the image visible at any one time. Thank you in advance for any and all feedback.

2
0 18
Edit
Question Mike Kadow · Apr 26, 2017

I need some help on navigating through the DC.

I never know where I am, what comes next, what was previous.

Do I just mindlessly go from post to post? 

A least when I use to receive email on the posts, I had some control.

0
0 0
Edit
Article Katherine Reid · Jun 15, 2016 1m read

Question

 What version of Caché supports TLS v1.2? 

Answer

Caché uses the openssl library for SSL/TLS support.  On Windows, Linux and Unix, a version of this library is included with the install kit.  Caché 2014.1.3 and 2015.1.0 ship with the openssl 1.0.1j library.  TLS v1.1 and v1.2 support is first available in openssl version 1.0.1, so Caché 2014.1.3 and 2015.1.0 are the first versions to allow the use of TLS v1.1 and v1.2.

On these versions, if the "TLS v1" checkbox is checked in an SSL/TLS configuration, the system will use any of TLS v1.0, v1.1 and v1.2 .

0
0 4
Edit
Article Carter Tiernan · Sep 21, 2016 1m read

Overview

The The System Monitor Dashboard project is, most generally, an open source extension to the Cache System Monitor.

More specifically, it allows users to customize the monitoring of a Cache environment as well as how the collected data is visualized.

Goals

  • Displays important system state and historical information in an accessible and useful way.
  • To provide an intuitive and complete API for users to tailor the Cache System monitoring to their specific needs.
1
0 0
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
Article Mike Kadow · Jul 4, 2016 2m read

NewBie's Corner Session 10, Subject: Routines and Studio

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.

InterSystems has a new IDE called Atelier but that is for later.

A Routine is the name that Caché calls computer programs. A Routine consists of a number of lines of instructions to the computer; these instructions are called code.

0
0 2
Edit
Question sansa stark · Nov 29, 2016

Hi all,

       In Cache 5.02 while creating user the password was encrypted.

      how to decrypt the password in cache 5.02?

       We upgrade the cache 5.02 to cache 2016 ,But the user accuonut  are not updated in cache 16.

      We have created user acconut in login global in "%SYS" namespace .But the password are encrypt.

Thanks,

sansa.

1
0 64
Edit
Question Peter Kopp · Jan 31, 2017

Good morning, I would like to visualize the data summarized in a tablepane in a pieChart widget. Since my tablepane has already executed the query, I would like to use the tablepane snapshot as the data source for the pieChart widget. Is this possible? What would the syntax be for linking the widget to the snapshot look like? Thank you for all input.

0
0 14
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
Article Ward De Backer · Jun 23, 2016 2m read

In this article I will show you how to build Universal JavaScript  applications using Caché (sharing your code across front- and back-end). But before we start writing code, I'll first give you some reasons and background why you should consider building your applications using this technology.

As I described in an earlier article on my CODE development blog, applications need to run these days on all kinds of devices and operating systems with different form factors and application development requires a new strategy. One can't keep using platform specific development tools anymore.

0
0 4
Edit
Question Sebastian Thiele · Nov 11, 2016

Hi,

I try to programmatically create a parameter for a dataCombo ZEN Component (which is in turn created on the server side at runtime).

Set tParm = ##class(%ZEN.Auxiliary.parameter).%New()
Set tParm.id = "pRegion#"_pExamContainerCount, tParm.name = "pRegion#"_pExamContainerCount

Set tExam = ##class(%ZEN.Component.dataCombo).%New()
Set tExam.id = "Exam#"_pExamContainerCount, tExam.label = "Untersuchung", tExam.queryClass = "Inventory.ServiceCatalog", tExam.queryName = "QGetExaminations", tExam.showEmpty = "false", tExam.size = "52", tExam.onchange = "zenPage.updateExamDescription(zenThis.

0
0 2
Edit
Question Thomas Chericka · Oct 7, 2016

Hi,

Thanks a million for taking the time to read this.

I'm calling the functions $ZF(-`1, <path to EXE>) and $ZF(-2, <path to EXE>) from Cache code. The exact code I'm using in Cache Studio is given below.

/// Test the functionality of ZF(-1) and $ZF(-2), 
Class %SourceControl.UnitTest Extends %Persistent
{
Parameter PATH As %String = "E:\VCS\CommandExecutor\bin\Debug\WindowsApplication.exe";
ClassMethod Test()
{
Do $ZF(-2, ##Class(%SourceControl.UnitTest).#PATH)
}

Now when I run the command in the Cache Terminal, as given below,

>do $ZF(-2, "E:\VCS\CommandExecutor\bin\Debug\WindowsApplication.

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