With the recent release of macOS 10.15, Apple has tightened its control mechanism , called Gatekeeper, so that it now requires executables to be notarized. InterSystems products are not currently supported for use on macOS 10.15 and the executables have not been notarized. (As a reminder, InterSystems products are supported on macOS as a development platform only.)

Hello,
I am currently trying to create a namespace and I keep receiving error #197 when I try to create the database for it. My OS is Coentos 7.7, my cache version is 2016.2.3.903.6.18300 and here is a screenshot of the error.

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

Query BooksLoaned() As %SQLQuery
{
SELECT *
FROM Library.Book
WHERE Friend IS NOT NULL
}

Which I have tested throught the portal:

I am reading the following code in ObjectScript:

GitHub repository

And there is a sentence which I am facing difficulties to understand:

kill ^OPNLib.Game.CWLF(..World)

I know that kill removes variables, OPNLib.Game are the package and subpackage, and ..World is a property. However what does CWLF mean?

You could think that it is the class' name, but it is:

Hi,

Is anyone out there using Cache to capture electronic signatures? The device would have to be called from a telnet session.

Thanks in advance,

Eamonn Fox

Index to Articles

Published 2018-05-11 Last edit -

Hi All

I this article I detail some strategic issues that a new development UI will need to address - these are the ones that I can think of now - others may come to light during this journey.

See the webinar by Eduard Lebedyuk here from the last Global Summit describing modern web development and Caché

And, as always, if I have missed something please comment....

Hi All!!

I am currently recruiting a very exciting position to work for a leading Healthcare software provider who are on the lookout for an experienced InterSytems Cache/Ensemble Developer for a 4 month contract!

This will be working on a leading Childrens Health Product and developing applications for the NHS, particularly working on a migration.

We are looking for:

APM normally focuses on the activity of the application but gathering information about system usage gives you important background information that helps understand and manage the performance of your application so I am including the IRIS History Monitor in this series.

In this article I will briefly describe how you start the IRIS or Caché History Monitor to build a record of the system level activity to go with the application activity and performance information you gather. I will also give examples of SQL to access the information.

Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space.

Basically, is there some utility or CLI command that would allow us to estimate if it is worth the effort of compacting a large database or not.

Thanks

I know &SQL returns only one result but is

&SQL(SELECT ID FROM Cinema.Film ORDER BY ID DESC)

and

&SQL(SELECT TOP 1 ID FROM Cinema.Film ORDER BY ID DESC)

the same in terms of processing required?

Hello,

lets have two abstract %Persistent classes A,B with NoExtent keyword (storing data in separate globals for each subclass).

Class A Extends %Persistent [Abstract, NoExtent]

{

}

Class B Extends %Persistent [Abstract, NoExtent]

{

Property Aref As A;

}

Let B class reference the A class. Since the A class has no extent the reference wont work in subclasses. It wont be even usable in SQL. Is it possible to solve this problem? Whats the recommended way to deal with references/relationships using NoExtent?

getting "The value of the property 'cspHttpServerMethod' is null or undefined, not a Function object" error while executing the csp page. All the server side methods stop working at this time although javascript functions still work but until the point where a server side method is getting called. Any clues why we get such error.

This week I am going to look at CPU, one of the primary hardware food groups :) A customer asked me to advise on the following scenario; Their production servers are approaching end of life and its time for a hardware refresh. They are also thinking of consolidating servers by virtualising and want to right-size capacity either bare-metal or virtualized. Today we will look at CPU, in later posts I will explain the approach for right-sizing other key food groups - memory and IO.

So the questions are:

When i use ##class(%SQL.Statement).%New() -> .%Execute() and then .%Next() to go through the result set, i could only go through part of the result. And then, i have to call