Caché

Syndicate content 116 

InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET

Last comment 19 March 2019
+ 4   2 5
449

views

+ 4

rating

I am looking for a solution with Ensemble to talk to a old NTLM based SOAP Service. Does anyone has done this before?

We have the webservice calls working via SOAPUI but we are looking how we can make it work with Ensemble.

Is there a ready to use Outbound Adapter for NTLM ?

Thx.

Last answer 14 March 2017 Last comment 19 March 2019
0   0 3
279

views

0

rating

Is it possible to mimic what selenium does like navigating to a site and logging in  and filling out a form then logout in COS.I am trying to do that in COS using %Net.HttpRequest class or should I be using a different class the idea is to be able to call a web app login into it and fill out form and log out

Last answer 18 March 2019 Last comment 11 December 2018
0   0 3
159

views

0

rating

Database systems have very specific backup requirements that in enterprise deployments require forethought and planning. For database systems, the operational goal of a backup solution is to create a copy of the data in a state that is equivalent to when application is shut down gracefully.  Application consistent backups meet these requirements and Caché provides a set of APIs that facilitate the integration with external solutions to achieve this level of backup consistency.

Last comment 18 March 2019
+ 1   1 4
1262

views

+ 1

rating

I have a DR Mirror   with a WIJ that is 5 times as large as the Primary Failover member. My Read-Write Reporting mirror WIJs are the same size as the Primary.  I don't  know why the DR WIJ i so large and would like to shrink it to the same size as the others.  Any suggestions are welcome. Thanks!

Last answer 16 March 2019
0   0 3
0

comments

86

views

0

rating

Hi All,
 How to create Https request with Negotiate,NTLM Authentication in cache using %Net.HttpRequest package.
 I tried with basic authentication it is throwing >401 - Unauthorized: Access is denied due to invalid credentials.
 
 can anyone please guide me 
 
 Many Thanks !!
 Vicky

Last answer 15 March 2019 Last comment 15 March 2019
0   0 3
60

views

0

rating

Hi -

I'm having odd behaviors on my EC2 hosted IRIS Community instance.

When I configure a "custom login page" in the System Management Portal for my web application I'm seeing a few different behaviors that are under documented (and also undesired)

The old Caché documentation indicates that the custom login page could be a ".csp" file, but this seems to nor be the case (i kept getting "not found" errors, even though I could bring up the page directly from the url FOR the login.csp file. To get around this, I created an HTML file and then, at least, the login page could be found to be rendered

Last answer 15 March 2019
0   0 3
0

comments

45

views

0

rating

In recent discussion on CachéQuality I was (friendly) blamed for old syntax promotion and deliberate obfuscation of the code. Therefore I decided to clarify my point and shed some light on one of possible source of side effects that may unexpectedly occur with RETURN command with an argument.

Last comment 15 March 2019
0   0 1
169

views

0

rating

Hi there,

    I'm trying to develop a  program calling Cache REST service twice with Cors. The first is fetching some information of a patient with GET request, the second is using obtained information to call another REST service(implemented in the same class though) with POST to  perform other tasks.

Last answer 29 October 2018 Last comment 14 March 2019
0   0 3
498

views

0

rating

Sometimes global mapping of the same globals can be defined in different ways. E.g., I need to define it for 3 globals ^qAuditC, ^qAuditLog, ^qAuditLogC from the same database named APP-NOJOURN. Which approach should be better from the performance point of view?

1) qAudit* => APP-NOJOURN (one record in global mapping table)
or

2) qAuditC => APP-NOJOURN
qAuditLog => APP-NOJOURN
qAuditLogC => APP-NOJOURN (three records in global mapping table)

From one hand, the less records in global mapping table, the better. From other hand, * can cause additional processing at run time. Global mapping table for a namespace contains about 20 records and can be compressed to 15 ones if "unduplicated" such way.

Any advice will be great appreciated.

P.S. I'm pretty sure that there would be no globals masked as qAudit* but those listed above.

Last answer 11 March 2019 Last comment 13 March 2019
0   0 1
148

views

0

rating

InterSystems Data Platform includes utilities and tools for system monitoring and alerting, however System Administrators new to solutions built on the InterSystems Data Platform (a.k.a Caché) need to know where to start and what to configure.

This guide shows the path to a minimum monitoring and alerting solution using references from online documentation and developer community posts to show you how to enable and configure the following;

  1. Caché Monitor: Scans the console log and sends emails alerts.

  2. System Monitor: Monitors system status and resources, generating notifications (alerts and warnings) based on fixed parameters and also tracks overall system health.

  3. Health Monitor: Samples key system and user-defined metrics and compares them to user-configurable parameters and established normal values, generating notifications when samples exceed applicable or learned thresholds.

  4. History Monitor: Maintains a historical database of performance and system usage metrics.

  5. pButtons: Operating system and Caché metrics collection scheduled daily.

Remember this guide is a minimum configuration, the included tools are flexible and extensible so more functionality is available when needed. This guide skips through the documentation to get you up and going. You will need to dive deeper into the documentation to get the most out of the monitoring tools, in the meantime, think of this as a set of cheat sheets to get up and running.

Last comment 11 March 2019
+ 10   3 4
640

views

+ 10

rating

Hi Community,

I have to make a daily task (Job) which will run (7 am to 7 pm) in a day at an interval of 3 hours. Timings are as (7:00 am, 10:00 am,13:00 pm,16:00 pm,19:00 pm). But at each time when task will run i have to set a variables as per below condition

Sample:

1) If task run at 2019-03-19 07:00 am in morning

I  have to set two variables (start and end) whose value will become like this

(set starttime= 2019-03-09 07:00:00.00 and set endtime=2019-03-09 10:00:00.00)

2) But if task run at 2019-03-19 10:00 am in morning, the value should change as per below

(set starttime= 2019-03-09 10:00:00.00 and set endtime=2019-03-09 01:00:00.00

 

For setting the above variable as (set startime=2019-03-09 07:00:00.00) at 07.00 am on a particular day.

Query:1

I can use ($ztimestamp) to get UTC time and then convert it into local time i am using the below way is this correct

Last answer 9 March 2019 Last comment 9 March 2019
0   0 2
52

views

0

rating

Hi community,

I have a rights problem when giving a user permission to perform some select queries on particular tables. So I have created a user with the following rights.

So this all works well. No problem so far. But the customer is using a program where you can easily build visually the query by selecting the table, choose the right colums etc. So the problem we have is when I give the user the Role %All the tables are shown.

And the user is allowed to query all tables. But we only need to see the granted tables granted, so role %All is not valid but is the only Role, Permission I have tried so far that shows the table information correctly.

So what do I need to do for only showing table information (schema information) for the granted tables. 

Last answer 7 March 2019 Last comment 9 March 2019
0   0 5
70

views

0

rating

Can I apply a custom resource to a Management Portal page through code, using the method or global? The documentation only shows the manual mode: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_rsrcs#GCAS_C181701

Or export the settings already saved.

Last answer 7 March 2019 Last comment 8 March 2019
0   0 2
45

views

0

rating

I have a cache client trying to call a web service using  SOAP version 1.2.  We receive a SOAP error with the following text:

COD>w ##class(DBMS.Tools).DecomposeError(%objlasterror)

ERROR #6248: SOAP response is a SOAP fault: <Fault><Code><Value>s:Sender</Value>

<Subcode><Value>a:ActionMismatch</Value></Subcode></Code><Reason><Text xml:lang=

"en-US">The SOAP action specified on the message, '', does not match the HTTP SO

Last answer 6 March 2019 Last comment 8 March 2019
0   0 3
53

views

0

rating