#Caché

1 Follower · 4.5K Posts

  

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

Documentation.

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 354
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

3
0 406
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 1111
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 453
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 967
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

6
0 2045
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.

3
0 1385
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

11
0 790
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

1
1 1790
Question Steve Riddle · Nov 9, 2016

Hi,

I have a process that is importing lots of data from an external file, but every now and then I come across a STORE error.

I know that the STORE error is occurring in the %Save method of the class but I know very little else and I think its something to do with a lage amounts of Related Objects.

Is there a method of finding out more information regarding this error i.e. which actual object was being saved etc etc.

Thanks

Jim

9
0 2949
Question Mikko Laitamäki · Nov 15, 2016

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 

GET /csp/ipanax2/%MW.Web.cls HTTP/1.1  

​-->  HTTP/1.1 403 Forbidden  

How can we make it accessible again? 
 

 Mikko

2
0 451
Article Can (Jon) Gencler · Nov 8, 2016 5m read
Importance and Collection of Exact Version Information ($zv / $zversion)
 
The explanation of:
- why collecting $zv is important (The WHY),
- what the components of $zv mean (The WHAT),
- and how to collect $zv (The HOW). 
(The Ultimate $zv Guide to the ISC Galaxy in large, friendly letters)
4
1 1667
Question Mikhail Khomenko · Nov 10, 2016

Running TuneTable accounts among other the parameter named Block Count. In documentation, we see that this is an approximate numbers of 2K-blocks in which SQL-maps are stored. Databases in recent Cache doesn't support 2K-physical blocks so SQL-blocks are not physical blocks as it seems. So two questions:

- what are these blocks?

- how knowledge about count of blocks can help in SQL optimization?

Thanks for intelligent answer to stupid questions!

4
0 575
Question Marc Mundt · Aug 9, 2016

A new Health Connect customer has a few experienced Java folks on their interface team. As they get more into Health Connect and learn Caché ObjectScript they thought it would be useful to have a list of common Java statements with an equivalent statement in ObjectScript. They mentioned string manipulation as an example, but would be interested in other areas as well.
 
This seems like something that is probably already floating around somewhere. Does anyone have something like this or other "COS jumpstart for Java devs" materials?
Thanks,
Marc

1
0 468
Question Chris Stewart · Nov 7, 2016

I'm working on a REST service which will include a binary stream as a request property. I'm currently encoding the stream as BASE64 and passing it as a string value, but I was wondering if there is anything in the Caché JSON support that may be a better fit for encoding this data? Thanks Chris

3
0 974
Article Wojciech Czyz · Nov 14, 2016 2m read

Microsoft Office has components for using in third party applications: COM Objects for C++ and Interop Assemblies for .Net programming.

Many Cache projects used to include calls to those libraries. However, recently this solution started being problematic.

There are two main reasons - legal and technical. Let’s check the details.

Microsoft technology support

Microsoft is supporting Office Automation only for desktop computing. 

It shall not be used for server computing, as they offer Sharepoint for this scenario. Have a look here:


0
0 570
Question Uri Shmueli · Nov 10, 2016

Hi all,

We've found that in most cases when we open a new CSP session the CGI varaiable %CGIEVAR("HTTP_COOKIE") contains the client name.

It looks like that : "state=SYSADM%3A0; Username=Urish; CSPWSERVERID=Cache for Windows (x86-64) 2013.1.1 (Build 501_1_13062) Sun Aug 11..."
In some other cases this CGI only contains  $zv - like "CSPWSERVERID=Cache for Windows (x86-64) 2013.1.1 (Build 501_1_13062) Sun Aug 11 2013 23:20:33 EDT"

2
0 472
Article Murray Oldfield · Nov 12, 2016 5m read

Index

This is a list of all the posts in the Data Platforms’ capacity planning and performance series in order. Also a general list of my other posts. I will update as new posts in the series are added.


You will notice that I wrote some posts before IRIS was released and refer to Caché. I will revisit the posts over time, but in the meantime, Generally, the advice for configuration is the same for Caché and IRIS. Some command names may have changed; the most obvious example is that anywhere you see the ^pButtons command, you can replace it with ^SystemPerformance.


While some posts are updated to preserve links, others will be marked as strikethrough to indicate that the post is legacy. Generally, I will say, "See: some other post" if it is appropriate.


Capacity Planning and Performance Series

Generally, posts build on previous ones, but you can also just dive into subjects that look interesting.


0
7 6484
Question Michael Loutraris · Nov 10, 2016

We are trying to understand how websocket connections from a javascript client may timeout in cache. Does anyone know if and of the session timeout or any other timeouts apply to any synchronous websocket connections? I have not been able to prove that they do timeout at all.

5
0 688