#Caché

30 Followers · 4.5K Posts

  

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

Documentation.

Question Robert Hanna · Apr 24, 2017

I am trying to set up a sensor in PRTG to connect to Cache, specifically the ens_util.log, so that I can have a live feed of my error count. I am having trouble getting the sensor to log in to Cache. Has anyone had any luck getting PRTG to connect on the database level? Thanks!

2
0 606
Question Stefan Cronje · May 19, 2017

Hi,

I have an XML file with many repeating elements to validate.

The structure of the file looks like this:

<cm_file>
  <header>
    <sequence_no>919230983</sequence_no>
    <file_date>165362597</file_date>
  </header>
  <payment>
    <client>871619361</client>
    <client_reference>F8718</client_reference>
    <collection_ref>A3302</collection_ref>
    <account_no>N4764</account_no>
  </payment>
  <disbursement>
    <client>83957000</client>
    <client_reference>H36</client_reference>
    <payment_ref>B6426</payment_ref>
    <account_no>M9347</account_no>
  </disbursement>
  
3
0 393
Question Graham Hartley · May 17, 2017

Hi,

Is there a way you can limit the amount of physical memory Cache uses?

During Cache backup it appears that all the available memory on the server is being used.

We are running Ensemble 2016.1 on Windows Server 2008 R2 with 32GB of RAM.

The database we are backing up is about 300GB.

Thanks,

Graham

3
0 622
Question Raghuram Devarakonda · May 18, 2017

Hi,

I am trying to support a use case where a test instance is created from a production backup.  At a high level, the process works by mounting all relevant file systems and then bringing the instance up. This works well as long as the file systems are mounted using same mount points as the source instance. However, I would like to support a case where file systems are mounted using different paths. 

For example, if the source instance uses the mount points "/cache" and "/cachejournal", assume that the restore process mounted the same file systems at "/cache_123" and "cachejournal_123". I am wo

1
0 405
Question Tom Philippi · May 18, 2017

I am getting an ERROR #5002 in a soap service defined in ensemble. Odd thing is that I allready have a functioning business service running as a soap service, but we needed another, but that one returns an error:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2001/XMLSchema">
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
         <faultcode>SOAP-ENV:Server</faultcode>
         <faultstring>Server Application Error</faultstring>
         <detail>
            <error xmlns="http://
3
0 4268
Question shobha rani · May 17, 2017

HI ,

Please let us know the solution to the below error which appeared during SOAP Wizard.

ERROR #5805: ID key not unique for extent '%Dictionary.ClassDefinition' : '^oddDEF("GuruBaseAllah.BLZServiceSOAP11porthttp")' exists. Id counter location = ''

Thanks,

Shobha

1
0 385
Question Mitch Anderson · May 16, 2017

Hey guys,

I'm working with an EnsLib.XML.X12.Document object which consists of a parent object along with multiple children.

When using the following code, my sent object is losing all references to its children.  I've played with the deep parameter and nothing is working to automatically clone the objects children(group docs ref)along with itself.  (Even though the documentation states that it should..)

objectClone = object.%ConstructClone()

d ..sendRequestAsync("Destination",objectClone)

Any insight would be really helpful.

Thanks!

Mitch

1
0 1123
Article Dmitry Pavlov · Jan 20, 2017 7m read

About the Ontodia library

First of all, I think we should provide some background information about Ontodia and Caché DBMS. Let’s start with a less known product, Ontodia. Ontodia is the result of a joint project of the ISST lab of the ITMO University and VISmart, a software development company specializing in the semantic web domain. The Ontodia service was created as a web application for visualizing linked data and ontologies. We created this service because we couldn’t find simple, accessible and efficient tools for convenient visualization of linked data.

A typical use case for Ontodiа

3
0 1135
Question Eric Hansen · May 15, 2017

I am trying to apply a temporary time-limited key for our organization to a Cache Server that I built out a few weeks ago for testing purposes. When I navigate in the portal to activate a new license key, I get this "ERROR #8610: License keys are not accepted on a Single User (SU) platform."

Is there something I need to do for this system in order to make it compliant for the key or do I need to request a new key from InterSystems that will work for this system? I didn't turn up anything on the web site here or via Googling the error and error text. I'm trying to enable and test mirroring

2
0 544
Question P Patz · May 12, 2017

Looking for a way in which I could possibly pass a flag through a property when performing an Insert statement, on a mapped class.

insert into my.class (serialNumber, modelNumber, myFlag) value ('testSerial', 'testModel', 0)
    myFlag is not stored in the DB.

The mapped class then calls a legacy routine (MAC) via CodeMode = 'objectgenerator', (Insert method within the 'objectgenerator')

Within the legacy routine, I am setting an index... but I don't always want to set it (multiple inserts, and I will only set the index on the LAST insert)

How can I pass that flag through the insert call?  I attemp

4
0 349
Article Sean Connelly · May 15, 2017 2m read

Wanna Cry

Most of you should be aware that the Wanna Cry virus is massively infecting un-patched windows machines all around the world. It's particularly affecting the NHS, one of my main clients. 

Wanna Cry is one of a line of Viruses that exploit SMBv1 over ports 135 and 445.

A kill switch has been enabled, but this won't protect machines sitting behind http proxies, and there are already reports of new versions without a kill switch.

All windows machines should be isolated and updated a.s.a.p. 

If automatic updates is not on, a patch can be dowloaded from here...

https://technet.microsoft.com/en-

1
0 836
Question Ponnumani Gurusamy · May 13, 2017

Hi Team,

                 I am interesting to learn IKNOW concepts in Cache.Will need your guidance.

                 I. What is iKnow.

                 ii. Where we are using Iknow(Real time example)

                 iii. How to we work on iKnow(Did any tools Need?)

                iv. Please give notes and articals

Thanks ,

Ponnumani Gurusmay

3
0 308
Question Marco Blom · Mar 25, 2017

Hi community,

I do not understand why I get a 'javaScript exception'?

Purpose is to search for a [Country] based upon a [Code] as search parameter.

this is my code:

<hgroup>
<text id="CountryID" name="Code" label="Code" size ="8" />
<spacer width="5"/>
<text id="CountryName" name="CName" label="Country" size ="24" />
</hgroup>
<spacer height="5"/>
<button caption="Search" onclick="zenPage.searchValue();"/>
</page>
}
ClientMethod searchValue() [ Language = javascript ]
{
var ctrl zen('CountryID');
tVar ctrl.getValue();
alert (tVar); ///test-show text value
zenPage.sqlTest(tVar);
}
Method sqlTest(tVar) [ ZenM

9
0 706
Question Laura Cavanaugh · May 12, 2017

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

9
1 639
Question Alex Kogan · May 12, 2017

Hello All,

I have a question / issue regarding the calling list.FindOref(<object from indexOpen call>)
Here is a simple way to reproduce the issue: 
2 classes: Utility.contacttypes and Utility.person
*************************

Class Utility.contacttypes Extends %Persistent
{
Property description As %Library.String(TRUNCATE = 1);
/// Index for property description
Index descriptionIndex On description [ Unique ];
}

*************************

Class Utility.person Extends %Persistent
{
Property types As list Of Utility.contacttypes;
/// Date Setup to recreate an error
ClassMethod DataSe
5
0 420
Edit
Question Laura Cavanaugh · May 12, 2017

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

0
0 0
Question Arpitha Ramakrishnaiah · May 11, 2017

Hi,

I would like to know if there is any code to compare and update two directories/namespaces for class files.
If file is present in directory1 and not present in diectory2, it should import the classfile.
If file is not present in directory1 and it is present in directory2, the corresponding file should be deleted from  directory2.

Please suggest code for the task.

Thanks,
Arpitha R

2
0 781
Article Rob Tweed · May 1, 2017 1m read

Something that shot up the popularity stakes last week was this article on a very interesting initiative: RealWorld:

https://medium.com/@ericsimons/introducing-realworld-6016654d36b5

I decided it would be a good idea to use this as a way of creating an exemplar implementation of a RESTful back-end using QEWD against their published API (https://github.com/gothinkster/realworld/tree/master/api)

The results are here:

https://github.com/robtweed/qewd-conduit

Actually it's the first 3rd-party implementation out of the blocks!

Although I state that it uses Redis as the database, you can seamlessly swap i

14
0 1415
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert? 

To be honest, the description of CPUPct was excluded from the

0
0 5
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert? 

To be honest, the description of CPUPct was excluded from the

0
0 11