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

Which works out nicely: it's accessible from any code invoked by the operation, it persists for as long as the operation is running, and I can clear it

10
0 1997
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 762
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 989
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: 

<If Condition='#{##class(%File).Exists("${AddonDir}/AddClasses.xml")}'><Import File=
11
0 604
Question Scott Roth · Mar 31, 2017

One of our Departments are claiming that we are loosing HL7 messages that are sent from their Vendor's system to Ensemble.

I know interfaces 101 if we have no record of the message then we never received it, however they are insisting they are sending it.

I asked them to provide the ACK's if they sent the messages but Ensemble had no corresponding Message Control ID (MSH.10) .

Currently I have the following settings...

Job Per Connection

 
Allowed IP Addresses
OS Accept Connection Queue Size
Stay Connected
Read Timeout
SSL Configuration

Local Interface

Framing

Pool Size
S
2
0 2002
Question John Murray · Feb 14, 2017

Early on in my use of DC I think I marked a couple of things as favorites. On the right-hand side of the DC listings I have this:

The first entry links to a post by Bill McCormick. The second links to the Field Tests group.

Is there a way for me to remove these entries? Or are they a remnant of some DC feature that has been superseded?

2
0 199
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 395
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 543
Question Paul Beckett · Mar 29, 2017

Following on from https://community.intersystems.com/post/custom-business-process-change-sendrequestsync-sendrequestasync we are refactoring a number of business processes to use OnRequest/SendRequestAsync/OnResponse mechanisms.

To prevent overloading some of our datasources we currently implement a simple caching system using locks similar to the code below.

Method OnRequest()
{    
    Set key = ..getKey(request)
    
    Lock +^DataCache(key)
    if ('..cacheValid(key))
    {
        Set status = ..SendRequestSync("DataProcess", dataRequest, .dataResponse)
    
        Set
1
1 1131
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 443
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

3/23/17-10:09:39:851 (3124) 0 [SYSTEM MONITOR] Mirror status changed.

14
0 2332
Question Lionel Marty · Mar 29, 2017

Hello,

I have a problem with an Ensemble instance on Windows to access to a network shared directory. Ensemble service (services.msc) is executed with a user which has access to this network shared directory :

 - When I try to copy or access files from a terminal ==> this is OK : the command w ##class(%SYS.ProcessQuery).%OpenId($Job).OSUserName returns the user defined in Ensemble service logon screen.

 - When I try to copy or access files from a service, process or operation item of the running Production ==> this is KO and the command ##class(%SYS.ProcessQuery).%OpenId($Job).OSUserName returns

6
0 1172
Announcement Evgeny Shvarov · Mar 30, 2017

Hi, Community!

There are plenty of questions on Developer Community every day, which is great!

And which is even better - there are plenty of answers! 

A few months ago we introduced a nice feature - 'accepted answer'.

'Accepted answer' is a checkbox on the left of every other answer you see in a question post. So it let's op to mark the particular answer as accepted one. If you do that, this question disappears from unanswered filter.

And, we introduced a special challenge of "Accepted answer" in Global Masters which gives 150 points for every answer which is marked as accepted.

 

So let's accept

0
0 307
Question Derrek Kegler · Mar 29, 2017

How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of: 0 to 499 500 to 999 1000 to 2499 5000 to 9999 10000 to 24999 25000 to 49999 50000 to 74000 75000 to 99999

=100000

2
0 516
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?

If we have to invoke a non-Caché ObjectScript program/function from within Caché ObjectScript then we will but we wanted

3
0 2367
Article Pete Greskoff · Jan 10, 2017 9m read

NB. Please be advised that PKI is not intended to produce certificates for secure production systems. You should make alternate arrangements to create certificates for your productions.
NB. PKI is deprecated as of IRIS 2024.1: documentation and announcement.

In this post, I am going to detail how to set up a mirror using SSL, including generating the certificates and keys via the Public Key Infrastructure built in to Caché.The goal of this is to take you from new installations to a working mirror with SSL, including a primary, backup, and DR async member, along with a mirrored database.

7
0 2776
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.

Now, if I do "ccontrol start <INST>" (ccontrol binary is from the mounted install dir), it complains that the instance cannot be found.

5
0 1008
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 609
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

This release of HealthShare Health Connect is based on the core

1
0 1170
Question Emilien Miossec · Mar 28, 2017

Hello us !

I want to use webservice CLS in Netbeans and use PHP development tool.

I create this

try {
    $wsdl_url = '[URL].ClassPatientServices.cls?WSDL=1&CacheUserName=[USER]&CachePassword=[PWD];
    $client = new SOAPClient($wsdl_url);
    $params = array(
        'ClsINOUTContext' => array('AccesCode'=>'CWP','username'=>''),
        'strINPatientIPP' => "91005573",
        'ClsOUTInfosPatient' => "patient",
    );
    $return = $client->GetPatientInfo($params);
    print_r($return);
} catch (Exception $e) {
    echo "Exception occured: " . $e;
}

Can you help me to use this webservice ?

2
0 463