#Caché

All replies are appreciated.  We have put our first client into our production cache database and we are looking at what kind of regular maintenance is needed.  We were questioning whether we should defrag the database files using windows defrag program and whether we need to run the defrag for Globals regularly?  Should we be doing these routinely , occasionally or not at all?

We don't often use SQL within our org, which is mostly due to the performance issue we experience due to the quantity of data we are reviewing.

Aside from the standard performance measures for non-Caché databases, are there any recommended approaches when querying large tables?

The table would have roughly 50M records, but there are not a finite amount of sub-nodes.

Hi all,

         How to set username while take telnet from particular ip in cache 16?

Thanks,

Sansa.

Enterprises need to grow and manage their global computing infrastructures rapidly and efficiently while simultaneously optimizing and managing capital costs and expenses. Amazon Web Services (AWS) and Elastic Compute Cloud (EC2) computing and storage services meet the needs of the most demanding Caché based application by providing
 a highly robust global computing infrastructure.

Hi all,

I am looking for an implementation idea for displaying a large amount of data received from a webservice. This data are essentialy HL7-Message as a GlobalCharacter Stream and some metadata (status,processed,timecreated etc.).

Since I need sorting functionalities for those metadata a tablepane in a zen page seems to be suitable. i know there are different ways to provide data for the table but in this case it´s complicated to get them data fetched.

Consider the following steps

1. Get the data from webservice
2.

Hello Fellow Caché Developers,

The purpose of this post is to ask for everyone's thoughts and input around the use of transient, SQLCalculated/Computed properties within persistent classes.

This approach allows for extra data values needed in SQL queries to be available without having to join to other tables.

Very simple/basic example to illustrate the topic:

Let's say I have a persistent class named ICDAutoCodeDefn to hold ICD Auto-Coding definitions, such as:

Class ApplicationName.DB.MedicalCoding.

 Error:

    [SQLCODE: <-400>:<Fatal error occurred>]
    [Cache Error: <<SUBSCRIPT>%0AmEdun+4^%sqlcq.HSREGISTRY.cls966.1 ^||%sql.temp(1,"")>]
    [Location: <ServerLoop - Query Fetch>]
    [%msg: <Unexpected error occurred:  <SUBSCRIPT>%0AmEdun+4^%sqlcq.HSREGISTRY.cls966.1 ^||%sql.temp(1,"")>]

Here is an example of a query that gives the error:

    SELECT COUNT(DISTINCT Criteria) as Relevance FROM HS_IHE_ATNA_Repository.Aggregation
    WHERE EventType = 'CROSS GATEWAY QUERY'

The content of the actual field is XML, but the query simply returns a number.

I have a class which defines a property as array of %String. Is it possible to index values of this property and use this property in SQL?

I have tried 'Index idx On prop(ELEMENTS)' and then a select from the generated collection table, but this is still orders of magnitude slower than queries to the containing class.

Is there a tool to get the slowests queries ?

In writing some code on:

Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST

I noticed an unexpected "ROLLFAIL" error when a Unique Index fail was generated in a %Save() call.

The object SHOULD fail to save, since the Unique criteria is not met, but I didn't expect to see a ROLLFAIL error as the "Last Error".

When running the following class code:

Class BUG.Test Extends %Persistent
{

Property Field1 As %String;

Property Field2 As %String;

Index idx1 On Field1 [ Unique ];

ClassMethod Test()
{
    kill ^BUG.TestD
    kill ^BUG.

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)

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.

Coming from a C/C++/C# background, I was expecting the & and | operators in Cache ObjectScript to perform bitwise operations on integers, but apparently they don't.

I checked the online documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

but couldn't find any information on bitwise integer arithmetic.

So given the following code:

set x = 10  //bit pattern is : 1010

set y=3      //bit pattern is:   0011

What operator can be used to return z = x <BITWISE OR> y  = 1011 (binary) = 11 (decimal)

Thanks,

Bill

Good day

Additional tool for MUMPS servers MiniM InterConnect:

http://www.minimdb.com/tools/interconnect.html

to connect job on one MUMPS server to other job on other MUMPS server in client-server mode. This tool can connect different MUMPS systems on different OS and with different processors - MiniM, Cache and GT.M in any pairs.

Regards,

Eugene Karataev

Hello

I have to receive GPS tracks through a TCIP port using SOCKET listen port from INTERNET, how can I implement this in CACHE?  through websocket ?. Thanks if you can help me.

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!

I had a table which contained data and worked fine, without changes the code of the persistent classes I now get the following error:

II have tried to browse the data for a 'clue' but no result.

What is the explanation of the error message?

Thanks in advance!

Hi all, Basically i have 2 queries..

1. Is there any simple way to fetch the data directly from the database (using the URL and credentials) from the csp file without creating a link table for that particular Table...?? If there is, could you please share the syntax of using them ..?

2. Can we have an object return type from the below mentioned method to a javascript function.. ???

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.

Does anyone know how to connect a Cache client to a GT.M database?  I recently installed Osehra VistA on my PC and it uses GT.M, but we're supposed to use Cache Studio to develop.  I tried adding a server to Cache (specifying 2222 as the port) and I get an "access denied" error.  Port  2222 is the correct port which I use for for VirtuaBox and I have no problem connecting to VistA.  I also tried going into the Management Portal to set up a local connection but this isn't working.  There are some sites that say the products 'nodem' or 'node.

Good day

Let me offer Cache Tools

http://www.minimdb.com/tools/cachetools.html

Routine and Global editors for Intersystems Caché, ported to Windows, Linux, MacOSX.

Regards,

Eugene Karataev

www.minimdb.com

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.

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.

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.

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

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

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:

Good day! Can someone briefly explain or give me a link to documentation why in Linux Cache starts 8 Write Daemons (Main and 7 Slaves)? Thanks!

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.

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.

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"