I needed to know programmatically if last ran failed or not.
After some exploring, here's the code:
ClassMethod isLastTestOk() As %Boolean
{
set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result)
for i=1:1:in.TestSuites.Count() {
#dim suite As %UnitTest.Result.TestSuite
set suite = in.TestSuites.GetAt(i)
return:suite.Status=0 $$$NO
}
quit $$$YES
}We are pleased to announce the availability of HealthShare 2019.1.
Hello All,
There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.
For Methods - Is there anything similar ??
I would like to see a similar approach as to the time taken for method to execute.
Is Studio Debugger only option ??
Hi Community!
We're pleased to invite you to the DockerCon 2019 – the #1 container industry conference for all things Kubernetes, microservices, and DevOps. The event will be held at the Moscone Center in San Francisco from April 29 to May 2.
In addition, there will be a special session "Containerized Databases for Enterprise Applications" presented by @Thomas Carroll, Product Specialist at InterSystems.
See the details below.
I have a query that I would like to have refreshing at certain intervals lets say every 30 seconds with out refreshing the page content using the META TAGS
refreshes the whole page but I have a jquery function that will run at those intervals that I can use the problem is getting the jquery to call my COS function or is the way to do it with pure COS
<html>
<head>
<!--meta http-equiv="refresh" content="30"-->
<!-- Put your page Title here -->
<title> Cache Server Page </title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
var auto_refresh = setInterval(
function ()
{
$('#load_tweets').load('#(..myquery())#').fadeIn("slow");
}, 10000); // refresh every 10000 milliseconds </script>
</head><body>
<div id="load_tweets"></div>
<script language="Cache" method="myquery" returntype="%Integer">&sql(select Count(*)INTO:COUNTER from Collection)
QUIT COUNTER
</Script>
</body>
</html>Hi all,
I'm facing the error 7802 ("Worker job/s unexpectedly shut down") when trying to work with the Queue Manager. Since today it was working fine, but suddenly today it started failing when arriving to the line:
Set sc=queue.WaitForComplete()
The method is pretty simple: first I invoke the queue manager by doing set queue=$SYSTEM.WorkMgr.Initialize("/multicompile=1",.tSc,64), and then into a loop I call a method exactly 64 times. Then after the first 64 processes are done, the system launches 64 more jobs.
Downloading the release notes for 2018.1 gives the 2017.1 PDF release notes.
Can someone please correct this or direct me where the release notes could be found
After many sleepless nights it's a pleasure to announce the newer, better, moderner ObjectScript compiler which implemented pretty much everything you ever wanted to have in modern ObjectScript:
But we not only parse the modern ObjectScript syntax, we have implemented finally the long-standing request which we always dreamed about. Closures!
In a Business Process (BPL) I noticed that if I 'm using a "scope" to handle errors then inside the "scope" when a "call" is used, the "request" and "response" action (i.e set for callrequest.prop = request.prop & response.prop = callrespones.prop does NOT work !
The result is that the values of those properties in the callrequest are nulls (I do see the properties names in the content of the callrequest message)
What is the best way to solve this issue ?
As it seems that there are new instances of the request/response objects inside the scope, whats the best way to pass them into the scope ?
I have a wdsl soap request that now requires a header. Where do I modify the header to allow this new value to be sent?
<soapenv:Header>
<Headers xmlns="urn:epic-com.2013.Interconnect.Headers">
<Epic-Client-ID>12349fe5-2ff8-4b79-b723-e69efbabcdef</Epic-Client-ID>Thanks
Scott
Hi Community!
New video is already on InterSystems Developers YouTube Channel:
Hi -
I was wondering how if the "old FHIR gateway" works with the latest release of HealthShare Information Exchange. Since there is an impact on the amount of storage needed to use the "FHIR Gateway 2 which uses the Operation Data Store (ODS)", my question is how (if at all) can FHIR access to Information Exchange work without ODS?
Thanks
I am trying to base64 encode a string with non standard characters encoded in utf-8 also tried windows 1252 and I am getting error like so
ERROR <Ens>ErrException: <ILLEGAL VALUE>zEncodeStream+18^ -- logged as '-' number - @' set encString = $TRANSLATE($SYSTEM.Encryption.Base64Encode(streamString),$C(10,13))' any help appreciated if anyone has faced this before
I have a lot of string properties, which need custom but similar Getters and Setters.
Currently I'm generating Getter and Setter in class generation code but that expands class definition.
Is there a way to specify custom datatype which would generate custom getters and setters?
The 2019.1 version of HealthShare Health Connect is now Generally Available!
Kits and container images are available via the WRC download site
The build number for these releases is 2019.1.0.510.0.18883
Health Connect 2019.1 includes many new features and capabilities, most notably:
These are detailed in the documentation and release notes for Health Connect
Upgrades - Health Connect 2019.
Hi,
I want to create a messages statistics group by month and year using deepsee. To do that I'm creating a DeepSee data model based on Ens.MessageHeader.
I added both SourceConfigName and TargetConfigName as dimensions and now I'm trying to add TimeCreated but I get these messages
ERROR #5001: Level in time dimension must have a timeFunction: TimeCreated.H1.TimeCreated
> ERROR #5490: Error running generator for method '%GetModel:User.Mensajes'
ERROR: %DeepSee.CubeDefinition.cls(%GetModel) of generated code compiling subclass 'User.Mensajes'
> ERROR #5030: An error occurred while compiling class 'User.Mensajes'
Compiling routine User.Mensajes.1I trying to get ACK back from the destination to the sending system.
I configured the Business Services to Ack Mode Application but sending system is getting Ensemble generated ACK [7] not destination ACK [9].
This is Ensemble 2018.1.1.312.0.
Ultimately I would like a NACK back when I have a Business Rule that blocks a messages from sending to Business Operations but currently [5] is an ACK |AA
|.
The titular question was quite relevant and often discussed some thirty years ago. The thought went: “Sure, there are industries where computers are the norm, but in my industry we got just fine so far, the benefits are questionable, problems innumerable and unsolved. Can we continue as before or should we embrace this new technology?”
Today, everyone asks the same question but about Machine Learning and Artificial Intelligence. The doubts are the same – lack of expertise, lack of known path, perceived irrelevancy to the industry.
Yet, as before, the correct, even the only possible answer is a resounding yes. Read on to find out why.
Hello everyone,
I'm trying to migrate the IDE for programming in COS, we normally use the Studio, but we want to use a more modern IDE. Our team has knowledge with Visual Studio plataform, but we couldn't configurate the compiler and terminal, I installed the extension InterSystems ObjectScript and tried to configurate to connect with my local machine, unfortunately the connection don't sucessed.
Someone has material for how i can connect and compile? Some material i saw show how to use the compiler, but not how can i do the configuration.
Best regards,
Flávio.
Hello All,
Our Group currently has the following version of Healthshare, and Ensemble installed:
Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2015.2.1 (Build 705U) Mon Aug 31 2015 16:53:38 EDT [HealthShare Modules:Core:14.01.7913 + Linkage Engine:14.0.7913 + Patient Index:14.0.7913 + Clinical Viewer:14.0.7913 + Active Analytics:14.01.7913]
We are planning on upgrading all of our instances from 2015.2.1 to the latest version (currently 2018) starting in May.
These instances are responsible for receiving data (i.e.
I am trying to get the time difference between two time stamps one is recorded earlier to the one happening current but the problem is sql expect string while I have the other stored in a variable and if I do the following I get errors any help please
&sql(SELECT {fn TIMESTAMPDIFF(SQL_TSI_HOUR,$ZDT($H,3,1,3),tx)})please note that tx is a variable holding the time formatted the same way as the one being compared to
Hi Community!
This is the update on what are the new applications submitted on OpenExchange in March 2019
New Applications
isc-tar published by @Dmitry Maslennikov
Compact files as TAR or Extract files from TAR files
Light weight EXCEL download v.1.0 published by @Robert Cemper
This is the working example of a light weight export to EXCEL based on data in SAMPLES namespace. Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input. With modern Browsers you don't even need and 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.
PythonGateway v.0.7 published by @Eduard Lebedyuk
Python Gateway for InterSystems Data Platforms.
Adopted Bitmaps v.1.0 published by @Robert Cemper
This is a running example of the Bitmap Adoption
WebSockets Tutorial v.1.0 published by @Lily Taub
A short tutorial on WebSockets in InterSystems IRIS 2018.1+ and Caché 2016.2+
Sync Data with DSTIME v.1.0.0 published by @Robert Cemper
Other Sync-Tools just work from Caché/IRIS to Caché/IRIS. Synchronizing your data to some external DB you requires some other solution. DSTIME can do it.
HL7 and SMS Interoperability Demo v.1.3 published by @Amir Samary
This demo shows how easy it is to integrate an Electronic Medical Record system that is sending HL7 messages with AWS.
Hey everyone,
I stumbled across a comment in this post that mentioned that the %SYS.GlobalQuery is a potentially faster alternative to %GSIZE. I tested it out and while I like the %SYS.GlobalQuery I noticed that it has some size discrepancies against a %GSIZE with details. Can anyone tell me which is more accurate for estimating the size of globals?
Here is an example of one of the differences I saw. From this it looks like the size is estimated to about 70gb from %GSIZE and about 67gb from %SYS.GlobalQuery.
%GSIZE Output:
Ens.
Hello everyone!
I need to have a ResultSet of type % SQL.Statement show its contents when it is trafficked in a message property by Business Process.
I tried to use the % XML.DataSet type that inherits properties of type % XML.Adaptor, but did not work.
Is there any other way to traffic as an object, other than within a Stream?
Note: I can not traffic Streams and I will not be able to use Correlate in this case.
On one of our servers, when I am in Mgmt Portal and click the link for Configure / CSP Gateway Management, I get this url:
but the page displays a 0, and nothing else. Literally, just a 0. This link works on our other servers, with the same URL. Any idea why?
Thanks,
Laura
You may have missed it, but it's here.
Now popups from SMP when you're restarting the instance or just lost connection can be suppressed.
All you need to do is set this global:
set ^%SYS("Portal","DisableConnectivityPopup") = 1
Available for 2018.1.2 and later. Documentation.
Thank you, @akoblovfor the find!
Hello everyone,
i am in process of changing our authentication method, so we can integrate our AD authentication in our programs. At the moment i am using they %SYS.LDAP object, and trying to use the .Bind() method with the user information to authenticate. This seems to work without issues, but here the problems start.
When i flag a user 'Change password on next logon' in our Active Directory, the Bind fails with a status error: "Invalid Credentials". To make sure the user who logged in is in fact the user to change the password.
I use Documatic a lot to generate class documentation from comments embedded in the code. Is there a good way to create documentation for SQL views as well? Ideally I want to document each column in the view with HTML markup similar to how I document each method of a class with Documatic.
We recently registered unavailability of the Web service in some moments. The application goes offline.
Analyzing the IIS logs and logs in "C:\Windows\System32\LogFiles\HTTPERR" I found nothing relevant.
Analyzing the CSP Gateway logs I noticed the following behavior when unavailability occurs:
>>> Time: Tue Mar 19 09:35:12 2019; RT Build: 1701.1606aa (win64/iis); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 6020
Initialization
The CSP Gateway module 'C:\Inetpub\CSPGateway\CSPms.dll' is loaded (IPv6 Enabled; MAX_CONNECTIONS=1024; MAX_SERVERS=10; MAX_APPLICATIONS=10; MAX_RESPONSE_BUFFER_SIZE=128000; Connection_Allocation=First Free; Nagle_Algorithm=Disabled; SHM=OS; IPC=WNP)
>>> Time: Tue Mar 19 09:35:12 2019; RT Build: 1701.1606aa (win64/iis); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 6316
Initialization
Windows Sockets library loaded (WS2_32.DLL) Version: 2.2
>>> Time: Tue Mar 19 09:35:27 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 7224
Error Condition
Exception caught in f:csp: c0000005:4600
>>> Time: Tue Mar 19 09:35:27 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 5348
Error Condition
Exception caught in f:csp: c0000005:4600
>>> Time: Tue Mar 19 09:35:27 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 8836
Error Condition
Exception caught in f:csp: c0000005:4600
>>> Time: Tue Mar 19 09:35:27 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 8928
Error Condition
Exception caught in f:csp: c0000005:4600
>>> Time: Tue Mar 19 09:35:27 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 3736
Error Condition
Exception caught in f:csp: c0000005:4600
>>> Time: Tue Mar 19 09:37:46 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: -1; Gateway-PID: 3536; Gateway-TID: 7308; Connection-No: 4; Server: csp; Cache-PID: 7196; Request-ID: 5; Session-ID: 5ELPK6TnFh; Remote-Addr: xxx.xxx.xxx.xxx; Page: GET /csp/erp/system/lib/filtro.csp
Error Condition
CSP application closed the connection before sending a complete response
>>> Time: Wed Mar 20 14:39:28 2019; RT Build: 1701.1606aa (win64/iis); Log-Level: 0; Gateway-PID: 4540; Gateway-TID: 2312
Initialization
The CSP Gateway module 'C:\Inetpub\CSPGateway\CSPms.dll' is loaded (IPv6 Enabled; MAX_CONNECTIONS=1024; MAX_SERVERS=10; MAX_APPLICATIONS=10; MAX_RESPONSE_BUFFER_SIZE=128000; Connection_Allocation=First Free; Nagle_Algorithm=Disabled; SHM=OS; IPC=WNP)
>>> Time: Wed Mar 20 14:39:28 2019; RT Build: 1701.1606aa (win64/iis); Log-Level: 0; Gateway-PID: 4540; Gateway-TID: 6620
Initialization
Windows Sockets library loaded (WS2_32.DLL) Version: 2.2
>>> Time: Wed Mar 20 14:39:29 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 4540; Gateway-TID: 5384
Configuration Error: Insufficient space in the configuration buffer
Configuration block Size: 126397; Size of configuration block to insert: 55114; Space available: 68611 (Consider setting CONFIG_BUFFER_SIZE=112K (or higher) in the [SYSTEM] section of CSP.ini)
>>> Time: Wed Mar 20 14:42:22 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: -1; Gateway-PID: 4540; Gateway-TID: 5384; Connection-No: 5; Server: csp; Cache-PID: 3864; Request-ID: 6; Session-ID: OQGM5Lp1Sw; Remote-Addr: xxx.xxx.xxx.xxx; Page: GET /csp/erp/system/lib-np/js/menu/menuCtrl.js
Error Condition
CSP application closed the connection before sending a complete response
>>> Time: Wed Mar 20 14:43:33 2019; RT Build: 1701.1606aa (win64/iis/mod:srv=8.5); Log-Level: 0; Gateway-PID: 4540; Gateway-TID: 5912; Connection-No: ; Request-ID: 20f; Session-ID: bTpfnzY1EW; Remote-Addr: xxx.xxx.xxx.xxx; Page: GET /csp/erp/system/modulos/spd/cads/spd001.csp
Diagnostic
Failed to connect to 'csp' - Reason: -8 (Server busy: Gateway's configured limits exceeded) (No Retry)
