#Caché

1 Follower · 4.5K Posts

  

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

Documentation.

Question John Murray · Apr 6, 2016

Here is a screenshot from my 2016.2 FT instance of Studio and Ensemble:

I don't recall having seen the highlighted "+" suffix on document names previously. Who can tell me what it denotes?

I originally posted this in the Field Tests group but it turned out to be a 2016.1 feature that I hadn't previously noticed. So I subsequently moved the post to the Cache group.

11
0 899
Question Raghuram Devarakonda · Mar 30, 2017

Hi,

After restoring all the Cache related files on a machine, I am performing journal recovery using the command "^JRNRESTO". It works as described in the document and the recovery succeeds. However, the command is interactive. Is there a way I can run it in a programmatic way? I don't want to just supply a text file containing answers to all the prompts. I am wondering if there is way I can pass all the information upfront to the command.

Thanks,

Raghu

6
0 468
Question Bapu Hirave · Mar 24, 2017

here is my $ZV string "Cache for Windows (x86-64) 2016.2.1 (Build 803) Wed Oct 26 2016 12:43:35 EDT"

 two questions

1. How do i convert any Persistent object to JSON String ?

2. How do i convert an y Register object to JSON string ?

3. Do i need to extend from any adaptor class for 1 & 2 ?

11
0 5330
Question Alexandr Ladoshkin · Apr 4, 2017

Hello everyone. I have some problem with selecting my own globals from namespace. My task is select only globals created by me.  Follow my code, I get all globals from given namespace. 

SET NAME="" F  SET NAME=$ORDER(^$GLOBAL(NAME)) QUIT:NAME=""  DO

Please help me with excluding system globals. I need work only with my own globals.

2
0 382
Question Tamer Rajab · Apr 3, 2017

how to exclude weekend(Friday) in sql statement i trade use select datediff(WK,date1,date2) but not working even i chose (Dialect mssQL)

Thank You

1
0 379
Question Stefan Cronje · Mar 18, 2017

We are planning to use Caché users on a SOAP web-service, so the WS-security tokens will be used.
It will be username and password only for now.
The passwords should expire on a regular basis and this will be configured in the system-wide security settings.
The consumer of the web-service should be able to change their password on-demand or when it has expired, via a web-service call.

For the on-demand change, I can create a service method which can be called by the consumer to change the password.

5
0 2315
Question Massimo Sebastiani · Mar 30, 2017

Hello, we have a few hundreds of triggers to port from Oracle to Cachè for a migration project, and many of them have to change (for example, normalize a value, null it, etc) the value which is being inserted.

The documentation says "You cannot set {fieldname*N} in trigger code." , so we're unlucky.

Is there a good workaround for this ?

SqlComputeOnChange doesn't seem the best way, but I'm not totally sure: for example normalization and validation could have a better place somewhere else than a trigger.

2
0 435
Question Jorge de la Garza · Mar 10, 2017

What are the differences between a process private global and a percent variable?  Basically I have some code running in an Ensemble operation that processes requests, and it needs access to pieces of data that are scattered throughout XData blocks in various classes.  Rather than opening the XData object and deserializing the XML on each request, I opted to cache this data in a percent variable, something like:

set %MyVar(sub1,sub2) = myValue

10
0 1958
Question Stephen Wilson · Mar 29, 2017

I was wondering if anyone has combined ZEN Web Development with frameworks such as W3Schools W3.CSS Framework or the popular Bootstrap Framework

We are currently using Caché 2013.1.6 so we do not have ZEN Mojo installed which ships in Caché 2014.2 or later.

What would be the recommended approach if looking to integrate one of these frameworks?

I look forward to hearing your suggestions!

7
0 715
Question Evgeny Shvarov · Apr 1, 2017

Hi, Community!

Is there an option to get an archived file of globals in one command. Say for:

Do $System.OBJ.Export("Class1*D.GBL,Class2*D.GBL","data_gbl.xml")

get something like:

Do $System.OBJ.Export("Data*D.GBL","data_gbl.gz","gzip")

And also to have the convenient one click way to  import it to the namespace via terminal or Control Panel?

If anyone already has this module, share please?

It would be very convenient for import/export/continuous integration purposes cause globals can be really heavy.

8
0 957
Question Alexey Maslov · Mar 28, 2017

Due to a new project I'm getting involved inside %Installer stuff deeper than ever I'd be happy to. Most of it was pretty easy to get, thanks to documentation, articles and SAMPLES example, while I can't dig good solution for one problem. I'm trying to import and compile some classes, willing to ignore two types of errors: 5202 (NothingToCompile) and 5373 (PredecessorClassDoesNotExist - a normal case when SNMP sampling class is compiled for the 1st time, before it was registered). 

I've tried the following: 

11
0 573
Question Susobhan Pandit · Mar 31, 2017

I have multiple namespaces in a Cache environment say NS1 & NS2. I want to add some restriction so that  a routine running in the NS1 should not access any resource(global/routine) belongs to namespace NS2.

The above restriction need for few of the clients only, so we do not want to write any custom logic in code. 

We are looking for some solution provided by Cache where we can restrict the namespace access.

Can somebody please help me on this.

1
0 379
Question Raghuram Devarakonda · Mar 30, 2017

Hi,

I am placing Cache instance in backup mode by using the command:

    csession <INST> -U%SYS "##Class(Backup.General).ExternalFreeze()"

and I see in the console log a message similar to follows:

"Journaling switched to: /cache/mgr/journal/20170330.002"

Now, is there a way to programmatically find out this journal file name? In fact, I am interested to find out the journal file that is switched. For example, in the above case, that would be "20170330.001".

Thanks,

Raghu

4
0 518
Question Kevin Furze · Mar 30, 2017

Tried to access the forum over on google, its been taken offline because google has detected

Banned Content Warning

The group that you are attempting to view (Caché, Ensemble, DeepSee) has been identified as containing spam, malware or other malicious content. Content in this group is now limited to view-only mode for those with access. Group owners can request an appeal after they have taken steps to clean up potentially offensive content in the forum.

4
0 423
Question William Proctor · Mar 23, 2017

Hello,  Thanks in advance for all replies.  I have been practicing setting up mirroring between two development servers in preparation for mirroring our production server in a few weeks.  I started by setting the servers up with minimum security which worked easily, then I set it up in lock down mode again without any issues.  Now I am setting it up in lockdown mode with encryption and this one is testing me.  I have everything setup but my async dr member cannot connect to the primary.

from cconsole.log

14
0 2269
Question John Flippance · Mar 29, 2017

Hello,

We are working on creating a metadata file to accompany PDF documents produced by one of our third party systems for ingestion into our DMS.  One of the pieces of data that the metadata file must contain is the number of pages of the PDF document.

In Cache ObjectScript does anybody know if there is currently a way of counting the number of pages within a file (specifically a PDF) without invoking a non-Caché ObjectScript program/function from within Caché ObjectScript?

3
0 2323
Question Raghuram Devarakonda · Mar 26, 2017

Hi,

I am exploring a simple restore procedure for a Cache instance and would really appreciate any help.

Basically, I have a CentOS machine with a Cache instance and let us say I backed up all the mount points where Cache data is located (install dir, DAT files, journals, WIJ etc). On another identical machine (without Cache installed), I mounted all these file systems exactly using the same mount points so all the data is back with the same paths.

5
0 986
Article Andrei Luiz Nenevê · Mar 29, 2017 1m read

Hi everyone,

I've created an Identicon Generator inspired on Fabio GonçalvesCaptcha Validator.

This sample can be used to create Identicons for users of app for example, it can be useful to use in Zen Mojo applications, generating an identifier image based on name of the user by example, but it can be used in others kind of applications too(Zen, CSP etc)

Examples:

First one:

Will generate this:

 

And this:

Will generate this:

See my Github project: https://github.com/AndreiLN/Ikon

Best regards,

Andrei L. Nenevê

0
0 579
InterSystems Official Steve Brunner · Mar 28, 2017

InterSystems is pleased to announce the simultaneous release of 2017.1.0 of Caché, Ensemble, and HealthShare Health Connect v15.02 

Some notes for Caché and Ensemble, including highlights, are:

  • Enhanced OAuth 2.0 and OpenID Connect
  • FIPS 140-2 Validated Cryptography for database encryption
  • iKnow REST API
  • Improved DocBook Search and efficiency of Ensemble Message Search
  • For complete technical details of what’s changed, review the Caché release notes and the Ensemble release notes.
  • The version number for these kits is 2017.1.0.792.0
1
0 1140