#Caché

30 Followers · 4.5K Posts

  

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

Documentation.

Question Mohan Sujay · Oct 12, 2016

hi,

1. Created a class(test) and added a classmethod(checkdata).

2. Assigned a object with xml.

3. Created a new class for response and initialized in classmethod(checkdata). 

4. Created a new class for request parsing with list of object parameter.

5. While parsing xml in request for list of object,  the  result count is "0". But the xml has value for "2" object list.

6. XML has follow:

<Request>
    <party>
        <to name=""mohan"" address1=""India""  />
        <to  name=""sujay"" address1=""USA"  />
    </party>
</Request>
4
0 965
Article Mike Kadow · Oct 24, 2016 2m read

NewBie's Corner Session 22 Parameters Part III

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Parameters

In Sessions’ 20 and 21 on Parameters we saw how to call one routine from another with parameters as well as calling one Label from another with parameters. In these examples, the data was passed through the parameters from the calling routine or label to the called routine or label.

Now suppose you wanted the called routine or label to pass data back?

There are two ways** of doing this.

1) Returning a Status through a User-Supplied Function

2
0 391
Question Heikki Koivulehto · Oct 26, 2016

We are finally planning to migrate some ancient Caché applications that are run on Caché 5.0.21 to a new server with Caché 2016.2.0 or so.

I wonder if we could use Shadowing between those to keep the data on the new server up to date?

We would copy the Caché backup from the old environment to the new and do a RESTORE there and then start shadowing.

I know than 5.0.21 is no more officially supported by ISC.

5
0 821
Article Alexey Maslov · Sep 30, 2016 2m read

After reading Stephen Wilson's article "Windows 7 performs shutdown too fast for Cache to close and so it gets forced down" I've recalled another solution that was based on Local Group Policy, which allows to control extra actions that should occur on computer startup or shutdown. How to add a computer shutdown script is well documented in MS Technet article. In short:

1
0 1118
Question Paul Mathieson · Oct 26, 2016

Hi All,

            I have a general query in regards to developers experience on extracting data from cache databases and the most efficient way to do so. I work with a number of clients who have applications with cache databases and require the data off the host system and onto data warehouse platforms for research and analysis. Often they require the data in source state which means the extracts are often simply a table scan of the entire database table without any aggregation or manipulation.

2
0 1919
Question Simcha Gershon · Oct 26, 2016

Hi All

When using a select :

  {type:'$input',id:'Table-Alert-Alert', key:'Table-Alert-Alert', inputType:'select', children: [
              { type: '$loop', value: '=[AlertTList]',children: [
              {type:'$option', value:'=[id]', selected: '=[selected]', $content: '=[AlertText]'}
              ]}
         ]},
I can get only value & text of the selected object :

2
0 333
Announcement John Murray · Oct 25, 2016

We at George James Software recently released a new version of Deltanji, the native source code management tool for Caché, Ensemble and HealthShare.

Version 6.1 includes several enhancements, including easy creation of labels. Bulk transfer of large codesets is also now available from the browser UI.

A perpetually free "install and go" Solo Edition of Deltanji is available. Licenses can be purchased for other editions that provide more advanced code management and deployment features.

Deltanji is compatible with Atelier. It can also manage external files.

0
0 586
Question Benoit Nyssen · Oct 24, 2016

Hello,

I'm a beginner in HealthShare, and I start to develop with caché some dataflow.

Some of my business process exist in java code.

Is-it possible to call these packages from caché classes ?

If it is, how can I do it in Caché classe ?

Thanx

2
0 620
Article Mike Kadow · Oct 24, 2016 3m read

NewBie's Corner Session 21 Parameters  Part II

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Parameters

In the previous session we saw how to call RtnB from RtnA with Parameters.

We also defined Parameters as another name for Variables when used in passing data from one Routine to another, or, from one Label to another.

Calling a routine from a Label, or to a Label, from within a routine is very similar to calling a routine itself.

To call a Label in the current routine would look like:

0
0 296
Announcement Stefan Wittmann · Oct 21, 2016

I am happy to share the news that Zen Mojo 1.1.2 has been released. This release includes a critical fix for Firefox that we had to get out as fast as possible. No other changes are included to allow easy upgrades. We recommend upgrading to this release if you are running on Zen Mojo 1.1.1.

All upcoming Caché and Ensemble releases will ship with Zen Mojo 1.1.2.

You can download Zen Mojo kits from the WRC distribution page: https://wrc.intersystems.com/wrc/Distribution.csp

Any fix or enhancement that was previously planned for Zen Mojo 1.1.2 will be included in the next upcoming release 1.1.3.

0
0 381
Question Jiri Svoboda · Oct 21, 2016

Hello,

does anybody know how to differentiate ZSOAP failures when using %SOAP.WebClient? I would need to know what error condition occurred, e.g. authorization failed, endpoint timeout etc.

All I get on failure is an ZSOAP exception which does not seem to explain anything specific.

Thanks

Jiri

2
0 451
Article Sylvain Guilbaud · Oct 19, 2016 7m read

Context: 

mirrored configuration with one primary member and one async member (without failover/backup member)

Purpose:

replace the CACHE.DAT of a mirrored database on the primary member.

 Steps to follow:

  1. on the PRIMARY
    1. remove the database to replace from the mirror
    2. dismount the database
    3. copy the new database
    4. mount the database
    5. add the database to the mirror
    6. backup the database (external backup)
  2. on the ASYNC
    1. remove the database to replace from the mirror
    2. dismount the database
    3. restore the new database backup from the PRIMARY
    4. mount the database
    5. activate database
    6. catch up database
3
0 1081
Question Scott Beeson · Oct 18, 2016

This tells me that there is no timezone offset on this table/field:

Select TOP 1 GETDATE() as Now, TimeCreated FROM ens.messageheader ORDER BY TimeCreated DESC;
Now                 TimeCreated         
------------------- ------------------- 
2016-10-18 16:16:49 2016-10-18 16:16:31 

So why is TimeCreated in this resultset 4 hours less than OneMinuteAgo when I'm clearly requesting only records with a TimeCreated greater than OneMinuteAgo?

13
0 917
Question Tirthankar Bachhar · Oct 20, 2016

Hi,

When we write unit test cases for cache object script code using %UnitTest.TestCase, what  is the best way to write code to identify code coverage?

So, let say my unit test case hit all 10 lines of code of a method for a given class. So, unit test coverage should be 100% for that. But, using line-by-line coverage [(%Monitor.System.LineByLine] getting wrong percentage, because it also includes code comment/documentation as part of code. So, practically we can not ever achieve 100% of code coverage by using this API.

2
0 938
Question Paul Riker · Oct 17, 2016

I have a persistent class where I am logging each CCDA I receive. I want to store all of the providers associated to that CCDA (many to one). In a relational database, I would have a child table with a foreign key to the primary table. I'm guessing the equivalent to Cache would be 

1. Create a custom class (ProviderList) with the properties I want to store.

2. Add the class as a property of my CCDA persistent class.

Property Providers as Array of ProviderList (SQLProjection = "table/column";

Am I on the right track?

4
0 613
Question Laura Cavanaugh · Oct 17, 2016

Hello community; this may seem odd, but I need to know if there's any way we could be using callin functions from a C application without knowing?  e.g. if other developers created some C programs that call in to Caché that we don't realize are running.  Is that possible?  If so, where would I look to see these programs?  Perhaps the server's task manager? 

Thanks --Laura

2
0 420
Article Jose Ruperez · Oct 13, 2016 1m read

Here you have an easy way to write and execute COS code from your unix scripts. This way one does not need to write routines or even open Studio or Atelier. It can be an option for simple and small actions for instance things like installation tasks or compiling.

See sample bash script (compile.sh) to compile classes:

2
0 995
InterSystems Official Steve Brunner · Oct 13, 2016

InterSystems is pleased to announce that Caché and Ensemble 2015.2.5 are now available as maintenance releases.

 

For a complete list of the corrections in 2015.2.5, please review the release notes.

 

Caché and Ensemble are available for the same platforms as 2015.2.4.  The complete set of supported platforms, including specific point releases and patches, is detailed in the Supported Platforms document.

 

The HealthShare team will announce availability of its products separately.

 

The build corresponding to this release is 2015.2.5.953.0

0
0 472
Article Elizabeth Harding · Oct 10, 2016 3m read

At Global Summit back in April, in his keynote speech, John Paladino mentioned that improvements to our documentation search were being made.  You might have wondered, since things seemed to go quiet, whether anything was really happening.  Well, we had an internal demo of some of the upcoming features recently, and the new capabilities look really cool – searching documentation has been frustrating for InterSystems staff too!  So, I thought it might be good to pass on a few details to give a taste of what is coming.  Of course, InterSystems will be putting together much better information

4
0 576