I have SQLCompute with SQLComputeCode on a couple of Properties in my class.
These work fin when I insert/update via ObjectScript or SQL from the ManagementPortal.
However, if I insert (create new record) via my C# app using the Caché ODBC DLL the SQLCompute is ignored, it does not run.
Is this expected InterSystems Caché behaviour? We are on latest IRIS platform.
Hi I am getting this message for some databases but not for others: This database is mounted as read-only due to 'Failed to access iris.lck file'! and not for others on Google Cloud community non-health edition.
For example this default database displays the message: Name IRISLIB Directory /usr/irissys/mgr/irislib/
But this default database does not: Name IRISSYS Directory /ISC/dur/mgr/
There's an easy new way to add certificate authority (CA) certificates to your SSL/TLS configurations on InterSystems IRIS 2019.1 (and 2018.1.2) on Windows and Mac. You can ask IRIS to use the operating system's certificate store by entering:
%OSCertificateStore
in the field for "File containing Trusted Certificate Authority X.509 certificate(s)". Here's an image of how to do this in the portal:
Hello everyone,
I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...
How can I take % to query, with
I am trying to make architecture for my project. And for it, it needs to make list property in which there is list of objects of another table, the data must be unique, therefore I make sql-query to check objects of another table if it is used or not, but I can't make sql-query to check elements in list in property with elements of another table. Can you help me? In property ID of object is used.
In the previous article, I have demonstrated a simple way to record data changes. At this time I have changed the "Audit Abstract Class" which is responsible for recording audit data and the data structure where the audit log will be recorded.
I have changed the data structure to a parent and child structure where there will be two tables to record the "transaction" and the "fields its values" changed on that transaction.
Take a look at the new data model:
does Health Connect have an out of box setting to send some type of "Keep Alive" packet? This is for a TCP connection. I have a vendor that will disconnect from the engine if there is a 2 hour idle time. would like to send something across every hour (if its idle) to prevent the disconnection. I'm assuming this may be something custom that needs to be created, but thought I asked the community first.
Pretty straight forward.
I'm tempted to hard-code ISO-8859-1 inside my VSCode extension when working with CSP because this seems to be the encoding used by default, but I need to know if there's any other possible configuration. So can you share your experience when working with CSPs? Like issues with encoding, discoveries regarding it, workarounds etc.
Also, can someone tell me if it's possible to work with UTF-8 encoded CSP files using Atelier without breaking the encoding of the output file?
I have the following class:
{
First webinar on InterSystems API Management!
We are pleased to invite you to the upcoming webinar in Russian: Introduction to InterSystems API Management on November 21 at 10:00 Moscow time (GMT+3)!
As you might have heard, we recently introduced the InterSystems API Manager (IAM) - a new feature of the InterSystems IRIS Data Platform,
enabling you to monitor, control and govern traffic to and from web-based APIs within your IT infrastructure.
In this webinar I will highlight some of the many capabilities IAM allows you to leverage. InterSystems API Manager brings everything you need:
There would be a live demo.
This webinar is for System Architects, Developers and DevOps Engineers.
Time: November 21 at 10:00 Moscow time (GMT+3)!
The language of the webinar is Russian.
Hi guys,
our end users in Prague, Czech republic, are seeking for new members of their teams. They are large and first class hospitals who are in the process of improving and implementing Ensemble based systems (with option to move to InterSystems IRIS in the future). For this they're seeking motivated team members (analysts, developers, devops, testers) who can contribute to team's success. These are long term opportunities, open to everyone - students, fresh graduates or senior experts.
Hello good afternoon!
We're testing a REST Operation, to View Devices using OneSignal API
We are sending the request from Production's Operation Test tool, using the following code:
.png)
What happens is that it tells us error of SSL Configuration:
Hi Developers!
Suppose you want to create your ObjectScript library to be distributed via ObjectScript Package Manager. And there is an obvious question: what is the naming convention on the packages and class names?
Naming packages and classnames
Hi,
It turns out that on windows if you run a command with a windows command file you need to escape the % character as %%
In my case I could test freeze and thaw calls at the command line successfully as
..\bin\cache -s. -U%SYS ##Class(Backup.General).ExternalFreeze()
...but when my freeze script ran it would fail.
it turns out that a single '%' is striped when run in a windows command file, and it must be escaped as '%%' windows gets:
InterSystems IRIS supports a unique data structure, called globals, for information storage. Essentially, globals are persistent arrays with multi-level indices, having several extra capabilities—transactions, quick traversal of tree structures, and a programming language known as ObjectScript.
I'd note that for the remainder of the article, or at least the code samples, we'll assume you have familiarised yourself with the basics of globals:
Hi,
I am trying to use the %Net.HttpRequest Class, and the request has to pass through a proxy server that requires authentication.
I am usually able to do that by using the following code:
Hello.
I want to grant access only to the Message Viewer page to an specific user, in all Namespaces. I have created a rol with this privileges:
%Ens_MessageContent
%Ens_MessageHeader
%Ens_MessageTrace
%Ens_Portal
But if I want to see the list of messages, I have to grant SELECT access to the Ens.MessageHeader and Ens.MessageBody tables of each Namespace.
Is there anyway to grant access to this tables in all Namespaces at a time, even if new ones are created?
Thank you in advance.
Good morning all,
A question to see if anyone out there is already doing this.
We have built a custom BS based off of the EnsLib.FTP.InboundAdapter. We have our processes wake up (using the Scheduler), grab the files in the directory, stay awake for a while, and then go back to sleep.
Each file goes through on its own message. So we can trace each individual file and we know if it made it successfully or not.
During migration from Caché to IRIS I can preview a situation where some instance
have migrated to IRIS while others are still on Caché.
For various reasons this may be in place for some weeks or even months as the big bang isn't feasable.
So far I found a lot of statements related to mixed endinans,
but nothing related to cross operation beween IRIS and Caché.
?? any hints ??
?? any experience ??
Hi,
I believe the healthshare Debug module did this (if you added it) but I no longer have access to Healthshare to look so am asking here.
Suppose I have;
Set fruit="apple"
set person="john"
d ..Something(fruit, person)
quit
ClassMethod Something(objs...) {
; Names of variables passed in
}
In side "Something" how can I see the original name of the variable passed in (i.e. know the variables passed in were called fruit and person and not just their values).
We're back with more AI, more ML and more presenters!
We are pleased to invite you to the upcoming webinar in English: AI Robotization (Python, R, Interoperability) for InterSystems IRIS on November 7 at 11:00 EST!
Hello Everyone,
I'm want to know, what is more common for your company to use, the abbreviation syntax or the complety name of commands, and why?
Ex.
S VAR=10 / D FUNC^ROUTINE F 1:1:1000
Set VAR=10 / Do Func^Routine / For 1:1:1000
set var=10 / do func^routine / for 1:1:1000
Here in my company, we are familiar with the abbreviation syntax, because to spell is more faster.
I have a task that has been working successfully for some time now but when I attempt to recompiled I get this error:
I'm having trouble with a server printer where nobody can open a particular device. I've seen all over documentation that you can't open a device if another process already has it open, but I haven't been able to find out what process has a device opened already.
Hi Developers,
New challenge on Global Masters: Review InterSystems IRIS on G2 and get 3000 points!
The page for InterSystems IRIS is new on G2, and we need so much your voices and experience to be shared with the worldwide audience!
Write a review on G2 using this link, complete the challenge on Global Masters and get 3000 points after your review is published!
A few years ago, I was teaching the basics of our %UnitTest framework during Caché Foundations class (now called Developing Using InterSystems Objects and SQL). A student asked if it was possible to collect performance statistics while running unit tests. A few weeks later, I added some additional code to the %UnitTest examples to answer this question. I’m finally sharing it on the Community.
Hi Community,
New video, recorded by @Stefan Wittmann, is already on InterSystems Developers YouTube:
