the useful content is in the replies
showing the use of $SYSTEM.OBJ.ValidateIndices()
Pieces of experience in InterSystems Technology which solve some particular problem in elegant or unusual way.
This small function is of great need sometimes. My solution is straightforward:
dupquote() ; duplicate quotes in
I'm just curious whether other solutions exist. Is there some "standard" and/or quicker approach which I've just overlooked?
Sometimes you can face the situation when you did update the web app on Caché server but you cannot get the newest version of the app in a browser.
Here are couple recipes which help me to solve it. From simplest to more sophisticated and not obvious.
1. Refresh page in a browser
In Chrome it is Ctrl+R or 'Refresh' button. Obvious, but helpful.
2. Hard reset in a browser
If you are in Chrome, open Developer tools
and then right click on Refresh button. Less obvious and very helpful sometimes.
3. Clear cache in CSP Gateway
If 1 and 2 don't work for you, try to flush the CSP Gateway cache.
It was my answer to the question appeared in GoogleGroups. And when I answered there I figured out that it might worth to post an article and to add some light on how Unicode is stored in Caché.
If you have an app that uses some Caché client Windows components that are not included into CacheODBC distribution (e.g. CacheActiveX.dll), you need to proceed Caché client installation on end user's client computers and/or MS Terminal Servers. Being a part of Caché client's installation, Caché Cube is installed along with other components and is autostarted with every user's session. So, it becomes visible to every user.
To make it completely invisible, you can just move CACHE.
If you are facing out the license expire warning message on your terminal ("*** Warning: This Cache license will expire in 3 days ***") and you do not want that message to be displayed, you can disable/enable that by rinning the following commands:
Do ExpirationMessageOff^%SYS.LICENSE - Disable
Do ExpirationMessageOn^%SYS.LICENSE - Enable
Introduction
Twilio is a great tool for programmatically initiating and managing phone calls. In this example we'll go over basic account setup, create a Cache Class to manage our interaction with the Twilio API, and initiate a phone call from the Cache Terminal.
The full Class used in this example is available on GitHub as well.
Setup
- Create an account on twilio
- Add a new phone number under the Manage Numbers Page.
- This will be the number you call from.
- Add a new caller ID under the Verified Caller IDs Page.
- This will be the number you call to.
This 'feature' have been around for a long time, but I don't see any articles on it so I thought I would make everyone aware.
A method is provided to customize the appearance of the Cache cube icon in the system tray so different instances can be visually distinguished. When csystray.exe, the Cache/Ensemble cube program, starts, it will look for files named "up.ico" and "down.ico" in the \bin directory below the instance installation directory. If these .ico files are present, csystray.exe will load the icons and display them in place of the default blue and gray Cache/Ensemble cube icons.
I wanted to share a little tidbit which is in the Studio documentation (http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls…) but many people who have been using the InterSystems Studio for a long time missed the addition of this *very* useful feature, and every time I mention this to an audience I see at least one face light up because of how excited they are to learn about it!
Within Studio, the Output pane (View -> Output) is actually misnamed. It is actually an Input/Output window which can be used to run Caché ObjectScript commands!
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:
- Do you use an issue tracking / collaboration system? If so which one. Any you would recommend or immediately dismiss based on personal experience?
- How do you keep track of large code bases? Thousdands of folders named backup1, backups2, ..., SVN, git?
In this article I would like to tell you about macros in InterSystems Caché. A macro is a symbolic name that is replaced with a set of instructions during compilation. A macro can “unfold” in various instruction sets each time it is called, depending on the parameters passed to it and activated scenarios. This can be both static code and the result of ObjectScript execution. Let's take a look at how you can use them in your application.
Caché offers a number of methods for going through a collection and doing something with its elements. The easiest method uses a while-loop and lets you fulfill the task in an imperative manner. The developer needs to take care of the iterator, jumping to the next element and checking if the loop is within the collection.
But is it really what a developer should be concerned with?
When working at a terminal prompt the %SS routine lets me see what's running on the instance:
USER>d ^%SS
But sometimes I'm only interested in knowing what's running in my namespace. In which case, here's what I use:
USER>d THIS^%SS
Recently I was conducting a remote support session with a site. The desktop they were sharing with me was on a PC configured with German as the native language. Since my German is rather rusty, and virtually non-existent when it comes to computing terms, I was glad to be able to switch the Portal session into English.
This is done from the page that appears when you use the About link:
All I needed to remember was that the About link is the second one, and the language selection dropdown is at the foot of that page.
Hi All
I'm looking for some field experiences, lessons learned, or actual deployed solutions to the problem of replicating non-CACHE.DAT data in a mirrored Cache environment.
Environment:
- Operating System is IBM AIX
- Hardware is IBM Power w/ virtualised storage
- Cache 2017.1
- 2x Production mirror members
- 1x DR mirror member
There are a number of different data types that we're looking at mirroring, and a number of identified solutions.
Prompted by this post about accessing a global at its original location after you have changed a mapping, here's a tip about one specific dropdown in Portal that's sometimes useful.
If your application is raising <PROTECT> errors and you're finding it hard to work out why, here's a way to get additional information.
First, if auditing is not already enabled, turn it on:
Then use "Configure System Events" (highlighted above) and locate the event named %System/%Security/Protect. In the screenshot below I used the Filter field to do this (type "protect" - highlighted below - and press TAB):
Notice that the Enabled column shows a value "No". By default <PROTECT> errors are not logged in the audit.
I only recently noticed the presence of a local database named CACHE alongside the more familiar CACHESYS, CACHELIB, CACHETEMP and CACHEAUDIT.
A bit of digging through the documentation archive led me to conclude that the CACHE database arrived in 2010.2, where the release notes say:
Note the lack of an accent on the words I have highlighted.
The above documentation is incorrect when it says "this database is mounted as read-only". In fact it is mounted RW. But the %DB_CACHE security resource that controls access to it only grants R as its public permission.
It's almost time to get your customers upgraded to new versions - are you worried about showing off your SQL Performance after upgrades? If you want to upgrade without worrying, then I have just the program for you!!! Check out this video from Global Summit 2016 featuring yours truly explaining how to upgrade a system without worrying about pesky SQL queries showing on your waistline!
Prior to 2017.1, whenever I created a new namespace using Portal on Ensemble or HealthShare it was automatically configured to host productions. This used to irritate me, because sometimes I'm setting up a namespace (for example, to host our Deltanji tool) that doesn't need the extra Ensemble baggage.
Sometimes I observe people scrolling manually down to the bottom of the Console Log document when they want to see the most recent messages. So I want to draw attention to the handy link that does the job for you in a single click:
If you deal with multiple instances of Caché / Ensemble / HealthShare and sometimes have to work at the Terminal command prompt, did you know that you can easily add extra information to that prompt which may help prevent you running a command on the wrong instance?
Inspired by the article "Declarative development in Caché" that's still trending on the dev com. The OP explored a functional style of iterating over a collection. A comment today suggested "Caché would need syntax support for anonymous functions".
With Macros you can kind of get anonymous like syntax using dot notation.
This is not production code, but it does work. First the macros...
#Define foreach(%c,%l) for i=1:1:%c.Size set %l=%c.GetAt(i) do #Define map(%oc,%nc,%l) set %nc=##class(%ListOfDataTypes).%New() for i=1:1:%oc.Size set %l=%oc.GetAt(i) do do %nc.Insert(fpl8349312378) #Define filter(%oc,%nc,%l) set %nc=##class(%ListOfDataTypes).%New() for i=1:1:%oc.Size set %l=%oc.GetAt(i) set fpl8349312378="" do if fpl8349312378'="" do %nc.Insert(fpl8349312378) #Define reduce(%oc,%res,%l) set %res="" for i=1:1:%oc.Size set %l=%oc.GetAt(i) do set %res=fpl8349312378 #Define return(%val) set fpl8349312378=(%val) quit
Hi Community,
This article assumes that you are familiar with Zabbix and SNMP monitoring, if not, there are some very interesting posts on the Community, especially this one (https://community.intersystems.com/post/creating-custom-snmp-oids) which contains a lot of information on how to configure and request an SNMP Cache server.
With Cache, all MIB data objects are organized into tables, so you need to know the index of an object to be able to get its value.
In case you've never used the "About" link at the top of Management Portal, here's a screenshot of the kind of information it shows. I've highlighted the link and some of the information I find it handy to get from here.
A feature I recently used in working on ISC internal applications is the ability to send emails on behalf of someone. This is useful when generating system notifications from an application when you want some of them to show up as being from a specific person, perhaps posting comments on a work ticket.
In my case I was updating our facilities work order system for tracking requests. Normally all notification emails are sent from the same noreply email address. I wanted to change that so comments added from the original requester would show up as being from them and stand out.
By default, Analyzer executes queries as components are added. Often, there are times where you may know exactly what you are looking to do, and you do not want Analyzer to execute 5 queries as you drag and drop items onto rows/columns and select your filters. This is where toggling Auto-execute off can help.
As more people join Developer Community, and with increasing efforts to promote code sharing, I'd like to draw fresh attention to this post I wrote a year ago. It spotlights a feature within the class compiler which is both useful and dangerous. When importing code (e.g. from an XML export of classes received from someone), it's worth considering the risks.
Even if that post doesn't seem relevant to you at the moment you may wish to note it for the future. A handy way of doing this is to click the star icon at the end of it.
Amongst the large fonts and chunky icons of Portal's pages, the Menu button in the top left corner is easily overlooked:
When clicked, it often produces the following menu:
When I remember it's there, I find the "View Console Log" option particularly handy.
I wrote "often" above because I've also noticed that the Menu contents change when I'm on a page within the Ensemble section of Portal:
Maybe the contents are context-sensitive elsewhere too and I just haven't noticed yet.
Until recently I didn't pay much attention to Portal's home page:
If it's not showing when you initially launch Portal you can easily jump to it using the button / tab at the top of the left-hand column of options. And later during your session, get there via the Home link that will be visible at the top of every page.
On the Home page the "Recent" section is automatically maintained for you.
To use the "Favorites" section you need to tag your favorite pages. Suppose I want to add the production monitor page as a favorite. Here's how:
1. Navigate the menu to find the link for the page you want.
2.