Caché | InterSystems Developer Community

Question

Dmitry Maslennikov · Nov 24, 2016

Just curious how many companies use in their work Docker containers, I mean not only with InterSystems products. And if such companies exist, which of them uses docker and doesn't use it for InterSystems products by some reasons. What are the reasons? For companies which already uses InterSystems in containers, how do you use it? Development environment, testing or even in production ?

And if you don't use but thought about it, what are the reasons which stop you.

As for me, I've been using InterSystems Caché inside a Docker container in some different cases:

#Containerization #Continuous Integration #Docker #System Administration #Caché

3 2

0 788

Question

Chip Gore · Nov 23, 2016

Looking for examples of Cache Password Pattern specifications

Hi -

I know that when specifying Caché password rules (i.e. what constitutes a valid password definition) that the "Pattern Matching" logic is what is getting leveraged under the covers to enforce the "A Password Must conform to X" rule. I was hoping that people could share some more sophisticated pattern matching rules. (in particular, I was wondering what a rule that would require non-repeating mixture of letter, numbers, & punctuation of an overall minimal size)

#Caché #Security #Authentication #Access control #System Administration

1 3

0 578

Question

Arcady Goldmint... · Nov 23, 2016

Zen client methods and inheritance

I have a Zen page, and I would like to have an onload handler to run a bit of javascript when the page is ready. Unfortunately, the page inherits from a template, and the template already has an onload handler that does all kinds of useful things. Is there any way to override the onload handler in my page, while still being able to call the onload handler that is inherited from the template? In ObjectScript, there is ##super, but in javascript, there is no equivalent of that.

#ZEN #Caché

0 2

0 395

Question

William Proctor · Nov 23, 2016

Cache up in emergency mode

Good Morning, All replies are appreciated.

We have a development instance of cache that was installed and the person that installed and set it up is no longer here. We have no id's that we have the passwords for. I have brought the database up in emergency mode and I can get access thru the terminal using my emergency id but I do not know how to add a user/password thru the terminal. Can someone enlighten me or point me to documentation that I haven't found yet.

#Beginner #Caché #Terminal

0 2

0 598

Question

Lutz Vogt · Nov 23, 2016

How to use REST Service with https

We tested REST Services as described for Caché DocServer example and for requests using http protocol it works without problems. However when we use the https protocol for the same REST Service it is not available. Our infrastructure is as follows: Apache with openssl, which works on the other hand well for CSP with https. If we switch on the web gateway http trace facility we could see the request of CSP pages by https://... but again a request of a REST Service by https:// will not result in a entry in the tracer. We hope that this description of the problem is understandable.

#REST API #Web Gateway #Caché

0 1

0 718

Question

Tobias Ficker · Nov 23, 2016

How to rename a Caché-Instance on Windows

Is it possible to rename a Caché-Instance on Windows?

ccontrol doesnt work on a Windows system =/

#Caché

0 3

0 1.5K

Question

Stephen Wilson · Nov 22, 2016

How do you ensure synchronisation between two %ZEN.Component.tablePane objects?

TablePane1 is populated when a %ZEN.Component.button on a form is clicked from a JavaScript onclick method.

#Caché #Frontend #ZEN

0 3

0 448

Question

Martin Maier · Nov 22, 2016

Copy namespace mappings programmatically

Hi,

is there a way to copy namespace mappings from another namespace to a new namespace programmatically with a command?

When using management portal there is an option to choose an existing namespace to copy the mappings from, I'm basically looking for the equivalent from command line / COS.

Thanks

Martin

#Mapping #Namespace #Caché

0 4

0 657

Question

Evgeny Shvarov · Nov 22, 2016

Create Namespace snippet

Does anyone have a snippet to create the Namespace and database with defaults in one command?

Something like:

do ##class(Utils.Namespace).Create(Name)

Please share?

Thank you in advance!

#Code Snippet #Namespace #ObjectScript #Caché

1 4

0 747

Question

Eduard Lebedyuk · Nov 22, 2016

How do I log terminal output to file automatically?

As stated in title, I want to log everything I type/get in the terminal to a log file, is there a setting like this somewhere?

Preferably I'd like to enable it once and that's it.

#Beginner #Terminal #Caché

1 5

0 1.2K

Question

Mack Altman · Nov 21, 2016

How do you iterate through SQL in Cache ObjectScript; and across namespaces?

I would like to integrate SQL into our ObjectScript routines in order to illustrate how SQL can be used to minimize development time. However, there are two questions I have.

How does one iterate through the results of a SELECT statement?
How does one access a Table in another namespace?

#Object Data Model #ObjectScript #SQL #Caché

1 7

0 1.8K

Question

Nael Nasereldeen · Nov 21, 2016

creating a UTF8 encoded files

Hello,

When we need to create a utf-8 encoded XML file, we use the Charset property of %XML.Writer:

set writer=##class(%XML.Writer).%New()
set writer.Charset="UTF-8"

How can we create regular txt files with such encoding?

Our Cache Installations are 8 bit and not unicode.

Thanks,

Nael Naser eldeen

#Caché

0 10

1 3.3K

Article

Gevorg Arutiunian · Nov 21, 2016 5m read

Caché Localization Manager or i18N in InterSystems Caché

Caché Localization Manager

CLM is a tool for localization/internationalization/adding multi-language support to a project based on InterSystems Caché.

Imagine that you have a ready project where all the content is in Russian, and you need to add an English localization to it. You wrap all your strings into resources, translate them into English and call the necessary resource for Russian or English when necessary. Nothing tricky, if you think about it. But what if there are lots of strings and there are mistakes in Russian (or English)? What if you need to localize in more than one language – say, ten? This is exactly the kind of project where you should use CLM. It will help you localize the entire content of your project into the necessary language and retain the possibility to correct entries.

#Caché #Terminal #Tools #Languages #Localization #Frontend

6 4

0 927

Question

Evgeny Shvarov · Nov 20, 2016

How to export class package in xml

Hi!

Is there any way to export a class package to xml file programmatically which will include all the classes of the package?

#Change Management #Caché

1 12

0 1.7K

Article

Sean Klingensmith · Nov 18, 2016 10m read

Exploring Code Generation with Caché Method Generators

As a developer, you have probably spent at least some time writing repetetive code. You may have even found yourself wishing you could generate the code programmatically. If this sounds familiar, this article is for you!

We'll start with an example. Note: the following examples use the %DynamicObject interface, which requires Caché 2016.2 or later. If you are unfamiliar with this class, check out the documentation here: Using JSON in Caché. It's really cool!

#Best Practices #Compiler #Object Data Model #Caché #InterSystems IRIS

20 2

3 3K

Question

david clifte · Nov 18, 2016

How to set a beutiful name for settings field in BusinessOperation

I saw in: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... How to add a Setting to a Host, BO , BS or BP. But, how to set a beautiful name for a setting? Ex for properties: Property foo As %String; Property bar As %String; Parameter SETTINGS = "foo,bar"; I'd like something like: "A foo property" "A bar Property"

#Caché #Ensemble

0 2

0 325

Question

Scott Beeson · Nov 18, 2016

How to declare TSQL variable over JDBC connection?

I'm trying to use the standard TSQL DECLARE syntax but I get the following error:

[%msg: < IDENTIFIER expected, @ found^ DECLARE @>]

How do I declare a variable? For instance:

DECLARE @numrecords int = 10;
SELECT TOP @numrecords FROM mytable;

#Caché #JDBC #ODBC #SQL

0 3

0 770

Question

Scott Beeson · Nov 18, 2016

Server closed communication device?

I get this on some queries in some namespaces. For instance, this query:

SELECT TOP 10 SessionId, datediff(s,min(TimeCreated),max(TimeCreated)) as ResponseTime
FROM ens.messageheader
GROUP BY SessionId
ORDER BY ResponseTime DESC

It works fine in HSBUS but in HSREG it throws the error.

Server closed communication device

Does anyone know what would cause this? Would it log something more useful somewhere?

#Caché #Databases #JDBC #ODBC #SQL

0 7

0 892

Question

Albert Forcadell · Nov 17, 2016

DrawTableError in Management Portal SQL Utility

i have this error

DrawTableError : <MAXSTRING> zDrawTable+349^%CSP.Util.TablePane.2

perhaps i have the possibility of Deleting all history queries, but i think better to check the table where last queries were stored and solve it by deleting wrong registries. anybody knows where is the table 'QueryHistory'.

#SQL #Caché

0 3

0 294

Article

Jon Sue-Ho · Nov 17, 2016 2m read

Email alerts for cconsole.log messages using ^MONMGR

The MONITOR process (also called the Caché Monitor) scans the messages in your cconsole.log file and sends you emails based on the severity of those messages. The MONITOR is configured using the ^MONMGR utility in terminal.

The MONITOR should not be confused with the similarly named System Monitor, which checks a variety of system health and performance metrics and can log messages regarding them to the cconsole.log, where they can then be scanned by the MONITOR.

#Monitoring #Caché

2 6

1 1.3K

Question

Wendy Griffiths · Nov 17, 2016

%file RemoveDirectory

I'm trying to use the ##class(%File).RemoveDirectory utility to delete a windows folder. The folder has nothing in it, but it is not getting deleted.

#Caché

0 3

0 1.2K

Article

Alexey Maslov · Nov 17, 2016 11m read

ECP and Process Management API

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.

#Caché #Distributed Data Management #ECP

4 6

0 1.7K

Question

Paul Coviello · Nov 16, 2016

timeout value

looking for what the timeout value is for the connection for shadowing. and if it is known the timeout for mirroring also.

I'm currently getting this error and when we go to mirroring it would be good to know also, this way we can go back to our network vendor and give them as much info as possible.

10/19/16-12:19:40:696 (d30b6) 2 [SHADOWING] SHADOW SERVER (PRODSHAD): <ZREAD>ReadNone+3^SHDWUTIL;ERROR #1071: TCP read timed out - remote server is not responding (repeated 16 times)

thanks

Paul

#Caché #High Availability

0 1

0 860

Question

sansa stark · Nov 16, 2016

DataBase Configuration

Hi,

How to change READ ONLY Database to READ/WRITE
Could not find an option to edit it.

PS:
Cache 2016.1.0.656

Thanks,
Sansa.S

#Databases #Caché

0 3

0 661

Question

Albert Forcadell · Nov 16, 2016

Update several rows in SQL statement at Management Portal

Since now i have been working from external connection but i want to work with the SQL utility of Management Portal

i dont know how to do with several instructions like in other editors like this example

update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  80 where CodigoNum = '100' and Empresa = 'CO'
update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  400 where CodigoNum = '101' and Empresa = 'CO'
update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  400 where CodigoNum = '102' and Empresa = 'CO'

it returns

#Beginner #SQL #Caché

0 11

0 662

Question

Mikko Laitamäki · Nov 15, 2016

Accessing selfmade sys namespace csp class through normal namespace

Hi All,

I have SourceControl utility class as in sys namespace

 Class %MW.Web Extends %CSP.Page {... }

Previously with Cache 2010.1 and below there was no problem accessing it through

localhost:57772:/csp/myns/%MW.Web.cls

But now with newer version at least with 2016.2 I' ll get Forbidden message from it.

With Web Gateway HTTP Trace Facility

#Compatibility #Web Gateway #Caché

0 2

0 378

Article

Vicky Li · Nov 14, 2016 14m read

Mastering the JDBC SQL Gateway

As we all know, Caché is a great database that accomplishes lots of tasks within itself. However, what do you do when you need to access an external database? One way is to use the Caché SQL Gateway via JDBC. In this article, my goal is to answer the following questions to help you familiarize yourself with the technology and debug some common problems.

#Best Practices #Business Service #Java #JDBC #SQL #Terminal #Caché

12 2

7 4.1K

Question

Bapu Hirave · Nov 14, 2016

Soap Response performance

I have a soap webservice extended from %SOAP.WebService class

Lets say i have web method and have return type of following classes (either one of them)

Class ReturnTypeA

{

#Object Data Model #Caché

0 1