Question Tom Philippi · Aug 23, 2017

Testing for not existing item in collection

I have a call in a business process that returns a response which may contain a collection of error message. I use the following code in my response builder to extract the messge value from the first error and map them to a context variable:

Set    context.ErrorMessage   callresponse.result.GetAt(1).errors.GetAt(1).message


This works nicely when an error comes up, however when no error is returned (i.e. the collection is empty) I receive an error: ERROR <Ens>ErrException: <INVALID OREF>zOnResponse2+4^Calarm.UserRegistrationProces.Context.1 -- logged as '-' number - @' Set status=1,context.

#Ensemble #Business Process (BPL)
2
0 391
Question Kurro Lopez · Aug 23, 2017

$Order and $Next in Cache Basic script

Hi all,

I need to create a routine to modifiy some values in a global.

My first attempt was:

    // Search the first position of Messages
    set pos=$Order(^Ens.MessageBodyD(""))
    while(pos > 0){
        // Get the class name
        set clase = $Order(^Ens.MessageBodyD(pos,1))
        if (clase="MensajesRestResponse")
        {
            // Do the convertion
        }
        set pos = $Next(^Ens.MessageBodyD(pos))
    }

but if I use a *.bas file (cache basic script), I'm not able to use these commands ($Order and $Next) and I don't know how to translate theses words.

#Caché #Globals #Object Data Model
3
0 576
Article Robert Cemper · Aug 23, 2017 2m read

Light weight EXCEL download

I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.

There is a great article Tips & Tricks - SQL to Excel

there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"

Where's the light weight export to EXCEL ?
Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input.
With modern Browsers you don't even need <head> and  <body> tags.
So the required code around your SQL result set is really slim.
And you are free to add any formatting you need either by HTML or in SQL.

#Caché #InterSystems IRIS #CSP #ObjectScript #SQL
Open Exchange
1
1 1730
Question Mike Kadow · Aug 22, 2017

Problem with Getting Started >>> Basic Tutorial for Atelier

I am trying to go through the "Simple Project" in Atelier Workbench User Guide >>> Getting started >>> Basic tutorial.

(http://docs.intersystems.com/atelier/latest/index.jsp)

 

Under "Using the popup" it says:

Using the popup

Now that we have our project we will create a folder. We will create our folder using the Project Explorer view's popup menu.

  1. Activate the Project Explorer view and select the project 'JaneQUser' (the first project we created in the Project Explorer view). From the view's popup menu choose New > Folder.
#Atelier #Beginner #Tutorial
3
0 588
Article Murray Oldfield · Apr 8, 2016 17m read

InterSystems Data Platforms and Performance Part 4 - Looking at Memory

This post will guide you through the process of sizing shared memory requirements for database applications running on InterSystems data platforms. It will cover key aspects such as global and routine buffers, gmheap, and locksize, providing you with a comprehensive understanding. Additionally, it will offer performance tips for configuring servers and virtualizing IRIS applications. Please note that when I refer to IRIS, I include all the data platforms (Ensemble, HealthShare, iKnow, Caché, and IRIS).

[A list of other posts in this series is here](https://community.intersystems.

#Caché #InterSystems IRIS #InterSystems IRIS for Health #Best Practices #InterSystems Business Solutions and Architectures #Performance #System Administration
3
9 11255
Question Mike Kadow · Aug 14, 2017

Atelier Installation Problems

Ok, I am trying to do my homework here but seem to be sinking.

I installed Atelier from the link    atelier-1.0.0AT.262.0-win_x64.exe  from at Atelier home page

(https://download.intersystems.com/download/atelier.csp)

Then I install Java from https://java.com/en/download/win10.jsp

I found the Atelier App but it gives this whole page of stuff and at the top it says I have an exit status code of 13.

I have looked through a number of post on Atelier and now am lost.

Any direction please?

#Atelier #Development Environment
5
0 499
Question Alexey Maslov · Aug 21, 2017

How to get a PID of Windows process called with $zf(-1,...)?

Hello everybody,

We have a piece of Caché software which calls an external utility using $zf(-1,command). It works fine under Linux, but under Windows an external process occasionally hangs (due to some internal problems out of the scope here) and need to be killed programmatically. Having PID, it's easy to kill a process. If a Caché process is called with JOB command, the caller can easily get its PID from $zchild, but alas $zf(-1) does not seem to return the similar info. Is it possible to get it somehow?

#Caché #API #Callout
4
0 798
Article Fabian Haupt · Jan 20, 2017 8m read

Visualizing the data jungle -- Part I. Let's make a graph

This is the first article of a series diving into visualization tools and analysis of time series data. Obviously we are most interested in looking at performance related data we can gather from the Caché family of products. However, as we'll see down the road, we are absolutely not limited to that. For now we are exploring python and the libraries/tools available within that ecosystem.

The series is closely tying into Murray's excellent series about Caché performance and monitoring (see here) and more specifically this article.

#Caché #Big Data #Object Data Model #Python #Tools #Visualization
4
1 1816
Question Coty Embry · Aug 19, 2017

Get user info on file change of .js and .* files

I was wondering if there was a way to if the user is using Studio and changes a file to get the users name and have a function run when the file is changed. 

Ive got this working for .int files but not for .csp or .js or .css or any other kinds of files. 

When we edit code we are logged in to the Cache backend’s server through Studio by using an iPaddress (which is on our network).

#Caché #Git #Compatibility
5
0 463
Question Marek Bernád · Aug 21, 2017

Can Atelier save export settings?

Good day, this is just question from  beginner, but I often use Atelier export to export my file as XML for Caché Unit Testing and I didn't find solution for my problem.

And every time I want to export I had to retype export settings again and again. On the other hand, studio always remembered my last exported data paths. Is there some option in settings to set Atelier to remember export settings please? Or there is some other way please, any ideas? (I use Atelier xml exports sometimes 30 times a hour)

#Atelier #Beginner
2
0 353
InterSystems Official Andreas Dieckow · Aug 21, 2017

Caché and Ensemble 2017.1.x on OpenVMS - Recall

Project related quality assurance efforts have revealed a number of concerns for the current release of 2017.1.0 and 2017.1.1 on all OpenVMS platforms. In certain situations, the impact can be severe. InterSystems will address these issues with the upcoming 2017.1.2 release, and in the meantime, will remove all 2017.1.x kits for OpenVMS from our Download Servers.
 
If you have immediate needs correcting existing deployments of this version, please contact the InterSystems WRC (support@intersystems.com).
 
#Caché #Ensemble #InterSystems Official #OpenVMS #Platforms #Release
0
0 749
Question Laura Cavanaugh · Aug 17, 2017

Server-side way to disable logins for all users

Hello all,

In my ZEN login page, I found a way  to bypass the submit button and force a user to click on the Sign In button, thus forcing the code to call my OnSubmit(), like this:

<!--ondefault="return true;"--><!-- this removes the ability to use "return" to login - forces button click to login -->

<loginForm id="loginForm"   ondefault="return true;">

<text name="CacheUserName" />
<password name="CachePassword" />
<!-- the submit button is special, and submits automatically without checking first -->
<!

#Caché #Authentication #ZEN
4
0 747
Question Murali krishnan · Jul 12, 2017

Estimation techniques in intersystems

how do we do estimation in Intersystems ? what is the unit of  work that we refer for intersystems ? let's say for example if we to add 200 fields how many business classes ( Business service, Business process, Business operations) that we must change  ?

Any thumb rule ? Please let know

#Ensemble
4
0 530
Question Scott Roth · Aug 1, 2017

PDFs and Reading them

I know there are numerous Java libraries available to scan a PDF meta data, but is there a way to scan a PDF using native cache object script? We are looking to take a PDF from an external vendor, scan for meta data, create the HL7 message, and embed the PDF within the HL7 message.

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

#Ensemble #Java #Object Data Model #ObjectScript
2
0 1616
Question Laura Blázquez García · Aug 16, 2017

DotNetGateway port already in use

We have some productions in Ensemble that uses DotNetGateway to use dll created with .Net. The DotNetGateway is configured with a port number, and then the operation uses that port.

But sometimes, suddenly Ensemble answers that the port is already in use, but it is only used by the DotNetGateway. And the only way to resolve this and make the port available again, is to restart the full server. We have tried to restart Ensemble, to kill the process that may be using the port and nothing.

#Ensemble #.NET
1
0 418
Question Nancy Grimes · Aug 8, 2017

Cache Cube v.2014.1.3.775.0.14809 Various Errors

After Microsoft updates my Cache Cube has stopped working.  I checked my cconsole.log and corrected my journaling errors.  However, I still receive Native Code 450 errors but now I am receiving Network Errors.  However, now there do not appear to be any errors logged in my cconsole.log.

I have reinstalled Cache Cube multiple times without success.  Can anyone please provide some assistance?

 

Thank you,

Nancy Grimes

903-786-2590

Nancy.Grimes2@va.gov

#Caché
4
0 405
Question Token Ibragimov · Aug 16, 2017

How ignore errors in XML response

Hi!

When trying to receive xml response 

set sc = ##class(%XML.TextReader).ParseString(str,.reader)

I'm getting error bellow: 

Invalid character (Unicode: 0x1A) while processing Anonymous Stream at line 2 offset 281

 

How I can ignore this error? Thank you.

#Caché
2
0 450
Article Rob Tweed · Aug 17, 2017 1m read

Creating REST Services with QEWD.js and Cache: Tutorial

 

Quite a few enhancements have appeared over recent months in QEWD for easing and simplifying the creation of REST-based services.  It's now even more slick and powerful,  allowing you to very quickly create very high-performance, highly-scalable REST (and Web) services that make use of Cache.

I've therefore updated the training presentation deck (Part 31 on developing REST Services with QEWD).  It describes all the new features with worked examples.  See:

https://www.slideshare.net/robtweed/ewd-3-training-course-part-31-ewdxp…

#Caché #JavaScript #REST API #Tutorial #SOAP
1
0 581
Article John Murray · Aug 17, 2017 1m read

How to determine if a class is mapped (e.g. from CACHELIB)

Here's one way to determine if a class is mapped (i.e. it is in a package whose definitions come from a database other than the default code database for the current namespace):

SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("Cinema.Film.cls")
0
SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("%iKnow.Objects.Source.cls")
1
SAMPLES>

If you pass a by-ref second argument to IsMapped you can also discover what database the class definition is stored in:

SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("%iKnow.Objects.Source.cls",.
#Caché #Object Data Model
0
0 725
Question Tom Philippi · Aug 16, 2017

Ensemble soap client misses soapaction http header

So I have an ensemble soap client which I use to send a message. The target web service is, however, giving a soapfault stating that my message misses the "SoapAction http header".

When I copy paste the message from my Cache Soap Log and fire it from Soap UI I get a proper response from the target web service. This suggests that my intersystems installation is somehow not including or losing some http headers. 

I am running Ensemble 2016.2 SUSE on an ubuntu machine.

Here is the InterSystems message with the http headers from Soap UI:

POST https://test.salesforce.com/services/Soap/c/40.

#Ensemble
2
0 1086
Article Murray Oldfield · Nov 25, 2016 23m read

InterSystems Data Platforms and performance – Part 8 Hyper-Converged Infrastructure Capacity and Performance Planning

Hyper-Converged Infrastructure (HCI) solutions have been gaining traction for the last few years with the number of deployments now increasing rapidly. IT decision makers are considering HCI when scoping new deployments or hardware refreshes especially for applications already virtualised on VMware. Reasons for choosing HCI include; dealing with a single vendor, validated interoperability between all hardware and software components, high performance especially IO, simple scalability by addition of hosts, simplified deployment and simplified management.

#Caché #InterSystems IRIS #Best Practices #InterSystems Business Solutions and Architectures #InterSystems Data Platform Blog #Performance #System Administration
7
1 3830
Question Stephen Wilson · Nov 22, 2016

How do you ensure synchronisation between two %ZEN.Component.tablePane objects?

TablePane1 is populated when a %ZEN.Component.button on a form is clicked from a JavaScript onclick method. 

 onselectrow="zenPage.onSelectRow()"

This JavaScript method gets the RowID and feeds it into ClassMethod GetAuditLogs(ByRef pRowId) [ ZenMethod ] to get the audit events for that record. 

ClientMethod onSelectRow() [ Language = javascript ]
{
 	var table=zenPage.getComponentById('table1');
	var dataRow=table.
#Caché #Frontend #ZEN
3
0 600