Caché

Caché eXTreme for .NET - direct access to globals from C#

Caché, .NET

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.

Iryna Mykhailova 30 October 2018

Last comment 5 hours 4 min ago

+ 4 2 6

comments

660

views

+ 4

rating

Export Report to Excel

ZEN, Caché

Hello, I created a Zen Report and I want to export to Excel. I read I can use $MODE=xlsx but my output in Excel is not correct. All 3 elements are condensed into one cell. Class AETMON.Report Extends %ZEN.Report.reportPage { /// Class name of application this report belongs to. Parameter APPLICATION; /// Specifies the default display mode used for this report if /// the URL parameter, $MODE, is not present.

Oliver Wilms 11 hours 50 min ago

0 0 1

answers

comments

views

rating

why does session timeout becomes 1840-12-31

CSP, Caché

qizi qizi 1 days ago

Last answer 1 days ago Last comment 12 hours 28 min ago

0 0 2

answers

comments

views

rating

receiving more than 20 SHDWCBLK process running background when i try to shadow 5 namespace

Caché, InterSystems IRIS

Why i am receiving more than 20 SHDWCBLK process running background when i try to shadow 5 namespace ?

Jhuffare khan SA 1 days ago

Last answer 20 hours 15 min ago Last comment 1 days ago

0 0 2

answers

comments

views

rating

How many process does cache instance will take for one database shadowing

Caché

Hi guys,

   Environment:
       Cache for Windows (x86-64) 2017.2.1 (Build 801U) Wed Dec 6 2017 09:07:51 EST
   Platform:
       Windows Server 2016
   We have mapped 6 Databases for Shadowing to shadow/backup server with same kind of environment and platform.
   The process for shadowing is growing or keeps on running in back round, not sure whether it will die or not - refer screenshot

   We want to know how many process does cache instance will take for one database shadowing

Gopinath R 1 days ago

Last comment 1 days ago

0 0 2

answers

comments

views

rating

Data Innovations Instrument Manager Backups on a VM

Backup, DevOps, Microsoft Windows Server, System Administration, Caché

We are currently implementing the Data Innovations Instrument Manager product. In setting up our backup process we are wanting to use Veam snapshots. The application runs in a Caché 2016.1/Windows Server 2016 instance. We are running an HA primary/secondary/arbiter config. The statement below is from DI. I am curious to see what others that have implemented the DI Instrument Manager in the same or similar config have in place for backup.

"DI recommends is recommending that we not perform snapshots, but if you do choose to do so, here is some important information to consider.

Rick Clayton 1 days ago

Last comment 1 days ago

0 0 3

answers

comments

views

rating

Adding a new field to a web service API call

Web Services, Caché

Currently one of our applications, coded in Cache, performs web service API calls out to one of our vendors. We now need to be able to send a Client ID in the portion of the Soap envelope.

I think I have a clue of what I need to do but not 100% sure. We were thinking we could use the method %SOAP.WebClient.SetHttpHeader(field name, value) but when I have tired using this method and looked at the Soap log to see what is sent, the field is never showing. I realized I could be setting the wrong object using the method.

Kristina Roberts 2 days ago

Last answer 1 days ago Last comment 1 days ago

0 0 2

answers

comments

views

rating

##class(%SQL.Statement).%ExecDirect() method not work

Caché, InterSystems IRIS

Hi Team,

When I use below statement , I got SQLCODE=0.

SET rs = ##class(%SQL.Statement).%ExecDirect(, "SELECT * FROM LISDB.ExternalUsers WHERE UserId = 83")

If I display above query using Write (rs.%Display()) it gives me below result but (rs.%Get("Prefix")) method give me null value.

Please help

Vivek Nayak 1 days ago

Last answer 1 days ago

0 0 2

answers

comments

views

rating

Cache and SQL Performance

Caché

We often have troubles with performance when joining tables with about 10 million rows together.

Sometimes we can't say what the cache engine is doing, it's just sucks and never finishes.

Then we have to rebuild the query and loop first on Orders and then on OrderPositions.

this is what we want:

EDITED: the join was only forgotten

reinhard lebensorger 2 days ago

Last answer 2 days ago Last comment 2 days ago

0 0 4

answers

comments

views

rating

What is the simplest/quickest way to detect that Journaling was switched to a new file?

Journaling, Caché, InterSystems IRIS

My fantasy didn't go beyond periodically running %SYS.Journal.System:Progress() class query, while I'd prefer to use an event handler of some kind. Any ideas?

Alexey Maslov 7 August 2019

Last answer 3 days ago Last comment 2 days ago

0 0 4

answers

comments

175

views

rating

Create GUID

ObjectScript, Caché

Is there a system function/method which can create a GUID ?

Vladimir Prushk... 9 June 2016

Last answer 9 June 2016 Last comment 2 days ago

+ 1 0 2

answers

comments

702

views

+ 1

rating

Features of *ENSTEMP

Caché, Ensemble, InterSystems IRIS

ENSTEMP was addressed already some time ago;
Article: Preventing Globals From Getting Journaled (Continued from How do I Minimize My Journals)

and is also in public documentation
Where InterSystems IRIS Stores Temporary Production Data

Though I'd like to understand if this is just naming a non-journaled DB
or are there also typical features of CACHETEMP / IRISTEMP related to it:

automatic clean-up at system startup
keeping Global Buffers in memory as long as possible
late writing to the storage file

In other words is it a 2nd, 3rd, .. fully feature blown IRISTEMP ?

Robert Cemper 6 days ago

Last answer 2 days ago

+ 1 0 0

answers

comments

views

+ 1

rating

Creating custom SNMP OIDs

Monitoring, System Administration, Visualization, Caché

This post is dedicated to the task of monitoring a Caché instance using SNMP. Some users of Caché are probably doing it already in some way or another. Monitoring via SNMP has been supported by the standard Caché package for a long time now, but not all the necessary parameters are available “out of the box”. For example, it would be nice to monitor the number of CSP sessions, get detailed information about the use of the license, particular KPI’s of the system being used and such. After reading this article, you will know how to add your parameters to Caché monitoring using SNMP.

Mikhail Khomenko 13 February 2017

Last comment 3 days ago

+ 10 0 4

comments

5687

views

+ 10

rating

Replacing character groups

Code snippet, ObjectScript, Caché, InterSystems IRIS

What's the best way to replace character groups?

I want not to remove character groups as $zstrip does but to replace them with whitespaces.

$translate needs explicit character list.

Effectively I want to remove any characters besides letters, numbers and a small (known) subset of punctuation characters, replacing everything else with whitespaces.

Eduard Lebedyuk 5 days ago

Last answer 4 days ago Last comment 4 days ago

0 0 3

answers

comments

views

rating

Mirror Problem with SSL

Mirroring, Caché

I'm trying to create a simple mirror with two Cachés 2016.2.1.803 Instances,

but after i create the mirror with the primary and try to connect the fallouver server, i receive the following message:

ERRO #2071: Erro ao recuperar informações do conjunto espelho para 'BPLUS'. Erro: Connection failed: Unexpected error: <READ>SSLServer+191^MIRRORCTL

i'm not using ssl on this configuration, tried with arbiter and without, same effect.

Tried with Caché 2018.1 and Caché 2016.2.1, same problem.

Some tips?

Best,

Guilherme Silva 5 days ago

Last answer 5 days ago

0 0 1

answers

comments

views

rating

Implementing concurrent access to shared resources using Semaphores

Best Practices, Tips & Tricks, Tutorial, Caché

If you’ve ever wondered whether there is a way to regulate access to resources in Caché, wonder no more. In version 2014.2 special classes were added that allow developers to work with semaphores.

Iryna Mykhailova 25 September 2018

Last comment 6 days ago

+ 2 1 3

comments

415

views

+ 2

rating

Tips on exporting and importing security settings

Security, Caché, InterSystems IRIS

InterSystems Data Platforms products allow you to export and import security settings in two different ways. This article talks about those options:
- On the command line, using ^SECURITY
- Programmatically, using the Export and Import methods of classes in the Security package

Exporting settings on the command line (^SECURITY)

You can export everything or individual sections of the security settings.

Joshua Lubarr 6 days ago

+ 3 0 1

comments

views

+ 3

rating

SQL concatenation for more than 2 columns

Caché, InterSystems IRIS

Hi,

I am implementing free search text box, which can search data in all columns of tables.

I have created DisplayName column by concatinating two column data with space.

SELECT TOP ALL FirstName||' '||LastName AS DisplayName, UserType, IsActive, RoleName, DOB FROM LISDB.ExternalUsers

Now, in where condition I want to do like search in DisplayName column but it not working.

I have tried both fn CONCAT and || in like query but both are not working for me.

Amit Prajapati 7 days ago

Last answer 6 days ago Last comment 6 days ago

0 0 3

answers

comments

Performance, XML, ZEN, Caché

Hi,

I have a large XML zen report file that I want to convert to a CSV, what is the most efficient way to do it.

XML file:

<Details>
<Col1> aa1 </Col1>
<Col2> bb1</Col2>
<Col3> cc1 </Col3>
</Details>
<Details>
<Col1> aa2 </Col1>
<Col2> bb2</Col2>
<Col3> cc3 </Col3>
</Details>

Expected Output:

Col1,Col2,col3
aa1,bb1,bb1
aa2,bb2,bb2

Thank you.

Rizmaan Marikar 10 days ago

Last answer 9 days ago Last comment 8 days ago

0 1 3

answers

comments

124

views

rating

Open Exchange App Creating a OData API Adapter for InterSystems IRIS

REST API, Caché, InterSystems IRIS

In this article, we will explore the development of an IRIS client for consuming RESTful API services that have been developed to the OData API standard.

We will be exploring a number of built-in IRIS libraries for making HTTP requests, reading and writing to JSON payloads, and seeing how we can use them in combination to build a generic client adaptor for OData. We will also explore the new JSON adapter for deserializing JSON into persistent objects.

Sean Connelly 8 days ago

Last comment 8 days ago

+ 2 0 1

comments

views

+ 2

rating

How to use WriteSOAPBodyMethod method?

Web Services, Caché

Would anyone please have an example of how to use the WriteSOAPBodyMethod method?

The webservice method I'm trying to overwrite the body looks like this:

Carlos Salomao 9 days ago

Last answer 9 days ago Last comment 8 days ago

0 0 1

answers

comments

views

rating

Is there a function similar to Oracle's CDC in the cache database?

Caché

After enabling archiving log functions, Oracle can get real-time change data through CDC.

Can Cache database realize such functions?

My requirement is to take incremental data from the cache database regularly every day and synchronize it to other relational databases.

Incremental data can be text files.

xiao jikang 17 September 2018

Last answer 20 September 2018

+ 3 0 6

answers

comments

385

views

+ 3

rating

%File: Method Exists returns TRUE also for directories?

ObjectScript, Caché

Hello,

I had an issue when using the method Exists, I noticed that if you provide a directory for this method it returns 1.
This is really misleading, because sometimes the input could be a directory and the only way to predict this is to also test if the file is a directory.

I didn't tested using the Attributes method, but I supposed that this means could also be a solution for that issue.
But still, I expected the Exists method to return 1 for files and 0 for directories, since there's also method called DirectoryExists already.

Rubens Silva 12 days ago

Last comment 10 days ago

0 0 1

answers

comments

views

rating

Hapi Fhir

Java, JDBC, ODBC, Caché

How can i access the model Patient class file from org.hl7.fhir.dstu3.model jar in spring boot

Mani Vetri 10 days ago

0 0 1

answers

comments

views

rating

%String to XML

ObjectScript, XML, Caché

I've got a string variable which I need to convert into a XML one.

My main goal here is to use the XML bit I've extracted from a HTML file in a message I need to pass over to an operation.

I'm doing the following which always errors

classMethod WriteNodes(myfile As %String)
{
Set status=##class(%XML.TextReader).ParseString(myfile,.reader)

....

Any easy way of making this happen?

Kind regards

Joao Palma 18 February 2019

Last answer 22 February 2019 Last comment 11 days ago

0 1 4

answers

comments

236

views

rating

Description

Exporting settings on the command line (^SECURITY)