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.

Disclaimer I: While I will be talking in passing about the

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). 

I know now there are concepts of file locks and logs for when certain tasks are ran or when a user maybe edits a file

I was thinking there might be a way to get that Info because of the fact of being logged in through

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).

 

Hi, Community!

For those who plan to attend Global Summit 2017: we introduced the new reward:  the first-row seat reserved for you on the Key Notes session.

Explain data expression and selection expression?

Hi, Community!

I'm pleased to announce that we introduced the second release on DC in August.

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 -->
<!--<submit caption="Login" id="login"  /> -->
<button caption="Login" id="login" onclick="zenPage

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

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

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. Is there any way to make a DotNetGateway port "stay connected" or 
something to search who is occupying the

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

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.

In $system.SQL.Shell(), it would also report the number of global references for a given query.

Is it possible that I could also get this statistics from the %SQL.Statement interface when I launch a dynamic sql?

Thanks.

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…

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",.db)
1
SAMPLES>w db
^^c:\intersystems\ens171\mgr\cachelib\

I want to retrieve all the names of classes which are %Persistent in a namespace by COS.

Any suggestion, Thanks.

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

Has anybody defined their own Cache ObjectScript (COS) commands and symbols? Is it even possible? For a list of currently used commands and symbols please use the following link.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS

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

<button caption="Search" onclick="zenPage.onSubmit();"

TablePane1 also has a JavaScript onselectrow method zenPage.onSelectRow() that gets the currently selected RowID.

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.getRowData(

I'd like to access and view the soap log. Apparently there is a global for that (^ISCSOAP) (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…), but insofar I have been unsuccessful finding the exact cache command for viewing the soap log or changing it so that it logs both incoming and outgoing traffic. Can anyone enlighten me?

I.e. I am trying stuff like:

set ^ISCSOAP("Log") = io   

write ^ISCSOAP("Log)

but those don't work.

I use %SQL.Statement. The original column names are not contained in the metadata.

Sample query:

SELECT
 column1->name as name,
 column2 age
FROM sample.table

How to get:

•  column1->name
•  column2 

I have a few productions that my developers named "TEST" and would ideally would like them to have more relevant names. Is there a way to rename a production? I tried exporting and deploying the production under a new name and it worked, but my new production is empty. Also I'd like to delete a production that is in a suspended state. When I attempt to delete the suspended production, I get errors that the production isn't stopped, so can't be deleted. I can't start it to clear the suspended status, either. I get the following error:

14:26:18.126:Ens.Director: Production 'CHSLI.TEST' starting..

Hi

I've got a Service that get ACK Messages originated by another system. 

I want to get the details of a Message when the ACK is CE (Failed Message).

I don't know whether this is the best approach but, at the moment, I have a DTL and I would like to search the Cache Database for a Message with the Control ID on the ACK in the MSA segment.

Any help with this would be great.

Tks.

Please excuse my ignorance. I am trying to identify what areas would be best to review in the System Dashboard (for Cache 2010.2) for performance issues with the database. It seems to be running slower than usual, but I am trying to find out the best way to go about identifying what the issue is.

The following are captures from the System Dashboard.

As always, thanks a lot for your help.

 Hi,

I have a process in which at the end i produce a zen report and then i need to send it to the appropriate person.

I've used "GenerateReportToStream" method.

after that i set a context var of type %stream.Object and send to an operation that's send's out the email. 

the email is received with the attachment, but upon opening the error is "Cannot display (fileName) is of invalid format".

If i need to attach or show something please let me know.

Thank's 

Guy

Hi,

I am new to coding web services and trying to connect to an API that returns its format in xml or json.

I have a class as follows.. when I run I get back a 6059 in my status - Unable to open TCP/IP socket to server

Can someone help me identify what I am missing?  Thanks

Class Common.WebDownload Extends (%RegisteredObject, %XML.Adaptor){ClassMethod Connect(){  Set aa=##class(%Net.HttpRequest).%New()  Set aa.Server="https://www.actualwebaddresshere.com"  Set aa.Location="/service/actual location path and my API key here/"  Set aa.ContentType="text/xml"  set bb=aa.Get()  break

Hi all, I'm running into an issue with the installation, it seems like almost everything is working alright but upon trying to actual access the Management Portal, the site cannot be reached. I've noticed that the terminal indicates that Sign-on is inhibited. 

To add some context, I've installed Cache following the Unix instructions for MacOS (El Capitan).I can share the log or any other info that may be helpful.Here is some of the terminal output from the installation if it would prove at all helpful.

DC readers running Caché etc on Windows, configuring the Telnet service to use SSL/TLS, and using the Caché Telnet client (CTerm.exe) to make the Telnet connections may like to know that there's a fault in 2017.1 and 2017.1.1 which prevents CTerm.exe from establishing the secure connection.

Workaround is to use a pre-2017.1 kit to install on your client machines (e.g. 2016.2.2), or to fetch the bin\cconnect.dll from an earlier version (I used 2016.2.2) and use it as a replacement for the 2017.1 / 2017.1.1 copy.

The issue is known to InterSystems  under ProdLog #146698 and is fixed by RFD1899,

I am trying to import the SalesForce Enterprise WSDL in InterSystems Ensemble Studio using the SOAP Add-In.However, when I do so I receive a class dependency loop, Error #5316 during compilation.The WSDL is the standard WSDL provided with SalesForce and works fine in SoapUI.In the SalesForce WSDL it is allowed for an object A to include an object B as an element, while at the same time object B is allowed object A as an element.I think this is what causes the class dependency loop for InterSystems.Does anyone has any suggestion how I can circumvent this error?

Hello -- Is there a way to load a JSON from a file.

I have a "JSON" file which has a sting 1035164 long with the following format: 

[
    {
        "id": "12345",
        "title": "John Smith",
        "image_uri": "https://<some URL>",
        "image_timestamp": "1496781334",
        "image_url":"https://<some URL>...