Caché | InterSystems Developer Community

Question

Marek Bernád · Aug 11, 2017

How to implement mutual exclusion(mutex)?

Good day, every process in my software is about to update 3 specific globals in row when the process is called to do some job. I need to guarantee that during updating of those globals with multiple processes there is only one process that is actually working with those globals. Moreover I need my globals unreadable if other process is in critical area.

Example:

#Beginner #ObjectScript #Caché

1 8

0 924

Article

Pete Greskoff · Jul 11, 2017 1m read

Installation/Upgrade on Windows Can Fail With "Visual C++ 2013 redistributables (x86) not found!"

An installation or upgrade of Caché, Ensemble, or HealthShare on Windows could fail with the titled error if a newer version of the Microsoft Visual C++ Redistributable 2013 (x86) or (x64) is installed instead of version 12.0.30501.

#C++ #Microsoft Windows Server #System Administration #Caché

3 2

1 8.3K

Question

Ponnumani Gurusamy · May 18, 2017

Count of Global node.

How to we count no.of nodes in global.

#Beginner #Caché

1 7

1 1.8K

Question

Ruslan K · Jul 23, 2017

Check if class exists

There is method:

$System.OBJ.New( ClassName As %String = "" )

If class with name ClassName exists - everything is OK.

But, when class does not exist, there is error - <CLASS DOES NOT EXIST>

How can I check before calling $System.OBJ.New() if class witn name ClassName exists?

#Caché

0 19

2 4.6K

Question

Brian Shingle · Aug 7, 2017

Zen reports - Using the <call> element with parameters, but calling a method

Greetings!

I'm new to Zen reports and I'm wondering if what I'm trying to do is possible. I have a classmethod that accepts three parameters to generate an xml file from a global. I've set up my Report Definition to call the ClassMethod that generates the .xml file; however, I'm trying to figure out how to pass the parameters to that ClassMethod from the Report Definition. The example in the documentation shows parameter passing using SQL (which I'm not using), so I'm curious if this will work.

#Frontend #ZEN #Caché

0 2

0 489

Question

kavin kumar · Aug 8, 2017

Do and GOTO

Major difference between GOTO and do command?

#Beginner #ObjectScript #Caché

0 5

1 515

Question

Arun Kumar · Aug 8, 2017

CSP/ZEN page session timeout while extracting huge amount of data

Hello All,

While extracting the huge amount of data in the cache through the Zen page, file extraction timing is greater than session time out. How to increase the session timing in Zen/CSP gateway or If any other solution would be appreciated. Please advise.

#Caché #Frontend #CSP #ZEN

0 3

0 665

Question

Nael Nasereldeen · Jul 27, 2017

Print html file on the Server Side, Using Cache technologies

Hi Guys,

We need to print html reports, in the server side, to a specific printer that is installed on the Cache Server , and using the Internet explorer that is installed on the Cache Server to do that .

#Frontend #Caché

0 2

0 617

Question

Kishan Ravindran · Jul 20, 2017

Problem with setting a property

Hi!

While i am trying to write a data i am getting a error as "<PROPERTY DOES NOT EXIST>zFile+15^User.zKQRest.1 *value,%Collection.ListOfObj" but there are values stored in it. How can i break it write it separately.

#Beginner #Object Data Model #ObjectScript #Caché

0 6

0 865

Question

stephen mayo · Aug 10, 2017

Determine the impact of CREATE-INDEX on a large file

Hi,

I am new to Cache' MV but have extensive experience with other Pick flavors especially Unidata.

I need to determine the impact of adding several indexes to a large file with over 51,000,000 records.

On other systems, I could use FILE.STAT, ANALYZE.FILE and shell to the OS to determine how large the index file was.

None of those seem to be available in Cache' MV. Shelling to the OS just tells me the size of CACHE.DAT.

What is the best way to determine what the disk impact would be if I added an index (CREATE-INDEX) to a file?

TIA,

Steve

#Beginner #Indexing #MultiValue Basic #Caché

0 4

0 569

Question

Sébastien Demoustiez · Jul 27, 2017

[Fixed]Call REST Service on CSP Gateway Server

Hello,

I have a DB server (ser-app-db) where cache is installed as server.

I have a Web server (ser-app-w) where cache is installed as web server and configured as CSP gateway.

I followed the configuration guide (https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...) and ser-app-w perfectly display the CSP and CLS pages.

But that's not working for my REST service, for exemple with the REST sample:

#CSP #ECP #REST API #Caché

0 9

0 1.5K

Question

Uri Shmueli · Aug 10, 2017

Custom Index for Not Null Values Only

1. Is it possible do define an index like that :

create index UIX on MyTable (Column1) where Column1 is not null

2. What happens if we add an index on a property that is NOT required, meanning that not all records will be indexed because we do not allow null subscripts ?

#Indexing #Object Data Model #Caché

0 7

0 738

Question

Ecaterina Necula · Aug 11, 2017

Sort a %Library.ListOfObjects

I have a list of %Library.ArrayOfObjects . Each of list elements has some properties. I have to sort list by one of its objects properties. Is there a predefined method to doing that? (quicksort maybe?)

#ObjectScript #Caché

0 3

0 1.7K

Question

Marek Bernád · Aug 11, 2017

How to get from caché server actual linux TIMESTAMP(in seconds)?

Good day,

I need to find out if it is possible somehow to receive actual linux TIMESTAMP for example with $NOW() or other functions.
I was trying to recalculate it with $NOW() function, but without success. I would like to simulate Redis TIME command in COS.

My tryings:

USER > set time = $NOW()

USER > w (($PIECE(time,",",1)*86399) + $PIECE(time,",",2))
5573319043.403186

But in Redis it is:

#ObjectScript #Caché

0 7

0 757

Question

Rubens Silva · Aug 2, 2017

Is there a way to detect the last written char?

Hello.

I'm using device redirection to intercept incoming writes and need to figure a smart way to detect when to CLRF in order to prevent misleading outputs.

So basically, if the intercepted write ends with !, I need to know that and prevent my routine from writing ! as well.

Here's the source code for it:

#Object Data Model #Caché

0 13

0 609

Question

Simcha Gershon · Aug 6, 2017

How to Limit User Access to One Namespace Only

Hi Everybody

Question , I need to define a user that will be limited to only to one namespace.

I defined the start up namespace in the user's definition , but it doesn't limit the user.

Any advice would be appreciated.

Thank you Simcha

#Namespace #Security #Access control #Caché

0 3

0 944

Question

Tom Philippi · Aug 7, 2017

Where are local studio settings stored?

Okay, so I ran into a rather odd bug. I have a remote test machine (tst-intersystems) running for which I accidently opened a lot of windows in my Studio (i.e. 500+). The result is that the studio runs out of memory and crashes. Now, every time I try to connect to this remote machine studio immediately attempts to open all windows effectively not allowing me to start studio anymore.

#Studio #Caché

0 2

0 745

Question

Minu N · Aug 7, 2017

Recreate cache.dat file to increase space on disk

Hi,

I use cache 5.0 and access cache through OpenVMS.

The disk-space under a particular namespace has grown up in size due to cache.dat. How to recreate cache.dat to bring up more space back on disk?

#Beginner #Databases #Globals #Caché

0 11

1 1.6K

Question

Ruslan K · Aug 9, 2017

Various quantity parameters of tablePane

I have a tablePane. TablePane can have one, or two, or three parameters. It depends on some conditions.

At first I add all three parameters to tablePane.

#Caché #ZEN

0 2

0 364

Discussion

Sebastian Mueller · Aug 8, 2017

Your Workflow: Issue Tracking, Version Control etc.

I understand this is a rather broad topic (and at times involves religious sentiments) yet I would like to look at it from the Caché perspective:

#Change Management #Deployment #Development Environment #Tips & Tricks #Caché

2 14

0 954

Question

Mike Kadow · Aug 10, 2017

LogicalToDisplay Method

Hi, I am trying to understand the transformational methods.

LogicalToDisplay()
LogicalToOdbc()
OdbcToLogical()
DisplayToDisplay()

I have created a small class with the only property of List as %List, see below.

Class LastName.Demo2 Extends %Persistent
{
Property List As %List;

}

Then I entered the following commands in the Terminal

#Object Data Model #Caché

0 5

0 874

Question

Mike Kadow · Aug 9, 2017

%Library.Char

The data type %Char or %Library.Char

The description says it is a fixed length character field.

How do I set the fixed length?

Or by just setting %Char to something, does that automatically define its length?

Are the parameters MINLEN, MAXLEN involved? Or are these the way I set the fixed length?

Any help with this?

#Object Data Model #Caché

0 4

0 400

Article

Robert Cemper · Aug 8, 2017 1m read

Outperforming PostgreSQL and MySQL

In a previous exercise, I was able to show the power of Caché.
A medium-designed set of interdependent tables with some GB of data.
URLs cross reference over some million pages resulting in ~3 billion records

Competition was between

Caché
PostgreSQL
MySQL

Criteria were Speed + Storage consumption
I composed a customized loader fed over a "raw" TCP connection
Mapping the "objects" into the final table by directly writing to Global Storage.,

#Globals #Object Data Model #ObjectScript #SQL #Caché

17 3

0 869

Question

Evgeny Shvarov · Aug 7, 2017

%Status vs Other Return Values in Caché ObjectScript Methods

Hi, folks!

There is an interesting discussion in the neighboring topic which raises a question for me: is there any reason to have %Status as a return value for COS method?

#Object Data Model #ObjectScript #Caché

1 16

0 2.9K

Question

Eduard Lebedyuk · Aug 8, 2017

Apache server and directory index

I have a Caché server with external apache.

It has a hostname, i.e.: http://myserver.com

There is an index page, which is available over http://myserver.com/index.html (/ is a Caché CSP app)

How can I make index.html available from http://myserver.com?

Here's the relevant parts of my apache config:

#Frontend #Caché

0 3

0 899

Article

Fabian Haupt · Aug 3, 2017 3m read

Visualizing the data jungle -- Part IV: Running Yape in a docker image

In this short article we talk about how to get Yape running in a docker container to avoid having to setup python on your machine.

It's been a while since the last article in this series, so let's recap quickly.

#Docker #Performance #Python #Tools #Visualization #Caché

5 1

1 1.1K

Article

Robert Cemper · Aug 5, 2017 3m read

Winning in GIS competition

GIS stands for Geographic Information System.
and it's not a typical arena for Caché. But it's definitely an environment with high data volume.

You see 3 major areas

- Visual front end:
A mature area well covered by a bunch of commercial and open source products.
No need for Caché there.

#Caché

14 4

0 865

Question

Ruslan K · Aug 5, 2017

Problem with terminal font

I don't know what a problem with my cache cube terminal, but cyrillic text is not displayed correctly.

I have some terminal program with cyrillic menus, dialogs and other text and all those items are displayed wrong (unknown symbols like on the image).