Hi All,
How to export the cache user account in cache 5.02?
How to import the cache user account in cache 12?
Thanks,
Sansa.
InterSystems Caché is a multi-model DBMS and application server. See more details here.
Hi All,
How to export the cache user account in cache 5.02?
How to import the cache user account in cache 12?
Thanks,
Sansa.
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.
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?
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:-
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.
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.
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:
I tried to import the file using the XML reader, but the resulting data set doesn't have any rows:
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.
Is there any simple code in Cache using FHIR to understand the relationship between them? If so can anyone provide some example.
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
{
Parameter PATH As %String = "E:\VCS\CommandExecutor\bin\
ClassMethod Test()
{
Do $ZF(-2, ##Class(%SourceControl.
}
Now when I run the command in the Cache Terminal, as given below,
>do $ZF(-2, "E:\VCS\CommandExecutor\bin\
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?KEY=GSQL_esql
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 .
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.
Hi,
I've managed to get a zen Report working where it outputs the contents to a pdf file - the pdf has a background image and it works perfectly. I now want to print that PDF from Caché.
I've tried to use the GenerateReport method - mode 12 — Generate a report in PDF format, and send it directly to a printer via the Caché Print Server e.g. s sc=rep.GenerateReport("Printdoc.pdf",12) (where "rep" is my zen report)
I've created the Caché print server in the management protal as per the documentation.
I don't understand where I need to specify the printer that I want to use.
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.
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.
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.
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.
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
DraftDraftDraftDraftDraftDraftDraftDraftDraftDraft
NewNewNewNewNewNewNewNewNewNewNew
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 we can do the following.
&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?KEY=GSQL_esql
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 on April 10-13, 2016
Learn more about Global Summit 2016 and register today!
(Early bird discounts end soon!)
This code snippet uses GZIP to compress and decompress a file in the file system. Change default file paths to customize code to compress/decompress your files:
Class objectscript.GZIP Extends %RegisteredObject
{
classmethod test() {
//Export Global(s) uncompressed
set filename="C:\Temp\myglobal.xml"
do $System.OBJ.Export("^oddEXTR.gbl",filename)
//Open exported Globals
set uncompressed = ##class(%FileBinaryStream).%New()
set uncompressed.Filename=filename
Set compressed = "C:\temp\mycomglobal.xml"
//Open File Device over Gzip and Copy Uncompressed information to it
Open compressed:("WUNK":::/GZIP=1:/NOXY=1:/OBUFSIZE=32768):0
Use compressed
do uncompressed.OutputToDevice()
close compressed
//Create New File
set out = ##class(%FileBinaryStream).%New()
set out.Filename= "C:\Temp\decomp.xml"
//Open compressed File and save information uncompressed over gzip
Set file=##class(%File).%New(compressed)
Do file.Open("RUK:::/GZIP=1:/NOXY=1")
while ' file.AtEnd
{
set line = file.ReadLine()
do out.Write(line)
}
do out.%Save()
}
}
GitHub: https://github.com/intersystems-community/code-snippets/blob/master/src/cls/objectscript/GZIP.cls
Hi ,
The below code is working in cache 5.02 but it'snot working cache 16.
while we calling this method in another csp page it's show some different character.
ClassMethod OnHTTPHeader(ByRef OutputBody As %Library.Boolean) As %Status [ ServerOnly = 1 ]
{
set user = $ZUTIL(67,15,$JOB)
set status = %session.Login(username, "Test" ,1)
set log = $Get(%session.Data("Log"))
set logtype = $Get(%session.Data("logtype"))
if (log = "")
{
W !, "<div style='color:#000000; background:white; ; font-size=10pt;'><B>Your session has expired.
Current Caché system monitoring functionality provides real-time information about a Caché environment. This allows for preventative measures to be taken before system failure by highlighting specific metrics when they are at unusual or dangerous values. Additionally, diagnosis of past or current erronious events is aided by informative logs that are created by the system monitoring process.
The System Monitor Dashboard project is a successor to the current system monitoring functionality.
Hi All,
while i configure the shadowing.i got following error.
ERROR #1043: Shadowing is unavailable for current license |
Thanks,
Prabakaran A.