#Caché

30 Followers · 4.5K Posts

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Question Bill Wang · Nov 27, 2016

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

2
0 886
Question Marco Blom · Oct 21, 2016

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!

4
0 778
Question Rajath Muthappa · Nov 9, 2016

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.. ???

<script language="cache" method="methodName" arguments="argument1" returntype= "Not sure of the return type"> QUIT object </script>

9
0 881
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:

  • To test new FieldTest version,
2
0 898
Question Jeff Alfini · Nov 1, 2016

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.

8
0 1045
Question William Proctor · Nov 23, 2016

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.

2
0 718
Question Lutz Vogt · Nov 23, 2016

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.

Any hint is

1
0 861
Question Martin Maier · Nov 22, 2016

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

4
0 804
Article Gevorg Arutiunian · Nov 21, 2016 4m read

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.

4
0 1055
Question Albert Forcadell · Nov 17, 2016

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'.

3
0 373
Question Archunan K · Nov 14, 2016

Hi All,

              I have configured my application with IIS 8.5 in windows server 2012.

             I have tried to generate sample HTML report . The issue is

                 when the url is like 'http:\\192.168.1.2\test...mode='html'....'    the reports are generated successfully.

                 but while using systemname like 'http:\\mysystemname\test....mode='html'...' the reports are not generated and throws error like

"   The XML page cannot be displayed Cannot view XML input using XSL style sheet.Please correct the error and then click the Refresh button, or try again later.

3
0 421
Question Scott Beeson · Nov 18, 2016

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?

7
0 1158
InterSystems Official Steve Brunner · Nov 7, 2016

I am pleased to announce the field test of Caché and Ensemble 2017.1, including many new improvements.

The product team at InterSystems looks forward to your participation in the field test and feedback over the coming months.

Some of the more significant changes in 2017.1 are the new RESTful APIs for iKnow, FIPS 140-2 validated cryptography for Caché database encryption, and improved DocBook search. As always there are a host of scalability and performance improvements to the core database and SQL. And hundreds of smaller improvements and corrections.

2
0 926
Question Bapu Hirave · Nov 14, 2016

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

{

 Property SelectedDoses As %XML.DataSet;

}

Class ReturnTypeB

{

 Property SelectedDoses As list Of WebServices.DataTypes.Dose;

}

Which return type class has better performance while in terms of xmL serialization ? A or B

my client application is in C#

1
0 474
Question Paul Coviello · Nov 16, 2016

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 

1
0 981
Article Alexey Maslov · Nov 17, 2016 11m read

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.

6
0 2093
Question Sebastian Thiele · Nov 11, 2016

Hi,

I try to programmatically create a parameter for a dataCombo ZEN Component (which is in turn created on the server side at runtime).

Set tParm = ##class(%ZEN.Auxiliary.parameter).%New()
Set tParm.id = "pRegion#"_pExamContainerCount, tParm.name = "pRegion#"_pExamContainerCount

Set tExam = ##class(%ZEN.Component.dataCombo).%New()
Set tExam.id = "Exam#"_pExamContainerCount, tExam.label = "Untersuchung", tExam.queryClass = "Inventory.ServiceCatalog", tExam.queryName = "QGetExaminations", tExam.showEmpty = "false", tExam.size = "52", tExam.onchange =

2
0 477
Question Wendy Griffiths · Nov 17, 2016

Hi

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.

I've tried doing Set sc=##class(%File).RemoveDirectory(file,.return) and return is returning a -2.  I've also tried changing it to .Delete in case that worked, but I got the same. 

I've tried it on my local instance and on a customer site on an older version of Cache that doesn't have the return parameter, but it also fails to delete the folder on there too.

file is the full filename and path and the .Delete works fine when used on files.

Any

3
0 1416
Question Albert Forcadell · Nov 16, 2016

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

ERROR #5001: 25: SQL ERROR #25: Input (UPDATE) encountered after
11
0 829
Question Anzelem Sanyatwe · Nov 14, 2016

Can Cache Monitor (^MONMGR) and System Monitor be configured to also send 'OK' messages? With the first bad email, you still wonder if things are still broken, when in-fact normalcy has been restored, some even within some seconds.

typical examples : -

------ - - - -- - - - -- - -- --- - -- -- -- - - - -- -- -- - --- - - - -- - - -- - - -- --- - - -- -- -- - - --- - - - - --- -- --- - - -- -- --- - - --- - --- -- - - -- -

Sent: Monday, 14 November 2016 11:51 AM

To: Email

Subject: [CACHE SEVERE ERROR :ENSEMBLE] CP: Pausing users because Journal Daemon has not shown

11/14/16-11:50:43:430 (3455) 2 CP:

1
1 1809