InterSystems Developer Community is a community of 16,271 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side. I have tried some methods using %VID and similar methods, but these really don't seem to work as the value returned is related to the ID of the data and not the position in the results set. What would be ideal is if the value seen in the management portal when you check of "Row Number" was available to external queries through ODBC. I have not seen a way to return this however.

0 5
0 842

Hi All,

I am new to this technology and I have installed the trial version of cache 2016.1 with Normal security.

I was trying to develop the sample cinema application and mean while when I tried to view the csp webpage, it opens the browser and ask for login after logging in it shows Service Unavailable error instead of preview of webpage.

Could you guys suggest an answer to resolve this issue.

1 4
0 568
· Jan 6, 2017 4m read
Atelier, The XML Contents Editor

This article is one of the series which introduces Eclipse to experienced Caché/ Ensemble/ HealthShare users. The goal is to open the perspective of a developer who was using Caché Studio for years and make Her/ Him see deeply into the Eclipse world – far beyond Atelier. In other words it is an Atelier (Eclipse IDE for InterSystems technology) beginner’s guide. This time the topic is: editing XML files using Atelier.

2 0
0 676

I'm currently re-engineering an application from CSP pages directly accessing COS Methods, to an Angular/Material front end accessing a REST DAL. Both the Angular front end and REST services are hosted from the same Caché instance and the same namespace, but the REST services have their own CSP application, with all calls being routed through a Dispatch class.

0 5
0 492


I am facing issue with cache database it is part of schneider PES software..the issue started with below:

and after some reinstallation i became not able even to install it.

receiving always message:

0 2
0 323

the boss started using his new mac laptop, and now we are getting macintosh's own html escape characters being stored in the database especially in our text blocks, when we then print it we see things like don%u2019t instead of don't

so for example instead of the apostrophe we see %u2019 being stored. We've already noticed %u2018, %u2019, %u201C, %u201D, %2026

I'd like to replace the %u2019 with the nearest equivilent (especially when he starts to use left and right quote marks)

0 2
0 391

In response to a comment on his posting about source control hooks and Atelier Bill McCormick used the example of Studio's SOAP Wizard and talked about providing more information about how Atelier will support this kind of extension.

My Atelier (1.0.116) has a Tools menu with an Add-Ins option and a "Soap Wizard" (sic) submenu.

Is there any information available to us yet about how we can add our own add-ins of this kind?

2 7
0 442

Hi there,

I'm currently getting myself acquired with Atelier and apart from having a lot of fun I noticed an issue that keeps me from merging changes to the server. When importing Files into my project it uses the right encoding (without telling it what encoding to use). When trying to synchronize it shows the Conflict Resolution, with the server side using the wrong encoding therefore displaying gibberish.

0 1
0 244


My group and I are currently doing a research project on natural language processing and iKnow plays a big role in this project. I am aware that the algorithms iKnow use aren't public, and I respect that.

My question is, are there any public documents/research that explains, at least part of, the algorthims iKnow uses and the motivations for using them?

1 2
0 352
· Jan 3, 2017
Deciphering Error Messages

When deciphering an error message (<MAXSTRING>main+45^LBZNSJHCACUPLB), my understanding is the error offset is 45 lines from "main". If there are "go sub" entries within this 45 lines, do you count the lines in the "go sub" section or do you do a straight count of lines ignoring the "go sub" section?

0 2
0 408

Internally we use splunk for monitoring applications and network.

Does Ensemble have a way of exposing internal metrics and/or a way of exposing custom built metrics?

I've used Deepsee dashboards in the past to monitor Apache Tomcat/Apache Camel/hawtio using JMX rest calls. This is the other way around and ideally I'd like to expose metrics on:

0 3
0 1K
· Jan 1, 2017


I have detected an error in CACHE 2016.1.2, on both 32 and 64 platforms, when loading the autocad application, it fails. This did not happen in CACHE 2014.1.4.

0 2
0 330

Hi, I just installed the TRYCACHE 2016.2.1 preview release into a 16.04 Ubuntu VM. The install is dirt simple. Very nice. I've installed Eclipse Neon and used your update site link to get Atelier. Also very simple and nice. Thank you!

I see there is a January update coming. Will it be possible to include a license that lets developers launch one terminal session while connected to the TRYCACHE instance via Eclipse?

When I try to do this, I'm exceeding the TRYCACHE license limit.


1 1
0 363

Hi all (and specifically Eduard L. ;)

The Ensemble Workflow REST API provided here:

(and mentioned before in this Community, also as the basis of the Angular UI, also available in the same Git)

Has some very basic documentation as to how to work with the API (which also seems to be possibly a little out-dated as I think the /login URL is deprecated, for example).

Is there somewhere a more comprehensive documentation of this API?

1 3
0 570

I use DataGrip (JDBC client) to query Caché server via JDBC.

The problem I encountered, is that if I wait 10 or more minutes between queries I get an error:

[08S01][461] Communication link failure: Socket closed

To fix that I need to disconnect and connect to server again. Is there a JDBC timeout setting somewhere I can change?

0 1
0 1.5K

Currently, namespace Alpha is configured to use database AlphaDB as its global database. How would we go about having namespace Alpha configured to use database AlphaDB for its global database except where global ^Customers(CustomerId) has a CustomerId greater than 10M, which we would like to have it redirected to database BetaDB.

In other words, ^|"AlphaDB"|Customers contains all customers between 1 and 10,000,000; and ^|"BetaDB"|Customers contains all customers greater than 10,000,000. Any help would be appreciated.

0 4
0 456